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)
)
)