Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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#>

from sql:

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

replied

Hello Daniel,

> 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).

@ Lars:

You have a tough job, but someone has to do it )

Regards

Stefan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question