Database Logs for BRBACKUP, BRARCHIVE, and BRCONNECT (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Database Logs for BRBACKUP, BRARCHIVE, and BRCONNECT

The database logs of BRBACKUP, BRARCHIVE, and BRCONNECT are stored in tables SDBAH and SDBAD . SAPDBA also uses these tables. SAPDBA saves information from the main log reorg<DBSID>.log in these database tables. For more information, see Central Log reorg<DBSID>.log.

Caution

Do not manually change tables SDBAH and SDBAD . Only the appropriate SAP tools and the SAP System should append or change these tables.

This section does not describe these tables in detail, but instead gives an overview of which information BRBACKUP, BRARCHIVE, and BRCONNECT stores in which tables.

SDBAH

This table contains information that refers to the backup as a whole:

Starting time of the backup or BRCONNECT processing
End time of the backup or BRCONNECT processing
BRBACKUP/BRARCHIVE/BRCONNECT return code
BRBACKUP/BRARCHIVE/BRCONNECT action ID (encoded timestamp of the file system log names)
BRBACKUP/BRARCHIVE/BRCONNECT function ID (extension of the file system log names)

SDBAD

This table contains information that refers to the backup of one file:

File name
Oracle file ID or log group number
End time of the backup of the file
Name of the volume where the file was saved
Position of the file on the volume
Backup ID of the external backup program
Compression rate of the software compression

In addition, table SDBAD contains internal BRBACKUP information about compression rates and backup durations for the individual database files.

For BRCONNECT, SDBAD tables contain information on the total number of objects processed by BRCONNECT.