• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to Verify if Oracle Active Data Guard is Enabled

by admin

Question: How to identify if Active Data Guard (ADG) is enabled on a Standby database?

The concept of an Active Data Guard, also known as Real-Time Query, is when it allows read-only access on the Physical standby node at the same time as applying archived transactions from the Primary node.

For that to happen, the Standby database must be open in READ ONLY mode *and* the MRP (the apply process) started.

There are 2 ways to verify if ADG is enabled:

1. check the alert.log if the Standby database is opened in READ ONLY mode and if the MRP process is started:

Below sql will start the MRP process:

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE [ options ];

OR

2. run the following query on the Standby database, for example:

SQL> select open_mode, controlfile_type from v$database;

OPEN_MODE                       CONTROLFILE
----------------------------------------------
READ ONLY WITH APPLY            STANDBY

Filed Under: Data Guard, oracle

Some more articles you might also be interested in …

  1. How to move or rename a datafile in the same ASM diskgroup (Using ASM alias)
  2. Oracle Database 12.2 RMAN Cross Platform Tablespace Transport Over Network
  3. Understanding Device Persistence and Oracle ASMLib
  4. How To Size UNDO Tablespace For Automatic Undo Management
  5. ORA-00031: session marked for kill
  6. Oracle Database 12c : Creating a Scheduler Job in a Multitenant Database
  7. How to add or drop redo log groups in Oracle RAC
  8. How to Enable or Disable Automated Statistics Collection in Oracle Database
  9. What are different Oracle Database Vault Roles
  10. How to solve ORA-28000: the account is locked

You May Also Like

Primary Sidebar

Recent Posts

  • pw-cat Command Examples in Linux
  • pvs: command not found
  • pulseaudio: command not found
  • pulseaudio Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright