Show TOC

Object documentationBRARCHIVE Summary Log Locate this document in the navigation structure

 

You can display a brief entry for every archived offline redo log file in the summary log arch<DBSID>.log. The entries in the file provide the following information about each archiving run with BRARCHIVE:

  • #ARCHIVE: log sequence number, name of the offline redo log files, creation time, file size, start SCN (system change number) of the offline redo log file, thread number

  • #SAVED: this entry depends on the type of archiving for the offline redo log files:

    • Archiving on tape

      Action ID (encoded timestamp of the log name)

      Function ID (extension of the log name)

      Name of tape/position of the file on tape, starting with the following:

      • # for tape_copy_cmd = cpio

      • $ for tape_copy_cmd = dd

      • + for tape_copy_cmd = rman

      • - for tape_copy_cmd = rman_dd

      • * for backup_dev_type = util_file

      • & for backup_dev_type = rman_util

      • @ for backup from disk backup with BACKINT

        Timestamp (date, time) specifying the end of the archiving process

        Compression rate and the size of the compressed file (if it was compressed) or save set key (if RMAN set backup)

    • Archiving using an external backup program

      Action ID (encoded timestamp of the log name)

      Function ID (extension of the log name)

      Backup ID returned by the external backup program (if the util_file option was used, an asterisk “*” or “@” appears before the backup ID)

      Timestamp (date, time) specifying the end of the backup

  • #COPIED: information as for #SAVED when the offline redo log files were archived a second time

  • #DELETED: information (action ID, function ID, timestamp) about when the file was deleted

  • #*: information on the status of a BRARCHIVE run: ORACLE_SID, device type (values like in backup_dev_type or null when offline redo log files were only deleted), action ID, function ID, timestamps (date, time) specifying the start and the end of the BRARCHIVE run, return code, the total compression rate (if compressed), first and last sequence number of saved offline redo log files, internal flag for the BRARCHIVE command options, and BRARCHIVE version

  • #DISK/#STAGE: this information appears if you used the BRARCHIVE feature for archiving to local or remote disk:

    Log sequence number, name of the offline redo log file, creation time, file size, start SCN (system change number) of the offline redo log file, thread number

  • #DISKSAV/#STAGESAV: archiving to disk: action ID, function ID, name of the file on the local or remote disk, timestamp, compression rate and the size of the compressed file (if it was compressed), or save set key and size (if RMAN set backup)

  • #DISKDEL/#STAGEDEL: archiving to disk: information (action ID, function ID, timestamp), when the file was deleted from archive directory

  • #DELDISK: a copy of an offline redo log file on disk was deleted: information (action ID, function ID, timestamp) when the file was deleted from the disk backup directory

  • #APPLIED: offline redo log file was applied to the standby database

  • ##: you can enter user comments into the BRARCHIVE summary log with this prefix.