9 Replies Latest reply: Jul 22, 2012 8:44 PM by 849425 RSS

    error in swithover to standby

    621217
      In my 11g r2 database on enterprise linux 5.5。I configured one physical standby named "pc01sby1" for the primary database called "pc01prmy".I have configured DG configuration correctly.
      When I switchover to the standby,the process interrupt.

      DGMGRL> switchover to pc01sby1;
      Performing switchover NOW, please wait...
      Error: ORA-16552: error occurred while generating directives for client
      Error: ORA-16501: the Data Guard broker operation failed

      Failed.
      Unable to switchover, primary database is still "pc01prmy"

      But after I startup the old primary database into mount and startup the new primary database.All is ok,redo transport and apply have no error,also dg configuration is ok.
      Now I switchover back to the old primary database
      DGMGRL> switchover to pc01prmy;
      Performing switchover NOW, please wait...
      New primary database "pc01prmy" is opening...
      Operation requires shutdown of instance "pc01sby1" on database "pc01sby1"
      Shutting down instance "pc01sby1"...
      ORA-01109: database not open

      Database dismounted.
      ORACLE instance shut down.
      Operation requires startup of instance "pc01sby1" on database "pc01sby1"
      Starting instance "pc01sby1"...
      ORACLE instance started.
      Database mounted.
      Switchover succeeded, new primary is "pc01prmy"

      This operation success with no error message.
      Where is the clue?
      The configuration of the two database is :
      DGMGRL> show database verbose pc01sby1;

      Database - pc01sby1

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

      Properties:
      DGConnectIdentifier = 'pc01sby1'
      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 = '4'
      LogArchiveMinSucceedDest = '1'
      DbFileNameConvert = '/u01/app/oracle/oradata/pc01prmy, /u01/app/oracle/oradata/pc01sby1'
      LogFileNameConvert = '/u01/app/oracle/oradata/pc01prmy, /u01/app/oracle/oradata/pc01sby1'
      FastStartFailoverTarget = ''
      StatusReport = '(monitor)'
      InconsistentProperties = '(monitor)'
      InconsistentLogXptProps = '(monitor)'
      SendQEntries = '(monitor)'
      LogXptStatus = '(monitor)'
      RecvQEntries = '(monitor)'
      HostName = 'node3.jhs'
      SidName = 'pc01sby1'
      StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node3.jhs)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=pc01sby1_DGMGRL)(INSTANCE_NAME=pc01sby1)(SERVER=DEDICATED)))'
      StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
      AlternateLocation = ''
      LogArchiveTrace = '0'
      LogArchiveFormat = '%t_%s_%r.dbf'
      TopWaitEvents = '(monitor)'

      Database Status:
      SUCCESS

      DGMGRL> show database verbose pc01prmy;

      Database - pc01prmy

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

      Properties:
      DGConnectIdentifier = 'pc01prmy'
      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 = '4'
      LogArchiveMinSucceedDest = '1'
      DbFileNameConvert = '/u01/app/oracle/oradata/pc01sby1, /u01/app/oracle/oradata/pc01prmy'
      LogFileNameConvert = '/u01/app/oracle/oradata/pc01sby1, /u01/app/oracle/oradata/pc01prmy'
      FastStartFailoverTarget = ''
      StatusReport = '(monitor)'
      InconsistentProperties = '(monitor)'
      InconsistentLogXptProps = '(monitor)'
      SendQEntries = '(monitor)'
      LogXptStatus = '(monitor)'
      RecvQEntries = '(monitor)'
      HostName = 'node3.jhjjzd.com'
      SidName = 'pc01prmy'
      StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node3.jhjjzd.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=pc01prmy_DGMGRL)(INSTANCE_NAME=pc01prmy)(SERVER=DEDICATED)))'
      StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
      AlternateLocation = ''
      LogArchiveTrace = '0'
      LogArchiveFormat = '%t_%s_%r.dbf'
      TopWaitEvents = '(monitor)'

      Database Status:
      SUCCESS


      Is this the bug on 11g release 2?
      Can anybody help me?