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 Chennai viewed 'Purge AWR Snapshots Manually from Oracle Database' 8 mins ago

A visitor from Birmingham viewed 'Fix Dell Latitude Laptop Speaker Volume is Very lo' 19 mins ago

A visitor from Ashburn viewed 'How to Find out / Check SGA and PGA size of Oracle' 24 mins ago

A visitor from Gurgaon viewed 'How to Force Oracle RMAN to Delete All Archive log' 39 mins ago

A visitor from Mumbai viewed 'Purge AWR Snapshots Manually from Oracle Database' 2 hrs 58 mins ago

Real-time | Get Script | More Info