Show TOC

Used VolumesLocate this document in the navigation structure

Definition

This section describes the tape volumes written by BRBACKUP or BRARCHIVE when you back up your Oracle database or back up the offline 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 file init<DBSID>.ora (position 2) and spfile.

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

  • Database files (data files, offline redo log files, non-database files)

  • space_log: BRSPACE summary log space<DBSID>.log, database structure log struc<DBSID>.log, and parameter change log param<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)

Figure 1: Tape Layout for BRBACKUP and BRARCHIVE

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

  • Database logs

    • Table SDBAH with information about backup runs

    • Table SDBAD with information about backup files

Integration

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 BR*Tools.

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.