Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Backup Scenario

user13549752Jun 6 2011 — edited Jun 6 2011
Database 10.2.0.4
OS :Solaris 5.10

I dont have a system to test it now so i am asking it here. My database is in archivelog mode and i have taken the cold backup of my database 3 days back. If my database crashes today can i restore and recover the database from that cold backup till the point it got crashed using all the available archive generated from the time of cold backup till the time of crash.

I am planning of the below steps

1.Restore the full backup
2.startup in mount state;
3.Recover database #will this command will recover the database till the last archive generated
or
4.Recover database using backup controlfile until cancel; #is this command will apply all the archive log till the time of crash. Can any body please explain what happens internally when we fire this command;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2011
Added on Jun 6 2011
4 comments
172 views