11.2: how to recover from corrupt ASM spfile?
- From: Andreas Piesk <a.piesk@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 04 Mar 2010 23:15:21 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
