Creating, Copying and Moving an SPFILE Into a Disk Group Oracle ASM

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

4. Restart the ASM instance. So instance read spfile from new location.


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

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

4. Restore the Spfile.

spcopy -u +FRA/spfileCopyASM.ora +DATA2/ASM/spfileASM.ora

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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