Step By Step Configuration of Oracle DGMGRL Utility

Dear Readers,

In this article, we will see the step by step Configuration of Oracle DGMGRL Utility.

let’s start the step by step Oracle DGMGRL Utility configuration.

Step 1 :First we should check the DB name, DB unique name, open_mode, database_role of both the servers

Primary Server: –

Standby Server: –

Step 2:

Now test the connectivity of both the servers. Both should be ping to each other.

Primary to Standby: –

Standby to Primary: –

Step 3 :

Now set the dg_broker_start parameter as enable on both the servers.

Primary Server: –

Standby Server: –

Step 4:

Now configure the listener and tnsnames services for both the servers.

Note: – You can use netca or netmgr GUI tools to create the services.

Primary Side: –

Listener File Output: –

Standby Side: –

Listener File Output: –

Tnsnames File Output: –

 

Step 5 :

Use the dgmgrl utility to connect to the primary server.

Step 6: Now configure the broker service on the primary server.

Step 7 : Now add the standby database in the above configuration.

Note: – help add command will show the syntax of how to add the standby database in the above configuration.

Step 8:

Now you need to enable the configuration.

We can see from the above output our broker configuration has been enabled.

Step 9)Now we need to set the below property

These below two properties are used to sync the log file between primary and standby.

Step 10:

If you want to check the detailed information then you can use below commands.

1) show instance prod: –

It will give the status of the primary Instance.

2) show instance dr: – 

It will give the status of the standby Instance.

3) show database verbose prod: –

It will give the detailed logs of the primary server.

4) show database verbose dr: –

It will give the detailed logs of the standby server.

We have successfully completed the step by step Configuration of Oracle DGMGRL Utility.

Thank you for giving your valuable time to read the above information.
Follow us on 
Website :  www.ktexperts.com
Facebook Page : KTExperts Facebook
Linkedin Page : KT EXPERTS Linkedin