In today’s article i will tell you how to Disable Data Guard Broker Configuration.<\/p>\n
We may want to disable the broker configuration. Commands executed in SQLPLUS after being disabled are valid until the broker is enabled.<\/p>\n
The broker will expire from the moment it is enabled. The reason is that as soon as the broker is enabled, the DMON process reads the configuration file and shapes the broker accordingly.<\/p>\n
If we want the parameter changes made while the Broker is DISABLE’ to be permanent, then we change the parameters from the Broker.<\/p>\n
This is because the DMON parameter is active even if the broker is DISABLED. In this case, the DMON process writes the changes made to the configuration file.<\/p>\n
When enabled, it shapes the Configuration accordingly.<\/p>\n
1. We query from the broker to see some information of the Logical Standby Database.<\/p>\n
DGMGRL> show database logical\r\n\r\nDatabase - logical\r\n\r\n Role: LOGICAL STANDBY\r\n Intended State: APPLY-ON\r\n Transport Lag: 0 seconds (computed 1 second ago)\r\n Apply Lag: 0 seconds (computed 1 second ago)\r\n Apply Rate: 0 Byte\/s\r\n Instance(s):\r\n primary1\r\n primary2 (apply instance)\r\n\r\nDatabase Status:\r\nSUCCESS\r\n<\/pre>\n2. We DISABLE the broker.<\/p>\n
DGMGRL> disable configuration\r\nDisabled.\r\n\r\nDGMGRL> show configuration\r\n\r\nConfiguration - Broker _Configuration\r\n\r\n Protection Mode: MaxPerformance\r\n Databases:\r\n primary - Primary database\r\n standby - Physical standby database\r\n logical - Logical standby database\r\n\r\nFast-Start Failover: DISABLED\r\n\r\nConfiguration Status:\r\nDISABLED\r\n<\/pre>\n3. We query the tables under the TEST schema.<\/p>\n
[Primary-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\n<\/pre>\n[Physical-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\n<\/pre>\n[Logical-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\n<\/pre>\n4. We create a new table under the TEST schema.<\/p>\n
[Primary-1] SQL> create table test.regions_yedek as select * from hr.regions;\r\n\r\nTable created.\r\n\r\n[Primary-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\nREGIONS_YEDEK\r\n<\/pre>\n[Physical-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\nREGIONS_YEDEK\r\n<\/pre>\n[Logical-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\nREGIONS_YEDEK\r\n<\/pre>\n5. We stop Redo-Apply in Logical Standby Database.<\/p>\n
[Logical-2] SQL> alter database stop logical standby apply;\r\n\r\nDatabase altered.\r\n<\/pre>\n6. We create a new table under the TEST schema.<\/p>\n
[Primary-1] SQL> create table test.departments_yedek as select * from hr.departments;\r\n\r\nTable created.\r\n\r\n[Primary-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\nREGIONS_YEDEK\r\nDEPARTMENTS_YEDEK\r\n<\/pre>\n[Physical-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\nREGIONS_YEDEK\r\nDEPARTMENTS_YEDEK\r\n<\/pre>\n[Logical-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\nREGIONS_YEDEK\r\n<\/pre>\n7. We ENABLE the configuration.<\/p>\n
DGMGRL> enable configuration\r\nEnabled.\r\nDGMGRL> show database logical\r\n\r\nDatabase - logical\r\n\r\n Role: LOGICAL STANDBY\r\n Intended State: APPLY-ON\r\n Transport Lag: 0 seconds (computed 0 seconds ago)\r\n Apply Lag: 9 seconds (computed 0 seconds ago)\r\n Apply Rate: 0 Byte\/s\r\n Instance(s):\r\n primary1\r\n primary2 (apply instance)\r\n\r\nDatabase Status:\r\nSUCCESS\r\n<\/pre>\n[Logical-2]—->ALERT LOG<\/p>\nALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE\r\nALTER DATABASE START LOGICAL STANDBY APPLY (primary2)\r\nwith optional part\r\nIMMEDIATE\r\nAttempt to start background Logical Standby process\r\n<\/pre>\n8. We check again whether the table is in Logical Standby.<\/p>\n
[Logical-1] SQL> select table_name from dba_tables where owner='TEST';\r\n\r\nTABLE_NAME\r\n------------------------------\r\nEMPLOYEES_YEDEK\r\nREGIONS_YEDEK\r\nDEPARTMENTS_YEDEK\r\n<\/pre>\n<\/p>\n
<\/div>\n