ASM instance will not open HELP!

From: Johan Muller <johan.muller_at_gmail.com>
Date: Wed, 26 Jul 2006 19:13:11 -0500
Message-ID: <44c8051f.1d202722.7ea3.07a1@mx.gmail.com>

From the alert log (rac 2 node cluster on solaris with shared raw device):

Wed Jul 26 16:43:15 2006
Errors in file /u01/app/oracle/admin/rac1db/udump/rac1db1_ora_6522.trc: ORA-19504: failed to create file "+ORA_DATA/rac1db/1_244_571764559.dbf" ORA-17502: ksfdcre:4 Failed to create file +ORA_DATA/rac1db/1_244_571764559.dbf

It seems to be at the point where the archiver is stuck; I need to add a disk to the archive diskgroup but the instance will not open.

Wed Jul 26 16:43:15 2006
ARCH: Error 19504 Creating archive log file to '+ORA_DATA/rac1db/1_244_571764559.dbf'
Reconfiguration complete
Wed Jul 26 16:43:15 2006
ARCH: Failed to archive thread 1 sequence 244 (19504) Wed Jul 26 16:43:15 2006
Errors in file /u01/app/oracle/admin/rac1db/udump/rac1db1_ora_6522.trc:

ORA-16038: log 2 sequence# 244 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1:

'+ORA_DATA/rac1db/onlinelog/group_2.258.571764567' USER: terminating instance due to error 16038 Wed Jul 26 16:43:15 2006
Errors in file /u01/app/oracle/admin/rac1db/bdump/rac1db1_lms0_6087.trc: ORA-16038: log sequence# cannot be archived Wed Jul 26 16:43:15 2006
Errors in file /u01/app/oracle/admin/rac1db/bdump/rac1db1_lmd0_6082.trc: ORA-16038: log sequence# cannot be archived Wed Jul 26 16:43:15 2006
Errors in file /u01/app/oracle/admin/rac1db/bdump/rac1db1_pmon_6063.trc: ORA-16038: log sequence# cannot be archived Wed Jul 26 16:43:15 2006
System state dump is made for local instance System State dumped to trace file
/u01/app/oracle/admin/rac1db/bdump/rac1db1_diag_6065.trc Wed Jul 26 16:43:16 2006
Trace dumping is performing id=[cdmp_20060726164315] Wed Jul 26 16:43:21 2006
Instance terminated by USER, pid = 6522

I have searched high and low but no obvious answers - any ideas how to work around/out of this mess

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 26 2006 - 19:13:11 CDT