Verifying an Offline Redo Log Backup with BR*Tools


You can use BR*Tools for Oracle to verify an offline redo log backup, that is, an archivelog backup. BRRESTORE performs the verify.

For more information about database verify, see Backup Verify.


·        Make sure that you have set the necessary BRRESTORE parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRRESTORE.

·        Make sure you have the correct volumes for the verify.



       1.      Start BRGUI or BRTOOLS.

       2.      Choose Backup and database copy  ® Verification of archivelog backup..

       3.      Select the BRARCHIVE offline redo log file backup that you want to verify.

       4.      Set the required options:

Menu Entry

Equivalent BRRESTORE

Command Option

BRRESTORE profile (profile)


First sequence number (first_seq)

-a|-archive|-a1|-archive1 <log_no1>

Last sequence number (last_seq)

-a|-archive|-a1|-archive1 <log_no2>

Verification device type (device)


BACKINT/ Mount profile (parfile)


Database user /password (user)


Verify second copy (sec_copy)


Confirmation mode (confirm)


Query mode (query)


Compression mode (compress)


Additional output (output)


Message language (language)


BRRESTORE command line (command)

This shows you the BRRESTORE -a -w command that is to be executed using the current settings.

The following menu options refer to the sequence numbers of the first and last offline redo log file to be verified:

·         First sequence number (first_seq)

·         Last sequence number (last_seq)

BRRESTORE sets these according to the BRARCHIVE run that you selected.

If required, you can set these manually. In this case, the corresponding backups must all have been made to the same device type.

       5.      To start processing with the selected options, choose Continue.

       6.      Check results in the BRRESTORE logs.

Ў        The summary log rest<DBSID>.logdisplays the return code.

Ў        The detail log r<encoded timestamp>.rsa displays the progress.

For more information on how to view the logs with BR*Tools, see Showing Logs and Profiles with BR*Tools.