Find Out the Spfile Location in ASM
List the ASM Disk maps to be partition:
1. Find out the ASM disk configured.
or
ls -lr /dev/oracleasm/disks/*
2. Scan the headers of those device.
If the parameter spfile and spfflg returned some value that’s mean the spfile is located in that disk. if zero returns that’s means Spfile is not present in that disk.
kfdhdb.ausize: 1048576 ; 0x0bc: 0×00100000
kfdhdb.spfile: 0 ; 0x0f4: 0×00000000
kfdhdb.spfflg: 0 ; 0x0f8: 0×00000000
Search Spfile information in this Diskgroup
Repeat this steps for all mount point untill you find the spfile. As follows:
kfdhdb.ausize: 1048576 ; 0x0bc: 0×00100000
kfdhdb.spfile: 16 ; 0x0f4: 0×00000010
kfdhdb.spfflg: 1 ; 0x0f8: 0×00000001
The device /dev/sdb3 contains a copy of the ASM spfile (spfflg=1).The ASM spfile location starts at the disk offset of 16 (spfile=16). Considering the allocation unit size (kfdhdb.ausize = 1M),
Start the dump process as follows:
4. Use Strings command to read the spfileASM.ora
It will give you the ASM file from ASM storage.
