cancel
Showing results for 
Search instead for 
Did you mean: 

online versus online_cons

Former Member
0 Kudos
952

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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!

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Adriaan

Did u make a typo?

SQL> recover database cancel;

ORA-00274: illegal recovery option CANCEL

Thanks

Jim