In the previous Article, we have seen understanding and managing user connectivity in Data Guard Environment.

Understanding and managing client connectivity


In this Article, we will see Creating After Startup Trigger which will manage service for different database roles.

Step 1: Create services in a Primary database with DBMS_SERVICE package.

Note: We need to create service and trigger in a primary database only that will be propagated to standby server with redo apply or SQL apply.

Step 2: Create After startup trigger

Step 3: Check trigger is propagated to standby or not

To check trigger works correctly I am restarting my physical standby with Active Data Guard enabled.

Check service before restart:

Restart the standby database :

See service name

We can see here DB_ADG service is enabled. So whenever a client needs to access this service it will always up with correct role regardless of a database server.

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.