11.2: how to recover from corrupt ASM spfile?

From: Andreas Piesk <a.piesk_at_gmx.net>
Date: Thu, 04 Mar 2010 23:15:21 +0100
Message-ID: <4B9030F9.9000005_at_gmx.net>



Hi list,

i ran some tests with a default installation of 11.2 GRID on RHEL5 64bit, ocr and votingdisks are in ASM. while running some storage failure scenarios i've somehow managed to corrupt the ASM spfile, so that ASM does not start anymore. after reinstalling from scratch i reproduced the problem by setting an invalid preferred_failure_group (doesn't matter which setting, it just has to be invalid):

# crsctl start crs
..

CRS-2672: Attempting to start 'ora.asm' on 'rac11r2-1'
ORA-01078: failure in processing system parameters
CRS-2674: Start of 'ora.asm' on 'rac11r2-1' failed

starting ASM manually with a pfile i saved earlier does not work, the instance terminates:

Connected to an idle instance.

SQL> startup nomount pfile='/tmp/a';
ORA-03113: end-of-file on communication channel SQL> Disconnected

alert.log:
Reconfiguration complete
Thu Mar 04 22:38:13 2010
LCK0 started with pid=22, OS id=6432
Thu Mar 04 22:38:15 2010
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 6450): terminating the instance Instance terminated by USER, pid = 6450
Thu Mar 04 22:38:15 2010
Instance shutdown complete

Question is, how to recover from such a scenario? any ideas?

regards,
-ap

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 04 2010 - 16:15:21 CST

Original text of this message