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 sta...

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_...

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...

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...

Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time. Below are the benefit of using active dataguard. Reporting queries can b...

     Below are the steps for recreating physical standby controlfile. 1. Get the controlfile location [STANDBY] SQL> show parameter control_files NAME TYPE VALUE --------------------------------...

PROBLEM: After restoring standby database from RMAN backup, got below error, while mounting standby database,getting below error. ORA-01665: control file is not a standby control file SOLUTION: Check ...

PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database: SQL> alter tablespace prim add datafile size 1g; Tablespace alt...

    If you wish to remove the dataguard/standby setup from primary database i.e to make the primary database as standalone database without any standby database, then follow below steps. 1.Put prima...

    If your primary database is not accessible or crashed for any issue, then we can use open the standby database for use. Below are the steps for opening standby database when the primary database...