2 Replies Latest reply: Jan 3, 2013 4:32 AM by AlexAntonyArokiaraj RSS

    Fast Start Failover not Happening

    AlexAntonyArokiaraj
      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