Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User_CSOQUApr 4 2013 — edited Apr 7 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2013

Added on Apr 4 2013

#11gr2, #data-guard, #dataguard, #grid, #performance-availability, #rac

7 comments

1,619 views