dataguard

Shell script to monitor lag in standby datbase using dgmgrl

Below script is helpful in monitoring lag in stan...

Useful DGMGRL commands in oracle dataguard

This articles contains useful dgmgrl commands to manage the ...

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

Dataguard broker is used to automate monitoring and cont...

How to add a tempfile in primary database in dataguard

If standby_file_management is set to AUTO, as soon as we add a ...

How to enable active dataguard in physical standby database

Active dataguard means, the standby database is open ...

How to recreate physical standby controlfile

Below are the steps for recreating physical standb...

ORA-01665: control file is not a standby control file

PROBLEM: After restoring standby database from RMA...

ORA-01274: cannot add data file that was originally created as

PROBLEM: After adding a datafile in prima...

Remove dataguard configuration from Primary database:

If you wish to remove the dataguard/standby ...

How to open standby database when primary database is lost

If your primary database is not access...