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