Deploy the Active Data Guard Standby Database

Deploy the Active Data Guard standby database.

  1. Log in to the OCI Console. Navigate to the primary Database information page.
  2. Select the Data Guard associations tab.
  3. Click the Add standby button.
  4. To explicitly run a Data Guard precheck, click the Run Precheck button. In this case, the following actions are performed:
    • The system closes the Add Standby page.
    • A message appears on the Primary Database Details page indicating that the Data Guard precheck is in progress, and the Add Standby button is disabled.
    • While the precheck is running, the primary database and the VM Cluster remain in the AVAILABLE state.
  5. Select Use the new Data Guard Group Resource. With this option, your new Data Guard configuration will be created as a Data Guard Group resource. This option with new APIs supports adding multiple standby databases and provides other enhancements.
  6. In Peer VM Cluster, specify the following values for the standby:
  7. In Data Guard Group details, select a Data Guard type: either Active Data Guard or Data Guard.
    • Active Data Guard:

      Active Data Guard is a licensed option to the Oracle Database Enterprise Edition and enables advanced capabilities that extend the basic Data Guard functionality. These capabilities include Real-Time Query and DML Offload, Automatic Block Repair of physical data corruptions, Standby Block Change Tracking, Global Data Services, and Application Continuity.

    • Data Guard:

      Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database.

  8. Protection mode: Set the protection mode used for this Data Guard Group:
    • Maximum Performance provides the highest level of data protection that is possible without affecting the performance of a primary database.
    • Maximum Availability provides the highest level of protection of data with zero data loss synchronous transport without compromising the availability of the database.
  9. Transport type: Set the redo transport type used for the Data Guard association between the primary and this standby database:
    • Async: Asynchronous transport mode is used with Maximum Performance protection mode.
    • Sync: Synchronous transport mode used with Maximum Performance and Maximum Availability protection mode.
  10. Choose an existing Database Home. To add a standby database in a new database home, you must create the database home before adding the standby database.
  11. For the standby database, Provide a unique name for the database, enter the database admin password of the primary database in the Database password field, and provide the TDE wallet password.
  12. Click the Add button.

A work request is issued to configure the Data Guard association. You can view the progress of the request and the stages of provisioning on the Work Requests page of the respective Standby database.

When the association is created, the details for a database and its peer display their respective roles as Primary or Standby.