Used Volumes (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Used Volumes

Definition

This section describes the tape volumes written by BRBACKUP or BRARCHIVE when you back up your Oracle database or archive the redo log files.

Structure

After successfully backing up the Oracle database with BRBACKUP and BRARCHIVE, the volumes produced contain the following files:

Label: tape.hdr0 (position 1)

init_ora: Initialization files init<DBSID>.ora, init<DBSID>.dba (position 2)

init_sap: Initialization file init<DBSID>.sap or the profile file defined under -p|-profile (position 3).

Database files (data files, redo log files, control file)

reorg_log: Main SAPDBA log reorg<DBSID>.log and structure log struct<DBSID>.log

det_log: Detail log written by BRBACKUP or BRARCHIVE (second-to-last position)

sum_log: Summary log written by BRBACKUP or BRARCHIVE (last position)

Tape Layout for BRBACKUP and BRARCHIVE

This graphic is explained in the accompanying text

Information about used volumes is contained in the BRBACKUP and BRARCHIVE logs:

File system logs

Detail log, created for each backup
Summary log, extended during each backup (only for BRARCHIVE)

Database logs

Table SDBAH with information about the whole backup
Table SDBAD with information about the backup of a file

Use

These log files should only contain information that was written by BRBACKUP or BRARCHIVE. Do not change this information manually. The information in database tables SDBAH and SDBAD is evaluated by the Computing Center Management System (CCMS), for example.

For more information, see Logs for BRBACKUP, BRARCHIVE, BRRESTORE, and BRCONNECT.

For automatic volume management, BRBACKUP uses the corresponding database log to select available volumes. BRARCHIVE uses the summary file system log. BRARCHIVE cannot rely on the database logs because it also runs when the database has been shut down.