Procedure documentationVerifying 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 Verification.

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 Start of the navigation path Backup and database copy Next navigation step Verification of archivelog backup End of the navigation path.

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

  4. Set the required options:

    Menu Entry

    Equivalent BRRESTORECommand 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_no1>

    Verification device type (device)

    -d|-device

    BACKINT/ Mount profile (parfile)

    -r|-parfile

    Database user /password (user)

    -u|-user

    Verification mode (verify)

    -w|-verify

    Recovery interval (interval)

    -i|-interval

    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.

    Note Note

    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.

    End of the note.

  5. To start processing 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>.rsa displays progress.

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