Checking the Standby’s Open Mode & Setup active Data Guard – REAL TIME APPLY

In this article, we will see steps to enable Active Data Guard-Real Time Apply.

To read about Active Data Guard

Prerequisites :

Physical Standby database is already created and is in sync with Primary Database.

Step 1 : Let us first check Active Data Guard is not enabled.

DGMGRL> show database std_mgr

Database - std_mgr

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds (computed 0 seconds ago)
  Apply Lag:       0 seconds (computed 0 seconds ago)
  Apply Rate:      0 Byte/s
  Real Time Query: OFF
  Instance(s):
    mgr

Database Status:
SUCCESS

DGMGRL>

We can see in above result Real Time Query is OFF

Step 2 : Open standby database in read only mode.

SQL> alter database open read only;

Database altered.

Step 3 : Check real time apply is enabled with dgbroker :

DGMGRL> show database std_mgr

Database - std_mgr

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds (computed 1 second ago)
  Apply Lag:       0 seconds (computed 1 second ago)
  Apply Rate:      0 Byte/s
  Real Time Query: ON
  Instance(s):
    mgr

Database Status:
SUCCESS

We can see here Real Time Query is enabled.

We can see real time apply from sql prompt.

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE
--------- --------------------
MGR	  READ ONLY WITH APPLY

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp