Summary Log (SAP Library - Database Administration (Oracle) with SAPDBA)

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 (starts with ‘#’ for tape_copy_cmd=cpio or with ‘$’ for tape_copy_cmd=dd )

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), flag for the BRARCHIVE command options.
a(-archive) , b(-backup) , f(-fill) , k(-compress) , w(-verify) ,
m(-modify) .

#DISK This information appears if you used the BRARCHIVE feature for archiving to 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 Archiving to disk: action ID, function ID, name of the file on the disk, timestamp, compression rate and the size of the compressed file (if it was compressed).

#DISKDEL Archiving to disk: information (action ID, function ID, timestamp), if the file was deleted.

## Comments entered by the user.

See: Summary BRARCHIVE Log