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]



Oracle LazyDBA home page