Re: 11.2: how to recover from corrupt ASM spfile?

  • From: Robert Bialek <bialekr@xxxxxxxxx>
  • To: a.piesk@xxxxxxx
  • Date: Fri, 05 Mar 2010 00:46:24 +0100

Hi Andreas,
# 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
Try the following:

1. Stop the cluster stack on all nodes with:
crsctl stop crs -f

2. Than start it only on one node in exclusive mode:
crsctl start crs -excl
crsctl check crs # OHAS and CSS should be online

SQL> startup pfile='YourASMPfileBackup'
SQL> create spfile='+DG' from pfile='YourASMPfileBackup';
crsctl stop crs -f

3. Start the cluster on all nodes

HTH,
Robert
--
//www.freelists.org/webpage/oracle-l


Other related posts: