BRBACKUP/BRARCHIVE 

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 (with ARCHIVELOG mode).

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<SID>.sap are specific to the operating system. (For example: rewind_offline = "mt -f $ offline" )

Read the notes on authorization checks in 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.

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