Database Backup

Use

You need to regularly back up your Oracle database so that, in the event of failure, you can restore and recover it. You also need to regularly verify your backups to make sure that they are usable.

Integration

You use the following tools for database backup:

Tool	Use
DBA Planning Calendar - in the DBA Cockpit of the SAP system	Routine backups: Backup of database files Backup of offline redo log files
Backup and Database Copy with BRTools - uses the BRTools character or graphical user interface	Backing Up the Database with BRTools Backing Up the Offline Redo Log Files with BRTools
BRBACKUP	Backup of database files
BRARCHIVE	Backup of offline redo log files
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 regularly back up the entire database. For more information, see Backup Overview.

Features

BRBACKUP backs up database files
BRARCHIVE backs up offline redo log files

For more information, see Why Back Up the Database? and What Needs Backing Up?

Activities

You can perform backups in the following ways:

DBA Planning Calendar for routine backups
The menus in BR*Tools

BRTOOLS calls the tools BRBACKUP, BRARCHIVE, BRRESTORE, or BRRECOVER as necessary to complete the task you have chosen.
The command line

In this way, you can use the tools BRBACKUP, BRARCHIVE, BRRESTORE, or BRRECOVER, but this requires expert knowledge.

Recommendation
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 BR*Tools menus for restore and recovery because BR*Tools guides you through the necessary steps.
BRGUI