DATAGUARD

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 will explain how can we achieve this using dgmgrl. To use dgmgrl , make sure dg broker is enabled.Follow below article to implement. How to set […]

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 alert logs. I tried validate database command , still warning was there. DGMGRL> show configuration; Configuration – my_dg_leo Protection Mode: MaxPerformance Members: […]

Recover standby database from primary using service in oracle 18c

If your standby database is out of sync from primary or some archive logs got deleted before it is being shipped or applied to standby ,then you can follow below method to sync standby database with primary. We can call this process as  rolling forward of standby database. In oracle 11g, this process is purely […]

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 and enable the log shipping. primary db -> prod standby db – > proddr 1. Login to primary db server […]

Shell script to monitor lag in standby datbase using dgmgrl

Below script is helpful in monitoring lag in standby database and send mail to DBAs in case the lag is increasing. For the script to work, make sure dataguard broker is enabled between primary and standby database.   SEE DGBROKER ARTICLE:  How to setup dgbroker in oracle 12c: Useful dgmgrl commands:   SCRIPT PREPARATION: PRIMARY […]

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_broker_config_file1 = ‘\U01\oradata\dr1node.dat’ scope=both sid=’*’; ALTER SYSTEM SET dg_broker_config_file2 = ‘\U01\oradata\dr2node.dat’ scope=both sid=’*’; — For oracle RAC/ASM file system; ALTER SYSTEM SET dg_broker_config_file1 […]

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 broker configuration in existing standby setup. NOTE – Before setting dgbroker, make sure standby setup is ready. SEE ALSO – Setup physical […]

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 and written into the Standby Redo Logs at the same time. therefore, you it minimizes the probability of Data Loss on […]

How to add a tempfile in primary database in dataguard

If standby_file_management is set to AUTO, as soon as we add a datafile on primary database, same will be created automatically on standby database. But will the same valid for tempfile?? Answer is NO. Adding tempfiles to TEMP tablespaces in primary database, will not automatically create on standby database. Because no redo is generated, while […]

Standby redologs in oracle dataguard

The Advantage of having Standby Redo Logs (SLR) is that every records written into the Online RedoLogs of the Primary Database is transferred to the Standby database and written into the Standby Redo Logs at the same time. therefore, you it minimizes the probability of Data Loss on the Standby Database. Without Standby Redo Logs, […]