Issue with DG setup
edited Mar 20, 2013 6:39PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 19 commentsAnswered
There is some issue with my DG setup.
DGMGRL> show configuration verbose;
Configuration - PHOHCM
Protection Mode: MaxPerformance
Databases:
PHOHCM01 - Primary database
PHOHCMDR - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to 'PHOHCMDR';
Performing switchover NOW, please wait...
This simply hangs...
Error:
ORA-01013: user requested cancel of current operation
ORA-06512: at "SYS.DBMS_DRS", line 157
ORA-06512: at line 1
Unable to switchover, primary database is still "PHOHCM01"
Attached are alert.log from primary & standby
DGMGRL> show configuration verbose;
Configuration - PHOHCM
Protection Mode: MaxPerformance
Databases:
PHOHCM01 - Primary database
PHOHCMDR - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to 'PHOHCMDR';
Performing switchover NOW, please wait...
This simply hangs...
Error:
ORA-01013: user requested cancel of current operation
ORA-06512: at "SYS.DBMS_DRS", line 157
ORA-06512: at line 1
Unable to switchover, primary database is still "PHOHCM01"
Attached are alert.log from primary & standby
0