Saturday , May 28 2022

Disabling And Enabling Data Guard Broker Transport Services

In today’s article, I will talk about Disabling And Enabling Data Guard Broker Transport Services.

Below is how to make Redo Transport Services disabled from the broker by deferring the LOG_ARCHIVE_DEST_STATE_n parameter with SQL commands.

1. We learn thread# and sequence# before disabling Redo Transport Services.

2. Redo Transport services are disabled.

3. We perform the Log Switch operation.

4. We check whether the Archive Redo Logs go to the Standby side.

5. We perform the commissioning process again.

6. We check whether the Archive Redo Logs go to the Standby side.

7. Redo Transport is stopped in a specific standby, not in all standbys, as follows.

a. Redo Transport to Logical Standby is stopped.

b. We check if the parameter is DEFER.

c. With Log Switch, a test is performed to understand whether the Redos go on the Logical side. For this, we first learn the SEQUENCEs available in Primary and Logical.

d. We do the Log Switch operation.

f. We check the SEQUENCEs.

g. The Redo stream that was stopped in the specific Standby is started.

i. It is checked whether the parameter is ENABLE or not.

h. It is checked whether the redos pass to Logical Standby.

 

 

 

Onur ARDAHANLI
Author: Onur ARDAHANLI

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *