Re: Oracle Dataguard Issue Posted earlier
Date: Fri, 19 Feb 2016 04:05:40 +0000
Message-ID: <374644579.6650403.1455854740261.JavaMail.yahoo_at_mail.yahoo.com>
Max
So you are getting this alert when Switchover/Failover is performed or even with simple check the configuration like you have shown. Also do you have any Database level triggers like we used to have to allow application to transparently failover to online Primary or for any other reason as it can be the issue. Sanjay
On Thursday, February 18, 2016 10:45 AM, max scalf <oracle.blog3_at_gmail.com> wrote:
Sanjay,
Thank you for sending that info out. Even when issuing dgmgrl connected over TNS alias i get the same issue....
standby:/oracle/test> dgmgrlDGMGRL 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_at_test_sConnected.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 databaseDGM-17017: unable to determine configuration status
DGMGRL>
On Wed, Feb 17, 2016 at 3:41 PM Sanjay Mishra <dmarc-noreply_at_freelists.org> 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 belowDGMGRL> connect sys/xxxxxx_at_datadb1_STBY1
Step 1 : Failover from Current US Primary Database to US standby Server[oracle_at_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_at_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 FAILOVERORA-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 switchoverStart the Original US Primary Database which was taken down or been down due to Disaster[oracle_at_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 messageORACLE 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_at_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_at_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 SwitchoverDGMGRL> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 19 2016 - 05:05:40 CET