Saturday, 18 February 2012

MOVING SPFILE FOR RAC DB IN ASM

$ sqlplus / as sysdba
SQL> create pfile='/home/oracle/pfile_Raju1.ora' from spfile;
File created.

SQL> create spfile='+RAJU1' from pfile='/home/oracle/pfile_zp1.ora';
File created.

you have to find the file name details in the asmcmd
After finding the name, you have to change to the database

$ srvctl modify database -d RAJU -p +RAJU1/RAJU/PARAMETERFILE/spfile.272.762954069
STOP AND START THE RAC DATASBASE
CHECK THE SPFILE LOCATION IN ALL NODES

SQL> show parameter spfile

NAME        TYPE        VALUE
--------- ----------- ------------------------------
spfile      string      +RAJU1/RAJU/parameterfile/spfile.272.762954069
Note: Remove your old spfile using rm command or ALTER DISKGROUP DISK_GROUP_NAME DROP FILE ‘OLD_LOCATION’;

No comments:

Post a Comment