This discussion is archived
2 Replies Latest reply: Jan 3, 2013 2:32 AM by AlexAntonyArokiaraj RSS

Fast Start Failover not Happening

AlexAntonyArokiaraj Newbie
Currently Being Moderated
Dear Forum Members,

The DGMGRL Status shows no errors. See the output Below. Fast Start Failover is enabled. The Failover threshold is configured to be 30 Seconds. logxptmode is set to SYNC in both Primary and Standby Databases. However When I shutdown Primary, the standby database does not take over as Primary. It shows no changes after 30 Seconds, except that TNS connection failure is thrown in Standby alert log towards Primary DB. Can anyone please help ?

Data Guard configuration Status
DGMGRL> show configuration verbose

Configuration - DRSolution

  Protection Mode: MaxAvailability
  Databases:
    emadb   - Primary database
    emadbdg - (*) Physical standby database

  (*) Fast-Start Failover target

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'FALSE'
    BystandersFollowRoleChange      = 'ALL'

Fast-Start Failover: ENABLED

  Threshold:        30 seconds
  Target:           emadbdg
  Observer:         emarn2
  Lag Limit:        30 seconds (not in use)
  Shutdown Primary: FALSE
  Auto-reinstate:   TRUE

Configuration Status:
SUCCESS
Primary database Status n DGMGRL
DGMGRL> show database verbose emadb

Database - emadb

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    emadb

  Properties:
    DGConnectIdentifier             = 'emadb'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    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          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'emadbdg, emadb'
    LogFileNameConvert              = '/opt/app/oracle/oradata/emadbdg, /opt/app/oracle/oradata/emadb'
    FastStartFailoverTarget         = 'emadbdg'
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'emadb'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emarn1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=emadb_DGMGRL)(INSTANCE_NAME=emadb)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/opt/app/oracle/oradata/emadb/archivelog1'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS
Physical Standby Database Status in DGMGRL
DGMGRL> show database verbose emadbdg

Database - emadbdg

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: OFF
  Instance(s):
    emadbdg

  Properties:
    DGConnectIdentifier             = 'emadbdg'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    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          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'emadb, emadbdg'
    LogFileNameConvert              = '/opt/app/oracle/oradata/emadb, /opt/app/oracle/oradata/emadbdg'
    FastStartFailoverTarget         = 'emadb'
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'emadbdg'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emarn2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=emadbdg_DGMGRL)(INSTANCE_NAME=emadbdg)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/opt/app/oracle/oradata/emadbdg/archivelog1'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points