Entering content frameFunction documentation BRBACKUP/BRARCHIVE Locate the document in its SAP Library structure

Use

In contrast to NTBackup (file backup) BRBACKUP is a backup program (online and offline) that was specially designed for the Oracle database. SAP recommends BRBACKUP for large databases, because it also enables you to back up individual tablespaces online when the database is running, using ARCHIVELOG mode. For more information, see Setting Up Archiving.

Offline redo log files can be archived to tape using BRARCHIVE. You can restore a complete backup using BRRESTORE. In a recovery with SAPDBA, SAPDBA automatically restores the backup.

Prerequisites

BRBACKUP enables parallel backups to tape and disks. Some parameters in the initialization profile init<DBSID>.sap are specific to the operating system. (For example: rewind_offline = "mt -f $ offline" ).

For more information about authorization checks, see Executables.

Activities

Make sure that the environment variables are set correctly. Create a file in which the correct environment is defined before you start BRBACKUP/ BRARCHIVE. This file is scheduled in the at job.

Example

set PATH=%PATH%;d:\usr\sap\C11\SYS\exe\run
set ORACLE_SID=C11
set ORACLE_HOME=d:\orant
set SAPDATA_HOME=d:\oracle\C11
brbackup -c force <other options>

Database Analysis

Leaving content frame