on 02-20-2006 3:19 AM
Hi
We have been using the online parameter in our backups.
brbackup -u / -c force -t online ....
I decided to test a restore and found it was impossible to restore from an online backup because the data files are never in a consistent state and keep looking for redo logs.
Using online_cons option you do not get this error because obviously it makes sure the datafiles are in a consistent state.
My question is ...does anyone know why SAP offers the online option if you cannot do a restore from it????
I'm using aix, oracle and netbackup.
Thanks
Jim
With online_cons the data files are still inconsistent. the only difference is that brbackup backs up the redo logs in the same backup as the datafiles, right after the data files and on the same tape.
If you use the standard online option you have to specify the backup of the archive logs seperately (or use option online+redo logs) when backing up. If you have backed up the redo logs seperately you can restore the backup and recover it in the same way as with online_cons.
The standard online option where you backup the redo logs seperately is more usefull in most cases as you have more control over the backups of the redo logs. You can for example specify that the redo logs are backed up to a different tape as the data files or that multiple copies are backed up for example one to the data files tape and a second copy to a seperate tape.
Hope this helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Adriann,
Thanks for your reply. I understand how online gives you more control over the tapes and redo logs. But what confuses me is at the restore stage.
From what I understand there should be no difference in how u actually do the restore...
Except for us it's possible to restore from online_cons but not online.
We issue the exact same commands except online allways looks for extra redo log files because system1.data seems to be in a inconsistant state.
I'm just wondering when u restore from an online backup should u do something different.:
Place cntrl file in the three locations and then
sqlplus >> startup nomount
sqlplus >> recover database until cancel using backup controlfile;
Enter Cancel
Choose AUTO
sqlplus >> alter database open resetlogs;
With online we can never issue
alter database open resetlogs;
because it returns:
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/XRP/sapdata1/system_1/system.data1'
Thanks
Jim
Hi Jim,
When recovering from a restored online + redo logs backup you need to add one more command (as long as you have recovered with all the required redo logs):
sqlplus >> startup nomount
sqlplus >> recover database until cancel using backup controlfile;
Choose AUTO
Enter Cancel
<b>sqlplus >> recover database cancel;</b>
sqlplus >> alter database open resetlogs;
Regards,
Adriaan
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.