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

From: Robert Bialek <bialekr_at_gmail.com>
Date: Fri, 05 Mar 2010 00:46:24 +0100
Message-ID: <4B904650.4040208_at_gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 04 2010 - 17:46:24 CST

Original text of this message