• 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 Trace Dynamic Registration from PMON or LREG (Oracle 12c)
  2. ASM Fast Mirror Resync Feature – Example To Simulate Transient Disk Failure And Restore Disk
  3. How long does Oracle retain the statistics for
  4. How to Enable or Disable Veritas ODM for Oracle database 12.1.0.1
  5. Script To Find Redolog Switch History And Find Archivelog Size For Each Instances In Oracle RAC
  6. 12c ASM: PRCR-1001 : Resource ora.proxy_advm Does Not Exist (Flex ASM with Cardinality = ALL)
  7. How to Backup and Restore Java Classes and Privileges only in Oracle Database
  8. Log file locations for Enterprise Manager Cloud Control 13c (OMS)
  9. Oracle database – How to create pfile or spfile using the current parameters
  10. How to find redo log members/redo log file size/redo log status

You May Also Like

Primary Sidebar

Recent Posts

  • grpck command – Remove corrupt or duplicate entries in the /etc/group and /etc/gshadow files.
  • xxd command – Expressed in hexadecimal form
  • sesearch: command not found
  • macof: command not found

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright