11.2: how to recover from corrupt ASM spfile?
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