Verifying a Database Backup with BR*Tools

Use

You can use BR*Tools for Oracle to verify a database 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 database backup.

       3.      Select the BRBACKUP database backup that you want to verify.

       4.      Set the required options:

Menu Entry

Equivalent BRRESTORE

Command Option

BRRESTORE profile (profile)

-p|-profile

BRBACKUP backup run (backup)

-b|-backup|b1|backup1

Verification device type (device)

-d|-device

BACKINT/ Mount profile (parfile)

-r|-parfile

Database user /password (user)

-u|-user

Use DBVERIFY (use_dbv)

-w|-verify

Files for verification (mode)

-m|-mode

Confirmation mode (confirm)

-c|-confirm

Query mode (query)

-q|-query

Compression mode (compress)

-k|-compress

Parallel execution (execute)

-e|-execute

Additional output (output)

-o|-output

Message language (language)

-l|-language

BRRESTORE command line (command)

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

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

       6.      Check the results in the BRRESTORE logs.

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

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

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