What is Oracle Active Data Guard?

Oracle Active Data Guard is a Physical Standby Option available with Enterprise Edition. Thanks to Active Data Guard, we do not leave Data Guard idle. It contains many features like below. It licensed. Active Data Guard provides automatic block repair feature. With this feature, a DML operation on the Primary side can be seen instantly on the Standby side.

  • Real-Time query,
  • We can get Fast Incremental Backup on physical standby database,
  • Can fix automatic block corruption,
  • Far SYNC feature we can use

If a block is found to be corrupt as a result of a query run in the primary database, the corrupted block is automatically repaired by taking it from the Physical Standby Database, which is the Active Data Guard.

If a block is found to be corrupt as a result of a query run in Physical Standby, the corrupted block is taken from the Primary Database and automatically repaired.

If the Physical Standby database is not Active Data Guard then this is done manually.

If a single block will be repaired;

If more than one Block in more than one Datafile will be repaired;

When these commands are executed, Oracle searches the block that is corrupt from the following;

  • Physical Standby Database
  • Flashback Logs
  • Full veya Level 0 incremental Backup

If you do not want to search for uncorrupted block from Standby Database, use the following command;

How To Enable Active Data Guard?

We can switch the physical standby database in mount mode to the active data guard as follows.

Step1: Check standby database recovery mode.

Step2: Stop Recovery.

Step3: Enable Active Data Guard.

Step4: Check Database Role.

Step5: Start Recovery.

Step6: Check Database Role After Recovery.

Step7: Try to login from third party clients (TOAD, SQL Developer).

Step8: Check database status.

Step9: Perform he same operations in the other Node and check the database role.

How To Disable Active Data Guard?

Step1: Shutdown Instances on the standby side and open them in Mount mode.

Step2: Enable Real Time Apply. I recommend you read the article named “What is Real Time Apply in Dataguard”

Step3: Check the instance status and the role of Databases.

Step4: On the primary side, Log Switch operation is performed separately from both Node.

Step5: Check whether Redo-Transport is coming to standby side.

Step6: By checking the LAG status, check whether the redos transported are applied or not.


Comments

Popular posts from this blog

Step by Step: How to troubleshoot a slow running query in Oracle

Register Archive log file manually in standby Database

How to check UNDO tablespace usage and who is using more undo