RE: ASM instance will not open HELP!

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Thu, 27 Jul 2006 10:23:41 +1000
Message-ID: <20060727102341067.00000004016@psharman-au>

Looks like an out of space error?

If it is, there's a script on Metalink to generate the alter diskgroup commands to remove files which should clear up the space. Of course, make sure you have the archives backed up before you just merrily delete them. :)

Pete

"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA

attached mail follows:

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:23:41 CDT