Backing Up and Restoring SAP Data › SAPDBA and BR* Tools You Can Use to Administer SAP Databases

SAPDBA and BR* Tools You Can Use to Administer SAP Databases

Integrating SAPDBA and BR* Tools with the option lets you back up and restore entire databases and reset database to a previous state. The SAPDBA and BR* Tools functions are determined by the properties that are set in util_par_file.

For more information on setting util_par_file properties, see Edit util_par_file to Define Environment Variables.

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 offline redo log files as well as profiles and logs for backups.
• BRRESTORE--Recovers database data files, control files, and offline 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.