Re: ASM instance will not open HELP!

  • From: Steve Perry <sperry@xxxxxxxxxxx>
  • To: johan.muller@xxxxxxxxx
  • Date: Thu, 27 Jul 2006 20:51:13 -0500

If you haven't found it, I think Pete was referring to Note:300472.1
how to delete archive log files out of +ASM


On Jul 26, 2006, at 07:13 PM, Johan Muller wrote:

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



Other related posts: