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.
If you want to perform a backup of an online database, then the subclient must be a data only subclient. The subclient cannot contain the logs.
Procedure
-
Perform any of the following backups from the CommCell Console. The Commvault software automatically creates the appropriate command for the standby database backup.