High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Issue with DG setup

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center