Verifying an Offline Redo Log Backup with BR*Tools 

Use

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.

Prerequisites

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

Procedure

...

       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)	-p|-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)	-d|-device
BACKINT/ Mount profile (parfile)	-r|-parfile
Database user /password (user)	-u|-user
Verify second copy (sec_copy)	-a2|-archive2
Confirmation mode (confirm)	-c|-confirm
Query mode (query)	-q|-query
Compression mode (compress)	-k|-compress
Additional output (output)	-o|-output
Message language (language)	-l|-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.