Use
You need to regularly back up your Oracle database so that, in the event of failure, you can restore and recover it.
Integration
You use the following tools for backup, restore, and recovery:
Tool |
Use |
DBA Planning Calendar
– in the Computing Center Management System (CCMS) of the SAP System |
Routine backups:
|
SAPDBA for Oracle |
Backup of database files
Backup of offline redo log files
Restore and recovery |
BRBACKUP |
Backup of database files |
BRARCHIVE |
Backup of offline redo log files |
BRRESTORE |
Restore of database and offline redo log files |
SQLPLUS |
Database recovery when SAPDBA is not sufficient |
Oracle Recovery Manager (RMAN) – integrated with BRBACKUP and BRARCHIVE |
Backup, restore, and recovery |
Prerequisites
You familiarize yourself with the above tools and make sure that you frequently back up the entire database. For more information, see
Backup Overview.Features
BRRESTORE restores data files that have been damaged or are missing, using backups of the database files.
SAPDBA recovers transactions lost since the database backup, using backups of the offline redo log files to roll forward the lost transactions.
For more information, see
Why Back Up the Database? and What Needs Backing Up?Activities
We recommend you to use the DBA Planning Calendar for routine backup tasks, because this enables you to automatically schedule the backup.
You can perform backup, restore, and recovery tasks from either of the following:
SAPDBA calls the tools BRBACKUP, BRARCHIVE, or BRRESTORE as necessary to complete the task you have chosen.
In this way, you can use the tools BRBACKUP, BRARCHIVE, or BRRESTORE, but this requires expert knowledge.
We recommend you to use the DBA Planning Calendar for routine backup because this enables you to automatically schedule the backup.
We recommend you to use the SAPDBA menus for restore and recovery because SAPDBA guides you through the necessary steps.