Displaying Backup Logs: Oracle (SAP Library - Computing Center Management System (BC-CCM))

Displaying Backup Logs: Oracle

The Database backups area in Transaction DB12 (see Displaying Backup Logs and Status: Oracle) provides information about backups of database data files. You can find out when the last unsuccessful backup (return code unequal to 0 or 1) and last successful backup occurred.

You thus get an overview of how current your backups and can judge whether they are adequate. You should have several generations of successful backups whose dates are not too far in the past.

To display the database log of the last failed backup, choose Last unsuccessful backup To analyze the error more closely, display the file system log by selecting the Detail log pushbutton.

This information is only displayed, if an unsuccessful backup exists.

To display the database log of the last successful backup, choose Last successful backup

The following information is displayed:

Tape name	Tape name
Pos.	Position of the file on the tape
Backup time	Time the backup of the file ended
Compr.	Compression rate (if compression was used)
File ID	ORACLE file ID
File name	File name
Tablespace	Tablespace name
RedoNo.	Log sequence number of the online redo log file
TS status	ORACLE tablespace status
File status	ORACLE file status
Backint ID	Backup ID of Backint interface (only if external backup program was used)

For more information, see Detail Log

For an overview of all existing backup logs, choose Overview of database backups Backups that ran incorrectly are highlighted in red.

The following information is displayed:

Backup function	Brief information about the backup performed
Start of backup	Time the backup started
End of backup	Time the backup 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 further analysis of a backup, double-click the appropriate line to display the database log. Choose Detail log to look at the corresponding file system log.

For more information, see Summary Log and Log Types.