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.

Integration

You use the following tools for database backup:

Tool

Use

DBA Planning Calendar

– in the Computing Center Management System (CCMS) of the SAP System

Routine backups:

?      Backup of database files

?      Backup of offline redo log files

Backup and Database Copy with BR*Tools

– uses the BR*Tools user interface

?      Backing Up the Database with BR*Tools

?      Backing Up the Offline Redo Log Files with BR*Tools

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.

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.