Backup Scenario
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;