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
No hay comentarios:
Publicar un comentario