hello list,
We are in process of testing failover for our 11.2.0.4 data guard
environement. While under normal circumstance when we ran show
configuration for data guard broker we get success message as shown below
DGMGRL> show configuration verbose;
Configuration - test_config
Protection Mode: MaxPerformance
Databases:
test_p - Primary database
test_s - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
now when we literally go power off our primary host(test_p) and come over
to standby host(test_p) we do show configuration it just hangs as shown
below, I waited a good 20 mins but no luck
DGMGRL> connect sys/XXXXXX;
Connected.
DGMGRL> show configuration verbose;
i do see message in alert log as show below, once we shutdown primary...
and when i issue show config in data guard broker, no errors in drcTEST.log
file either...
Fri Feb 12 02:13:00 2016
RFS[5]: Possible network disconnect with primary database
Fri Feb 12 02:13:00 2016
RFS[6]: Assigned to RFS process 3786
RFS[6]: Possible network disconnect with primary database
Fri Feb 12 02:13:00 2016
RFS[4]: Possible network disconnect with primary database
Fri Feb 12 02:13:00 2016
RFS[2]: Possible network disconnect with primary database
Fri Feb 12 02:14:32 2016
has anybody seem something similar ?? What am i doing wrong? I have tested
switchover 10's of time successfully but when it comes to failover the show
config part hangs....