Displaying Redo Log Backups: Oracle (SAP Library - Computing Center Management System (BC-CCM))

Displaying Redo Log Backups: Oracle

The area Redo log backups in Transaction DB12 (see Displaying Backup Logs and Status: Oracle) provides information about archiving of the offline redo log files. 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 archived.

Choose Archiving directory status for the name of the database host, the name of the archiving directory, the status of the directory, and the amount of freespace in the directory.

To display a list of offline redo log files including their archiving statuses, choose Overview of Redo log files

The following information is displayed:

RedoNo.	Log sequence number
Time created	Time the offline redo log file was created
Tape name	Tape name
Pos	Position of the file on the tape
Backup time	Time the offline redo log file was archived
Backint ID	Backup ID of Backint interface (only if external backup program was used)
Offline redo log file name	Directory and name of the redo log file

For an overview of all existing archiving logs, choose Overview of redo log backups Archiving sessions with errors are highlighted in color (red).

The following information is displayed:

Backup function	Brief information about the archiving performed
Start of backup	Time archiving started
End of backup	Time archiving ended
RC	BRBACKUP For more information, see Return Codes
Log	File system log name ( <Action ID>.<Function ID> , see Names of the Detail Logs)

For more information, see Summary Log

For further analysis of an archiving session, double-click the appropriate line to display the database log. To display the file system log, choose Detail log.

The following information is displayed:

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
Time created	Time the offline redo log file was created
Tape name	Tape name
Pos.	Position of the file on the tape
Backup time	Time the offline redo log file was archived
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 redo log file

For more information, see Detail Log and Log Types.