dgmgrl

Convert physical standby to snapshot standby using dgmgrl

In our earlier article, we explained how to convert physical standby to snapshot standby manually . Convert Physical standby to snapshot standby manually(Without DGMGRL) However in this article, I wil...

Warning: ORA-16854: apply lag could not be determined

PROBLEM: I was getting Warning: ORA-16854: apply lag could not be determined in dgmgrl show configuration command. , despite my dataguard replication was working fine and no errors were in any of the ...

How to disable enable log shipping in standby using dgmgrl

Sometimes OS team may request for outage on standby database server for maintenance activites. In that we need to stop the log shipping to avoid error in the alert log. Run below commands to disable a...

ORA-16855: transport lag has exceeded specified threshold

PROBLEM: We have observed below error in dgmgrl : DGMGRL> show database prdstby Database – prdstby Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 9 minutes 24 seconds (compute...

Useful DGMGRL commands in oracle dataguard

This articles contains useful dgmgrl commands to manage the dataguard environments. 1. Setup DG broker in the standby setup.(Run on both primary and standby) - For standalone db : ALTER SYSTEM SET dg_...

How to setup dataguard broker configuration (DG broker) in 12c

Dataguard broker is used to automate monitoring and controlling standby setups. It is very much useful, when the organization has multiple standby sites. In this article, we will see, how to enable dg...

Oracle dataguard – Interview Questions

1. What is the use of standby redolog? The Advantage of having Standby Redo Logs is that every records written into the Online RedoLogs of the Primary Database is transferred to the Standby database a...