Consistent Online Backup 

Definition

A consistent online backup ( backup_type = online_cons ) is an alternative to an offline backup when you cannot close the database. This backup has logically consistent data because the offline redo log files created by BRBACKUP during a backup are backed up with the database files on the same volume. The backup of the offline redo log files using BRBACKUP runs completely independently from the BRARCHIVE backups and does not influence them in any way. A consistent online backup differs from an offline backup in that a recovery of the database is always necessary in order to guarantee consistent data.

Use

Any recovery of the database is made easier since the offline redo log files of the same backup can be imported. In the same way the database can be reset to an earlier status (Reset database) (only when using a BRBACKUP online backup).

Structure

Activities

To make a consistent online backup, use the BRBACKUP option -t|-type online_cons or the relevant init<DBSID>.sap profile parameter backup_type = online_cons .

To restore the offline redo log files from the BRBACKUP backups, use the BRRESTORE option -m|-mode archive_logs . Restore a complete BRBACKUP backup using the BRRESTORE option -m full .

Command Options for BRBACKUP, BRARCHIVE, and BRRESTORE