As to question 2, start and mount the database but do not open it, then issue a recover database command.

As to why, I always thought of that as one of those Oracle mysteries.

Bon Chance
Mike


-----Original Message-----
From: Yves [mailto:oracledba-ezmlmshield-x6832832.[Email address protected]
Sent: Thursday, September 29, 2005 11:30 AM
To: LazyDBA Discussion
Subject: Restoring from a cold backup and recovery is needed???

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