DG BROKER Activities Part – II

We have seen SWITCHOVER, FAILOVER and REINSTATE database in the previous article.

In this article, we will see changing protection modes with DGMGRL and disabling and removing the configuration.

1. Change protection modes

Step 1: Change LOGXPTMODE to suitable option as per Protection mode.

DGMGRL> edit database testdb set property LOGXPTMODE=sync;
Property "logxptmode" updated

Step 2: Change Protection mode to desired protection mode.

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Succeeded.

Check protection mode :

DGMGRL> show configuration verbose;

Configuration - drdb

  Protection Mode: MaxAvailability
  Databases:
    testdb     - Primary database
    std_testdb - Physical standby database

  Properties:
    FastStartFailoverThreshold      = '50'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '50'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

We can see in above result set Protection mode is changed to MaxAvailability.

2. Disable configuration

We can disable configuration we have created in DG Broker using below command.

DGMGRL> DISABLE CONFIGURATION;
Disabled.

3. Drop the standby database from the configuration

We can remove some of your standby databases from dg broker configuration.

DGMGRL> REMOVE DATABASE STD_TESTDB;
Removed database "std_testdb" from the configuration

4. Remove configuration :

DGMGRL> REMOVE CONFIGURATION;

Stay tuned for More articles on Oracle DataGuard

In the Next article, we create the DG broker configuration.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp