Skip to Content
avatar image
Former Member

online versus online_cons


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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 20, 2006 at 10:04 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded