Hello Community,
Our client wants to us to trigger Oracle dataguard backups only from secondary node. I couldn’t find a setting on “Preperties” to set it. Does anyone know how to do it? Or if it’s even possible? The primary node is very loaded so they wish to run all backups from secondary.
Thanks!!
Zivile
Best answer by Gowri Shankar
Hi
Please add sORARUNBKPONDBROLE additional settings with value 1 on all the physical nodes of the data guard.
Documentation → https://documentation.commvault.com/11.24/expert/20991_specifying_servers_that_run_backups_in_oracle_data_guard_configuration.html
To all client nodes, add the sORARUNBKPONDBROLE additional setting as shown in the following table.
For instructions about adding an additional setting from the CommCell Console, see Add or Modify an Additional Setting.
| Property | Value |
|---|---|
| Name | |
| Category | OracleAgent |
| Type | Integer |
| Value | The value that specifies the servers that run the backups. |
Applies to: An Oracle primary host and the standby host. A non-Oracle RAC standby host when you have created an Oracle RAC pseudo-client.
When you have an Oracle Data Guard configuration, you can use this additional setting to specify whether the primary or standby host runs the data and log backups. You must set this additional setting on the primary host and the standby host.
Use the following values to specify the backup location.
| Value | Definition |
|---|---|
| 1 | Run the database backup and the archive log backup on the standby server |
| 4 | Run the database backup on the standby server and the archive log backup on the primary server |
| 10 | Run the database backup on the primary server and the archive log backup on the standby server |
| 12 | Run the database backup and the archive log backup on the primary server |
Regards,
Gowri Shankar
Hi
Please add sORARUNBKPONDBROLE additional settings with value 1 on all the physical nodes of the data guard.
Documentation → https://documentation.commvault.com/11.24/expert/20991_specifying_servers_that_run_backups_in_oracle_data_guard_configuration.html
To all client nodes, add the sORARUNBKPONDBROLE additional setting as shown in the following table.
For instructions about adding an additional setting from the CommCell Console, see Add or Modify an Additional Setting.
| Property | Value |
|---|---|
| Name | |
| Category | OracleAgent |
| Type | Integer |
| Value | The value that specifies the servers that run the backups. |
Applies to: An Oracle primary host and the standby host. A non-Oracle RAC standby host when you have created an Oracle RAC pseudo-client.
When you have an Oracle Data Guard configuration, you can use this additional setting to specify whether the primary or standby host runs the data and log backups. You must set this additional setting on the primary host and the standby host.
Use the following values to specify the backup location.
| Value | Definition |
|---|---|
| 1 | Run the database backup and the archive log backup on the standby server |
| 4 | Run the database backup on the standby server and the archive log backup on the primary server |
| 10 | Run the database backup on the primary server and the archive log backup on the standby server |
| 12 | Run the database backup and the archive log backup on the primary server |
Regards,
Gowri Shankar
Also by default data & log backups happen on secondary node. Even without this additional setting backups will run on secondary. Please ensure both primary and standby instances are configured under the same RAC pseudo-client instance
+20So it appears they made some changes as the documentation of this setting was expanded with the following:
Starting with release 11.30 this setting is no longer required. You can instead configure the behavior by creating an Oracle Data Guard client and using the CommCell Console to modify the value in the subclient properties.
The documentation only refers to the CommCell console → https://documentation.commvault.com/2023e/expert/20991_specifying_servers_that_run_backups_in_oracle_data_guard_configuration.html
Where is option within Command Center that allows the user to influence the backup behaviour?
We are still working on adding Command Center support and will update the documentation once this dataguard functionality is available on Command Center. For now Dataguard client creation is only available on Java Console.
From CommandCenter, you can still use the additional settings specified in previous thread
Thanks,
Prashanth
+20Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
