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

To read about Active Data Guard

Oracle Active Data Guard Overview & Architecture

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.

We can see in above result Real Time Query is OFF

Step 2 : Open standby database in read only mode.

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

We can see here Real Time Query is enabled.

We can see real time apply from sql prompt.

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:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.