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.