Standby Database: Backup with BRBACKUP (SAP Library - Database Administration (Oracle) with SAPDBA)

Standby Database: Backup with BRBACKUP

Use

One main advantage of the standby database scenario is that backups do not have to be performed in the primary (production) database system. Instead it allows the datasets of the standby database to be backed up. This means that the database backup does not add to the load on the host of the primary database instance. Since online operation does not occur on the standby database, all the host’s resources can therefore be made available for the database backup. The SAP utility program BRBACKUP backs up the standby database data.

Prerequisites

The standby instance is in the recovery state and must not be opened. You can make an offline backup only. For the BRBACKUP backup of the standby data, you must set the init<DBSID>.sap parameter backup_type = offline_standby .

Renaming of database files in the standby database is not supported by BRBACKUP. The original names of the primary database need to be retained.

As for the OPS configuration, certain requirements must be satisfied for the connection to a remote host.

Features

BRBACKUP logs on to the primary database instance (entries for the instance string in the init<DBSID>.sap parameter primary_db ) and retrieves the information required on the database structure. This information is entered in the backup logs.

The standby database instance is stopped.

BRBACKUP backs up the standby data.

After the backup has been made, the original state of the standby database instance is recovered. If the database was in a recovery state, this state is restored (ORACLE commands STARTUP NOMOUNT, ALTER DATABASE MOUNT STANDBY DATABASE).

Activities

To create and configure a standby database you can make a BRBACKUP backup ( backup_type = offline_stop ) of the production database. This is not opened later: Instead it is transferred directly into the mount standby mode, where it takes over the role of the standby database. The backup becomes the production system.

backup_type

primary_db

To recreate a standby configuration, you can make a copy of the production database. You can then use this as the standby database ( backup_dev_type=disk_standby ).

Structure-Retaining Database Copy