jueves, 5 de marzo de 2015

Move SPFILE from local file system Oracle 11G

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