Skip to Main Content

Data Guard out of SYNC in EBS 12.1.3 after switchover in PRIMARY and STANDBY Site

User_6R4D3Dec 22 2020

Hi All,

I have one issue regarding data guard in ebs apps 12.1.3. Database 11gR2 (11.2.0.4), OS-rhel 7.9
After Switchover issue:
-----------------------
We are changing the Hostname entry in Primary_oracle_ifile.ora in both side PRIMARY & STANDBY site After switchover so that our application can connect to current DC (Which is actual physical standby database).
But if we defer or some how our network get disconnect between PRIMARY & STANDBY site then DC-DR goes out of sync and to Resolve this we have to again change hostname both DC-DR side in Primary_oracle_ifile.ora as per before switchover and stop the application, bounce back primary database again change the hostname entry accordingly.
How can we normalize the process after Switchover, what is the recommended way to take care of this??
After Switchover Entry:
-----------------------

PRDTSTDR =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER=YES)
(LOAD_BALANCE=YES)
(ADDRESS = (PROTOCOL = TCP)(HOST = prodtest1.co.in)(PORT = 1525))

(ADDRESS = (PROTOCOL = TCP)(HOST = prodtest2.co.in)(PORT = 1525)) --(Before Switchover)

)
(CONNECT_DATA =
(SID = PRODTEST)
)
)

PRODTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER=YES)
(LOAD_BALANCE=YES)
(ADDRESS = (PROTOCOL = TCP)(HOST = prodtest2.co.in)(PORT = 1525))

(ADDRESS = (PROTOCOL = TCP)(HOST = prodtest1.co.in)(PORT = 1525)) --(Before Switchover)

)
(CONNECT_DATA =
(SID = PRODTEST)
)
)

Comments
Post Details
Added on Dec 22 2020
0 comments
22 views