Creating, Copying and Moving an SPFILE Into a Disk Group
Oracle ASM 18c supports Oracle Database 18c or older software versions, including Oracle Database 10g Release 1 (10.1).
Get information of software version number and instance compatibility level.
select software_version, compatible_version from v$asm_client;
Note: COMPATIBLE.ASM disk group attribute is set to 11.2 or greater then you can create, copy, or move an Oracle ASM SPFILE into the disk group.
Create an SPFILE in a disk group
1. Connect to the Oracle ASM instance.
SQLPLUS / as sysdba
2. Create a SPFILE in diskgroup
CREATE SPFILE = '+DATA/asmspfile.ora' FROM PFILE = '$ORACLE_HOME/dbs/asmpfile.ora';
3. You can check grid plug play profile. Create Spfile command also update it.
ASMCMD [+] > spget
+DATA/ASM/ASMPARAMETERFILE/registry.253.813507611
4. Restart the ASM instance. So instance read spfile from new location.
shutdown
startup
Back Up Copy of an Oracle ASM SPFILE in a Disk Group
Backup can be taken with ASMCMD command shell.
1. Find the location of spfile.
ASMCMD [+] > spget
+DATA/ASM/ASMPARAMETERFILE/registry.253.849343867
2. Copy the Oracle ASM SPFILE to another disk group with spcopy command.
spcopy +DATA/ASM/ASMPARAMETERFILE/registry.253.849343867 +FRA/spfileCopyASM.ora
3. List all the copies of the Oracle ASM SPFILE file
ASMCMD [+] > ls -l --absolutepath FRA/ASM/ASMPARAMETERFILE
Type Redund Striped Time Sys Name
ASMPARAMETERFILE MIRROR COARSE JUN 06 13:00:00 Y +FRA/spfileCopyASM.ora => REGISTRY.
253.849533009
4. Restore the Spfile.
spcopy -u +FRA/spfileCopyASM.ora +DATA2/ASM/spfileASM.ora