On an Oracle 11204 restart environment, ASM spfile creation failed with error ora-600

create spfile='+DATA5' from pfile='/u03/asmpfile.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
ORA-00600: internal error code, arguments:
[ksprcvsp:ksfdread_resilver],[0x0A2435D48], [3],
[0x7F710EE38000], [512], [], [], [], [], [], [], []
This was caused due to a ASM disk with UNKNOWN HEADER_STATUS.

NAME                                PATH                 HEADER_STATU                FAILGROUP

----------------------         --------------     ------------                         ----------

_DROPPED_0000_DATA5  /dev/raw/raw1    MEMBER UNKNOWN     DATA5_FG1

DATA5_0001                    /dev/raw/raw2    MEMBER                          DATA5_FG2

Fixed the problem, by adding the disk in ASM diskgroup

SQL> alter diskgroup DATA5 add FAILGROUP DATA5_FG1 disk
'/dev/raw/raw1' force ;

Post this change, I was able to create spfile without any issue.

Metalink Doc ID 2096227.1

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.