Database Logs (SAP Library - Database Administration (Oracle) with SAPDBA)

Database Logs

The database logs of the SAP utilities BRBACKUP and BRARCHIVE are stored in tables SDBAH and SDBAD. The SAP utility SAPDBA also uses these tables. SAPDBA saves information from the main log reorg<DBSID>.log in these database tables (see Main Log ).

You should never manually change tables SDBAH and SDBAD. Only the appropriate SAP utilities and the R/3 System CCMS may append or change these tables.

As a result, this manual will not describe these tables in detail, but instead only list an overview of which information BRBACKUP/BRARCHIVE stores in which tables. This information is by no means complete.

SDBAH

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

Starting time of the backup

End time of the backup

BRBACKUP/BRARCHIVE return code

BRBACKUP/BRARCHIVE action ID (encoded timestamp of the file system log names)

BRBACKUP/BRARCHIVE 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.