RE: Restoring from a cold backup and recovery is needed???

RE: Restoring from a cold backup and recovery is needed???

 

  


Actually, I have had it happen to me where I did a shutdown immediate, took a cold backup, and the restored database required recovery when I started it up.

Kathy
-----Original Message-----
From: Satheesh Babu.S [mailto:oracledba-ezmlmshield-x60628541.[Email address protected]
Sent: Thursday, September 29, 2005 1:39 PM
To: LazyDBA Discussion
Subject: RE: Restoring from a cold backup and recovery is needed???

If you have did proper cold backup by shutting down the server using shutdown immediate or shutdown normal, you don't require any redo log.
But looks like you have shutdown using shutdown abort and took the cold backup. If that case you need redo log to recover the db.

Thanks and Regards,
Satheesh Babu.S
Bangalore.

-----Original Message-----
From: Sexton Michael
[mailto:oracledba-ezmlmshield-x65939377.[Email address protected]
Sent: Thursday, September 29, 2005 9:02 AM
To: LazyDBA Discussion
Subject: RE: Restoring from a cold backup and recovery is needed???

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



--------
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



--------
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