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:
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:
- Stop the cluster stack on all nodes with: crsctl stop crs -f
- 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-lReceived on Thu Mar 04 2010 - 17:46:24 CST