Displaying Redo Log Backups (Oracle) 

Use

This sections explains how you can display information about backup of the offline redo log files for the Oracle database. For more information, see Display of Backup Logs and Status (Oracle).

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.      Choose Administration ® CCMS ® DB Administration ® Backup logs. Alternatively, call transaction DB12.

This procedure is concerned with Redo log backups.

       2.      To display the status of the redo log backups, 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.

       3.      Choose one of the functions Overview of redo log files or Overview of redo log backups:

¡        To display a history list of offline redo log files including backup status, choose Overview of redo log files.

The following information is displayed:

Heading	Description
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 backed up
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 display an overview of all existing backup logs for offline redo log files, choose Overview of redo log backups.

The following information is displayed, with unsuccessful redo log backups highlighted in red:

Heading	Description
Backup function	Brief information about the type of backup performed
Start of backup	Time redo log backup started
End of backup	Time redo log backup ended
RC	BRARCHIVE return code For more information, see Messages and Return Codes for the BR Tools.
Log	File system log name <Action ID>.<Function ID> Refer to Names of the BRARCHIVE Detail Logs.

For more information, see BRARCHIVE Summary Log

       4.      To see the log, position the cursor on the required backup and choose Select log.

The following information is displayed:

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

       5.      To display the file system log, position the cursor on the required log and choose Detail log.

For more information, see BRARCHIVE Detail Log and Log Types.