Online backup restore
I am planning to check the taken online backup ( DB13 ) on the same system for that will be using the following commands.Please check the commands and if there's any strangeness kindly point it out.
step 1)brrestore -m full -b abcdefg.anf
step 2) brrestore -a <startlog#>-<endlog#>
step 3) RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
step 4) ALTER DATABASE OPEN RESETLOGS;
Please check the sequence and give me your valuable suggestion.
I would appreciate your help
Stefan Koehler replied
> On the tape drive medium ,I have online(DB13) database backup and redo logfiles .I didn't talk anywhere about offline archive logfiles
Ok wait.. maybe you mix up two things:
Redolog files = Online Redolog files
Archivelog files = Offline Redolog files
You always backup the archivelog files in an ONLINE backup and never the redolog files itself.
If you really copy / backup the redolog files (=online redolog files) you can delete your backup.. it will be useless.
> Please correct me with exact commands to be used to meet my scenario
The commands that you have posted above are correct, i just want to point you to the fact that this scenario is an incomplete recovery. If you want to restore your database in this way in an emergency case, you will have a lost of data (the data from the current redolog file, the not archived redolog files and the not backuped archivelog files).
You have a tough job, but someone has to do it )