Hello,
We're on RAC in 11g on RH 6 on Dell with EqualLogic storage. Using ASMLib.
When installing the Grid infrastructure I left many things to defaults and ended up with:
o spfile parameter in +ASM1/2 instances is null;
o when dumping this spfile to a text pfile, I read the following:
~ +ASM1.asm_diskgroups='ARCH1','REDO1','FRA1','STBYREDO'#Manual Mount
~ +ASM2.asm_diskgroups='ARCH1','FRA1','REDO1','STBYREDO'#Manual Mount
~ *.asm_diskgroups='ARCH1','REDO1','FRA1','STBYREDO','DATA1' [<= here ALL my diskgroups are present !]
~ *.asm_diskstring='/dev/oracleasm/disks'
My questions:
1/ should I modify spfile parameter explicitly to the path I find in ASMCMD ??
(which is: should I do an "ALTER SYSTEM SET spfile='+DATA1/cluname/ASMPARAMETERFILE/REGISTRY.243.847143025' scope=both") ??
Regarding my asm_disk* parameters:
2/ when doing a "show parameter asm_disktring" (or a SELECT FROM gv$parameter) it is null, and the
doc says "The default value of the ASM_DISKSTRING parameter is a NULL string", which is what I have, then:
a) if I have no +ASM*.asm_diskstring parameter listed in my pfile indeed, how come I find a *.asm_diskstring with the good value ?
b) should I modify this parameter and do an explicit ALTER SYSTEM asm_diskstring to set it to '/dev/oracleasm/disks' ??
3/ asm_diskgroups only contain ARCH1, REDO1, FRA1 and STBYREDO: DATA1 is missing, therefore should I modify
this parameter and do an explicit ALTER SYSTEM asm_diskgroups to set it to 'ARCH1','REDO1','FRA1','STBYREDO','DATA1' ??
What is best practice here ?
4/ what is this "#Manual Mount" comment, where does it come from ?
In advance, thanks.
Regards,
Seb