BRBACKUP and BRARCHIVE Backups in One Run (SAP Library - Database Administration (Oracle) with SAPDBA)

BRBACKUP and BRARCHIVE Backups in One Run

You can execute the database backup using BRBACKUP and the backup of the offline redo log files using BRARCHIVE in one run. This option is intended to make more effective use of the increasing capacity of the storage tapes (DLT2000: up to 20 GB, DLT4000: up to 50 GB, DLT7000: up to 100 GB). It also makes an unattended backup easier, since after a backup with BRBACKUP the BRARCHIVE run does not have be restarted as well. As of Release 4.5A, you can use this linkage of the two processes for any backup media, including backups with BACKINT. In the CCMS transaction DB13, you can now make the backup "Database + archive log backup" with BACKINT, or to a disk.

There are two options for making the backup in one run:

BRBACKUP starts BRARCHIVE ( brbackup -a ). If the backup is made to tape, the tapes are managed by BRBACKUP.

BRARCHIVE starts BRBACKUP ( brarchive -b ). If the backup is made to tape, the tapes are managed by BRARCHIVE.

We recommend the first option ( brbackup -a ). If the backup is made to tape, BRBACKUP uses the tapes defined in volume_backup and makes the backup in the following steps:

- Check the volume label
- Backup of the tape header files ( .tape.hdr0 , init_ora , init_sap )
- Backup of the database files (no logs are saved)
- Call BRARCHIVE
- BRARCHIVE then writes the offline redo log files to tape after the backed up database files (without checking the label and without header files).
- BRARCHIVE backs up all logs (BRBACKUP and BRARCHIVE).

Unattended online backup with two tape devices. The database files are backed up first and then the offline redo log files are copied to the same tapes.

brbackup -m all -t online -c -a -ssd -c

See: BRBACKUP command mode: brbackup -a|-archive

If you run the tape administration under control of BRARCHIVE ( brarchive -b ) the tapes defined in volume_archive are used. The only change to the backup is the sequence in which the data files and the offline redo log files are written to tape. In this case the logs are backed up by BRBACKUP at the end.

Offline backup with one tape device. The offline redo log files are backed up on tape first and then the database files are copied to the same tape.

brarchive -sd -c -b -t offline -c

See: BRARCHIVE command mode: brarchive -b|-backup

Making a BRBACKUP/BRARCHIVE backup in one run can also be used for a BRBACKUP/BRARCHIVE backup to several tape devices in parallel.