Show TOC

Procedure documentationDisplaying Logs for Redo Log Backups (Oracle) Locate this document in the navigation structure

 

Redo log backups provide information about backups of the offline redo log files for the Oracle database. The system displays the amount of free space available in the archiving directory and the number of offline redo log files from the last generation that have not yet been backed up.

Procedure

  1. Call the DBA Cockpit and choose   Jobs   Backup Logs  .

  2. In Redo log backups, choose one of the following:

    • To display an overview of the offline redo log files, choose Overview of redo log files:

      Heading

      Description

      Redo No

      Log sequence number

      Archiving Time

      Time the offline redo log file was created

      Tape

      Tape name

      Position

      Position of the file on the tape

      Backup time

      Time the offline redo log file was backed up

      Backint ID

      Backup ID of Backint interface (only if external backup program was used)

      Offline Redo Log Name

      Directory and name of the offline redo log file

    • To display an overview of all available backup logs for offline redo log backups, choose Overview of redo log backups (backups with errors are highlighted in red):

      Heading

      Description

      Function

      Type of backup

      Operation Start

      Time redo log backup started

      Operation End

      Time redo log backup ended

      RC

      BRARCHIVE return code

      For more information, see Messages and Return Codes for the BR Tools.

      Action ID/Log

      File system log name <Action ID>.<Function ID>

      For more information, see Names of the BRARCHIVE Detail Logs.

      To see more information about a redo log backup, double-click the appropriate line to display the BRARCHIVE action log:

      Heading

      Description

      Function

      Backup functions:

      • Save

        Creates first copy of the offline redo log file

      • Copy

        Creates second copy of the offline redo log file

      • Del

        Deletes offline redo log file from the archiving directory

      RedoNo.

      Log sequence number

      Archiving time

      Time the offline redo log file was created (that is, archived)

      Tape name

      Tape name

      Pos.

      Position of the file on the tape

      Backup time

      Time the offline redo log file was backed up

      Compr

      Compression rate (if compression was used)

      Backint ID

      Backup ID of Backint interface (only if external backup program was used)

      Offline redo log file name

      Directory and name of the offline redo log file

      To look at the system log for a redo log file in the backup, place the cursor on the relevant line and choose Detail log. For more information, see BRARCHIVE Detail Log.