Sanjay,
Thank you for sending that info out. Even when issuing dgmgrl connected
over TNS alias i get the same issue....
standby:/oracle/test> dgmgrl
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/xxxxxx@test_s
Connected.
DGMGRL> show configuration;
Configuration - test_config
Protection Mode: MaxPerformance
Databases:
test_p - Primary database
test_s - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-16662: network timeout when contacting a database
DGM-17017: unable to determine configuration status
DGMGRL>
On Wed, Feb 17, 2016 at 3:41 PM Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Max
Just joined the group and saw the archive on the Dataguard Connection
error during failover. I got posting priviliges activated today and so here
is my thought on the issue.
I did few times failover and Switchover with 11g/12c. Below is the
scenario where I had one Primary and two Standby and recently did the
Failover from primary to one standby and then Reinstated and swichover back
to original Primary. THE KEY what I found and want to mentioned is to us
TNSALIAS which connecting to DGMGRL for any switchover/failover as shown
below
DGMGRL> connect sys/xxxxxx@datadb1_STBY1
Step 1 : Failover from Current US Primary Database to US standby Server
[oracle@Standby ~]$ dgmgrl
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.
DGMGRL> connect sys/xxxxxx@datadb1_STBY1
Connected.
DGMGRL> show configuration;
Configuration - testing
Protection Mode: MaxPerformance
Databases:
datadb1 - Primary database
datadb1_STBY1 - Physical standby database
datadb1_STBY2 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status: ==========> The error is fine as PRIMARY WAS TAKEN
DOWN TO TEST THE FAILOVER
ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor
ORA-16625: cannot reach database "datadb1"
DGM-17017: unable to determine configuration status
DGMGRL> failover to 'datadb1_STBY1';
Performing failover NOW, please wait...
Failover succeeded, new primary is "datadb1_STBY1"
Step 2: Switchback using Switchover to DB1 and making it back Primary with
no Database rebuild and configuration stays original - First Start Database
and then Reinstate it before switchover
Start the Original US Primary Database which was taken down or been down
due to Disaster
[oracle@primary ~]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Fri May 30 11:24:47 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
Show original message
ORACLE instance started.
Total System Global Area 3.2068E+10 bytes
Fixed Size 2244192 bytes
Variable Size 4496294304 bytes
Database Buffers 2.7515E+10 bytes
Redo Buffers 55267328 bytes
Database mounted.
ORA-16649: possible failover to another database prevents this database
from being opened
SQL> exit
Step 3 : Reinstate Database
[oracle@standby ~]$ dgmgrl
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.
DGMGRL> connect sys/xxxxxx@datadb1_STBY1
Connected.
DGMGRL> show configuration;
Configuration - testing
Protection Mode: MaxPerformance
Databases:
datadb1_STBY1 - Primary database
datadb1 - Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
datadb1_STBY2 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> reinstate database 'datadb1';
Reinstating database "datadb1", please wait...
Operation requires shutdown of instance "datadb1" on database "datadb1"
Shutting down instance "datadb1"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "datadb1" on database "datadb1"
Starting instance "datadb1"...
ORACLE instance started.
Database mounted.
Continuing to reinstate database "datadb1" ...
Reinstatement of database "datadb1" succeeded
Initiate the Switchover
DGMGRL> switchover to 'datadb1';
Performing switchover NOW, please wait...
New primary database "datadb1" is opening...
Operation requires shutdown of instance "datadb1" on database
"datadb1_STBY1"
Shutting down instance "datadb1"...
ORACLE instance shut down.
Operation requires startup of instance "datadb1" on database
"datadb1_STBY1"
Starting instance "datadb1"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "datadb1"
Sanjay