BR*Tools Example: Performing SAP on Oracle Standby Database Backups

Set up a standby database as a copy of the primary (production) database and use it for full system recovery (disaster recover) and data corruption.

You can back up standby databases when they are either in an offline or online state.

When the database in online, the SAP for Oracle Agent determines the standby database mode by checking the database role and automatically disables the log switch operation.

The following table describes the supported device types for standby database backups.

Backup Type	Supported Device Types
Traditional online	RMAN_UTIL
Traditional offline	RMAN_UTIL UTIL_FILE UTIL_FILE_ONLINE
IntelliSnap offline	UTIL_FILE UTIL_VOL_ONLINE UTIL_VOL
IntelliSnap online	Not Supported
Commvault CLI IntelliSnap offline	UTIL_FILE UTIL_VOL_ONLINE UTIL_VOL

Note

If you use the RMAN_UTIL interface, see the SAP article, Standby, for information on the Oracle Recovery Manager options for redo logs when you perform standby database backups.

Before You Begin

Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

Procedure

UTIL_FILE Interface

On the command line, type one of the following commands.

Backup offline standby database by using brbackup
```
brbackup –t offline_standby –d util_file –m all
```
Backup online standby database by using brarchive
```
brarchive -d util_file -t standby -cds
```

RMAN_UTIL Interface

On the command line, type one of the following commands.

Backup online standby database by using brbackup
```
brbackup –t online_standby –d rman_util –m all
```
Backup offline standby database by using brbackup
```
brbackup –t offline_standby –d rman_util –m all
```
Backup online standby database by using brarchive
```
brarchive -d rman_util -t standby -cds
```

BR*Tools Example: Performing SAP on Oracle Standby Database Backups

Before You Begin

Procedure

Page contents