7 Replies Latest reply: Apr 7, 2013 12:25 AM by 879152 RSS

    During primary(old standby)  to standby(old primary) switchover hang?

    879152
      Hi,

      I am using RAC to RAC data guard environment. Os hp-unix.
      during primary(old standby) to standby(old primary) switchover I am ussing:

      SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

      I have 11.2.0.1 environment with standby and when performing switch over - it was hanging for more than 2 hours and i had to cancel it. This is what all i see in the database alert.log:


      Errors in file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m000_15160.trc:
      ORA-01155: the database is being opened, closed, mounted or dismounted
      Thu Apr 04 17:44:03 2013
      Errors in file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m000_15780.trc:
      ORA-01155: the database is being opened, closed, mounted or dismounted
      Thu Apr 04 17:59:03 2013
      Errors in file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m001_16373.trc:
      ORA-01155: the database is being opened, closed, mounted or dismounted
      Thu Apr 04 18:14:03 2013
      Errors in file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m000_16942.trc:
      ORA-01155: the database is being opened, closed, mounted or dismounted
      Thu Apr 04 18:29:03 2013
      Errors in file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m000_17522.trc:
      ORA-01155: the database is being opened, closed, mounted or dismounted

      ####
      drpdb1_m000_17522.trc:
      ##

      Trace file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m000_17522.trc
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
      Data Mining and Real Application Testing options
      ORACLE_HOME = /u02/app/oracle/product/11.2.0/dbhome_1
      System name:     HP-UX
      Node name:     drpdb1
      Release:     B.11.31
      Version:     U
      Machine:     ia64
      Instance name: drpdb1
      Redo thread mounted by this instance: 1
      Oracle process number: 0
      Unix process pid: 17522, image: oracle@drpdb1 (M000)


      *** 2013-04-04 18:29:03.867
      Ioctl ASYNC_CONFIG error, errno = 1
      Ioctl ASYNC_CONFIG error, errno = 1
      Ioctl ASYNC_CONFIG error, errno = 1
      *** SESSION ID:(1894.55) 2013-04-04 18:29:03.871
      *** SERVICE NAME:() 2013-04-04 18:29:03.871
      *** MODULE NAME:(MMON_SLAVE) 2013-04-04 18:29:03.871
      *** ACTION NAME:(Monitor FRA Space) 2013-04-04 18:29:03.871

      ORA-01155: the database is being opened, closed, mounted or dismounted


      How to Solve?

      Please reply.

      Thanks
      SOlaiman