BRARCHIVE Summary Log

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)

Ў        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 like under #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).

·        #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.