DGMGRL ORA-16600: not connected to target standby database for failover

advertisements

_____________________________________________________________________________________________________________________

Error Description:

DGMGRL data guard failover filed with following error.
DGMGRL> failover to 'MQPRD';

Performing failover NOW, please wait...

Error: ORA-16600: not connected to target standby database for failover

Failed.

Unable to failover

Solution Description:

You need to connect to the standby database using dgmgrl utility. Suppose if you are connected to the current primary database you will get above error message. So either you will have to go to statndby database server or connect through tnsnames-service name as mentioned below.

$ dgmgrl sys/high123@TRPRO

DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
 
Welcome to DGMGRL, type "help" for information.
Connected.

DGMGRL> failover to 'TRPRO';

Performing failover NOW, please wait...
Failover succeeded, new primary is "TRPRO"

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Santa ana viewed 'RMAN Restore Failed RMAN-06100: no channel to rest' 11 mins ago

A visitor from Lima viewed 'Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options ' 2 hrs 31 mins ago

A visitor from Santo antonio de padua viewed 'Fix OEM emctl Error: Backend WLS or EM application' 3 hrs 27 mins ago

A visitor from Hyderabad viewed 'How to Find out / Check SGA and PGA size of Oracle' 3 hrs 30 mins ago

A visitor from Voronezh viewed 'How to Increase, Decrease or Resize FRA(Flash Reco' 4 hrs 54 mins ago

Real-time | Get Script | More Info