This discussion is archived
7 Replies Latest reply: Apr 6, 2013 10:25 PM by 879152 RSS

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

879152 Newbie
Currently Being Moderated
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

Legend

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