Have you tried to do the recover and see what it thinks is the problem? It might just need to point at the last active redo log (assuming you do have that)... I have seen that happen before.

M

>>> "Yves" <oracledba-ezmlmshield-x6832832.[Email address protected] 9/29/2005 11:29:54 AM >>>
I'm trying to restore a database from a cold backup onto another server. Using ORACLE 9iR2, I've created the control file and mounted the database.

When I try to open the database it tells me that it needs to recover.(ORA-01152 and ORA-01110)

Questions:

1) Why would a database need to recover if the backup was done when it was closed? (This has been confirmed by ORACLE support that the files were restored from a cold backup)
2) If it really needs to recover and I do not have the archivelogs, can is there a way to reset the scn and open the database anyway? (I know I might loose some data with this option)

Thanks for the help.

Merci / Thanks
Yves Leonard,
Chef de Projet / Project Leader,
DDS / SDD,
RH Coats, 13-I
Téléphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page