Wednesday, 4 March 2026

Step by step to create a dataguard in a different region for oci db system in base database service


Step by step to create a dataguard in a different region in oci db system in base database service



Note: Currently multiple standby features are not available in Base Database Service
It is required to terminate the current standby and create another standby in other region 

before terminating the current dg, it is recommended to restore to create a dbsystem in a different region from the latest backup.
https://docs.oracle.com/en-us/iaas/releasenotes/changes/563b64a5-eacd-4641-969d-02f3ce839208/index.htm 


If you are enabling the cross region DG, please check VCN peering. 

Refer this documentation for remote VCN peering - https://docs.oracle.com/en-us/iaas/Content/Network/Tasks/scenario_e.htm


Steps to Create the Cross-Region Data Guard
------------------------------
Navigate to the primary database:

Open the OCI Console navigation menu and go to Oracle Database > Oracle Base Database Service.

Click on the DB System that contains the primary database you want to configure.

On the DB System Details page, under the Databases section, click the name of your primary database.
Enable Data Guard association:

On the Database Details page, select the Data Guard Associations tab.
Click Enable Data Guard.

Configure the peer DB system (standby):
------------------------------------

On the Enable Data Guard page, select the option to create a new peer DB system.
In the Region dropdown, select the desired remote region for your standby database.
Enter the required information for the peer DB system, such as a display name, the peer VCN, and subnet in the standby region.
Enter the database admin password.
Optionally, select the Data Guard type (Active Data Guard requires an additional license), protection mode, and transport type.

Click Enable Data Guard.

The OCI automation will then handle the provisioning of the standby database and the configuration of the data replication. You can monitor the progress in the Work Requests tab or the Data Guard Associations tab, where the state will change from Provisioning/Updating to Available

Please refer below doc

https://docs.oracle.com/en/cloud/paas/base-database/data-guard/index.html
https://docs.oracle.com/en-us/iaas/Content/Network/Tasks/remoteVCNpeering.htm
https://docs.oracle.com/en/learn/basedb-dataguard-with-ocivault/#introduction

 

No comments:

Post a Comment