Move SPFILE from local file system to ASM diskgroup

Move SPFILE from local file system
to ASM diskgroup

Step 1:

SQL> create spfile='+DG_DATA' from PFILE=’/u01/pfileORCL.ora’ ;

Login to ASM and insure the location of newly created SPFILE.

Step 2 :

move your current SPFILE with other name 

[oracle@rac122 dbs]$ mv spfileORCL1.ora spfileORCL1.ora_old

Create a default pfile and add the location of SPFILE which we created on above ASM Diskgroup.

[oracle@rac122 dbs]$ vi initORCL.ora

spfile='+DG_DATA/+DG_ORCL/ORCL/parameterfile/spfile.268.871385721'

Bounce Oracle Instance in order to read the server parameter file from new location (ASM Diskgroup).  Its read the default pfile and redirected to ASM Diskgroup location.

SQL> startup

ORACLE instance started.

Total System Global Area  551165952 bytes

Fixed Size                  2230232 bytes

Variable Size             230688808 bytes

Database Buffers          314572800 bytes

Redo Buffers                3674112 bytes

Database mounted.

Database opened.

SQL> show parameter spfile

NAME       TYPE        VALUE

---------- ----------- ---------------

Spfile    string     DG_ORCL/ORCL/parameterfile/spfile.268.871385721