Add and Manage Peer Databases Associated with a Registered Active Data Guard Primary Database

When you register a target database that is the primary database in an Active Data Guard association, you can manage the associated standby databases from the Target database page of the primary database. Managing the standby databases can include, adding them as peer databases, refreshing their connection details, editing their connection details, or deregistering them from Oracle Data Safe.

  1. From the navigation menu in Oracle Cloud Infrastructure, select Oracle AI Database, and then under Data Safe - Database Security, select Target databases. The Target databases page opens.

  2. Select the compartment that contains your target database.

  3. Select the name of your target database to which you want to add peer databases or refresh peer database connections for.

Add Peer Databases

  1. Open the details page for your target database.

  2. Select the Active Data Guard peer databases tab.

  3. Select Add peer database. The Add peer database panel opens.

  4. Select Add item.

  5. Either select from the available list of peer databases (cloud databases) or enter the following information (non-cloud databases):

    • Peer display name

    • Database service name

    • Database IP address

    • Database port number

    • Select TCP or TLS. If you select TLS, select either One way TLS and Mutual TLS. If you select One way TLS, then do the following: Upload the TrustStore of your database in PEM, PKCS#12 wallet, or JKS wallet format. You can also enter the wallet password if required. This file is required whether client authentication is enabled or disabled on your target database. If you select Mutual TLS, then do the following: Upload the TrustStore of your database in the format of PEM file, PKCS#12 wallet, or JKS wallet and enter the wallet password. This file is required whether client authentication is enabled or disabled on your target database. When client authentication is enabled on your target database, upload the KeyStore of your database in the format of PEM file, PKCS#12 wallet, or JKS wallet. This file is not required when client authentication is disabled.

  6. Select Add peer database.

Manually Refresh Peer Database Connections

Oracle Data Safe automatically checks and refreshes the peer database connection details every hour; however, you can do a manual refresh any time.

  1. Open the details page for your target database.

  2. Select the Active Data Guard peer databases tab.

  3. From the Actions menu, select Refresh.

Edit the Connection Details for the Primary Database

  1. On the details page for your target database, select Edit connection details.

  2. Modify the information, and then select Update.

Deregister a Peer Database

  1. Open the details page for your target database.

  2. Select the Active Data Guard peer databases tab.

  3. In the table, select the name of a peer database that you want to deregister. The Peer database information page opens.

  4. From the Actions menu, select Deregister.

Actions to Take After Performing a Manual Switch Over of Active Data Guard Associated Target Databases

If you have registered Active Data Guard associated target databases in Oracle Data Safe, you are able to see the role (primary or standby) of the databases. If you perform a manual switchover of the databases, you may not see the changes in the roles reflected immediately in Oracle Data Safe.

As a result of this, it’s possible that a data masking job will fail because the proper read and write permissions are not associated with the database.

To prevent this from occurring, after performing a manual switchover, refresh the database connections.