Previous Topic: SAPDBANext Topic: Database Backup Using SAPDBA and BR* Tools


How SAPDBA Works

Integrating SAPDBA with the option lets you back up and restore entire databases and reset database to a previous state. When you start a job, SAPDBA is automatically started. SAPDBA functions are determined by the properties that are set in util_par_file.

For more information on setting util_par_file properties, see Configure Parameter File Settings.

The following modules are available for Oracle database administration:

BRBACKUP

Brings database servers online or offline, checks the file status, and places database tablespaces into backup mode to maintain consistency.

BRARCHIVE

Provides online and offline backup of control files, data files, and online redo log files as well as profiles and logs for backups.

BRRESTORE

Recovers database data files, control files, and online redo log files. Checks for available space prior to a restore while removing files that may be overwritten during the recovery.

When these modules are used, events are logged in the file system and corresponding database tables. When BRBACKUP or BRARCHIVE runs, backup logs and profiles are saved, enabling sophisticated volume management.