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
+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

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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.