Re: DataGuard Failover Test issues
Date: Thu, 11 Feb 2016 10:34:06 -0600
Message-ID: <CAKoJ+qCZAAC=b1V=m8WUMSQVRuQSOybKB9=S0c3TSdSTtsfNew_at_mail.gmail.com>
Here it is...
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:
SUCCESS
DGMGRL>
DGMGRL> show database verbose test_p;
Database - test_p
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
test
Properties:
DGConnectIdentifier = 'test_p'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '5'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = '/oracle/test/origlogA/,
/oracle/test/origlogA/, /oracle/test/origlogB/, /oracle/test/origlogB/,
/oracle/test/standbylog, /oracle/test/standbylog'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'test'
StaticConnectIdentifier = 'test_P'
StandbyArchiveLocation = '/oracle/test/oraarch/testarch'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> DGMGRL> DGMGRL> DGMGRL> show database verbose test_s;
Database - test_s
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago) Apply Rate: 78.00 KByte/s
Real Time Query: OFF
Instance(s):
test
Properties:
DGConnectIdentifier = 'test_s'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '5'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = '/oracle/test/origlogA/,
/oracle/test/origlogA/, /oracle/test/origlogB/, /oracle/test/origlogB/,
/oracle/test/standbylog, /oracle/test/standbylog'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'test'
StaticConnectIdentifier = 'test_S'
StandbyArchiveLocation = '/oracle/test/oraarch/testarch'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> exit
standby:/oracle/test> standby:/oracle/test> standby:/oracle/test> standby:/oracle/test> standby:/oracle/test> tnsping test_s
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 12-FEB-2016 03:32:18
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/oracle/test/11204/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY
= TEST.WORLD) (PROTOCOL = TCP) (HOST = standby) (PORT =1545)))
(CONNECT_DATA = (SID = test) (GLOBAL_NAME = test) (SERVICE_NAME= test_S)))
OK (0 msec)
standby:/oracle/test>
standby:/oracle/test> tnsping test_p
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 12-FEB-2016 03:32:20
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/oracle/test/11204/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY
= TEST.WORLD) (PROTOCOL = TCP) (HOST = primary) (PORT =1545)))
(CONNECT_DATA = (SID = test) (GLOBAL_NAME = test) (SERVICE_NAME = test_P)))
OK (10 msec)
standby:/oracle/test>
On Thu, Feb 11, 2016 at 10:20 AM, abu fazal md abbas <abbas.appsdba_at_yahoo.in
> wrote:
> Hi,
>
> It seems to be an issue with connection timeout settings.
>
> Could you provide the output of the following
>
> dgmgrl> show database verbose test_p
> dgmgrl> show database verbose test_s
>
> and then from both primary and standby servers
>
> $ tnsping test_p
> $ tnsping test_s
>
>
>
> *Thanks and Regards,*
>
> Abbas
>
> *Abu Fazal Mohammed Abbas*
> Website: www.oraclebuffer.com
>
>
> ------------------------------
> *From:* max scalf <oracle.blog3_at_gmail.com>
> *To:* Oracle Mailing List <oracle-l_at_freelists.org>
> *Sent:* Thursday, 11 February 2016 8:49 PM
> *Subject:* Re: DataGuard Failover Test issues
>
> quick update to that, after about 20 mins of hanging i got below error
> from show config...
>
> Configuration Status:
> ORA-16662: network timeout when contacting a database
> DGM-17017: unable to determine configuration status
>
> DGMGRL>
>
>
> On Thu, Feb 11, 2016 at 9:18 AM, max scalf <oracle.blog3_at_gmail.com> wrote:
>
> hello list,
>
> We are in process of testing failover for our 11.2.0.4 data guard
> environement. While under normal circumstance when we ran show
> configuration for data guard broker we get success message as shown below
>
> DGMGRL> show configuration verbose;
>
> Configuration - test_config
>
> Protection Mode: MaxPerformance
> Databases:
> test_p - Primary database
> test_s - Physical standby database
>
> Properties:
> FastStartFailoverThreshold = '30'
> OperationTimeout = '30'
> FastStartFailoverLagLimit = '30'
> CommunicationTimeout = '180'
> ObserverReconnect = '0'
> FastStartFailoverAutoReinstate = 'TRUE'
> FastStartFailoverPmyShutdown = 'TRUE'
> BystandersFollowRoleChange = 'ALL'
> ObserverOverride = 'FALSE'
> ExternalDestination1 = ''
> ExternalDestination2 = ''
> PrimaryLostWriteAction = 'CONTINUE'
>
> Fast-Start Failover: DISABLED
>
> Configuration Status:
> SUCCESS
>
> DGMGRL>
>
> now when we literally go power off our primary host(test_p) and come over
> to standby host(test_p) we do show configuration it just hangs as shown
> below, I waited a good 20 mins but no luck
>
> DGMGRL> connect sys/XXXXXX;
> Connected.
> DGMGRL> show configuration verbose;
>
>
> i do see message in alert log as show below, once we shutdown primary...
> and when i issue show config in data guard broker, no errors in drcTEST.log
> file either...
>
> Fri Feb 12 02:13:00 2016
> RFS[5]: Possible network disconnect with primary database
> Fri Feb 12 02:13:00 2016
> RFS[6]: Assigned to RFS process 3786
> RFS[6]: Possible network disconnect with primary database
> Fri Feb 12 02:13:00 2016
> RFS[4]: Possible network disconnect with primary database
> Fri Feb 12 02:13:00 2016
> RFS[2]: Possible network disconnect with primary database
> Fri Feb 12 02:14:32 2016
>
>
>
> has anybody seem something similar ?? What am i doing wrong? I have
> tested switchover 10's of time successfully but when it comes to failover
> the show config part hangs....
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 11 2016 - 17:34:06 CET