Tuesday, September 27, 2011

MOVING SPFILE FOR RAC DB IN ASM


$ sqlplus / as sysdba

SQL> create pfile='/home/oracle/pfile_Bhuvan1.ora' from spfile;

File created.

SQL> create spfile='+BHUVAN1' 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 BHU -p +BHUVAN/BHU/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      +BHUVAN/BHU/parameterfile
                                                 /spfile.272.762954069


Note: Remove your old spfile using rm command or ALTER DISKGROUP DISK_GROUP_NAME DROP FILE ‘OLD_LOCATION’;

1 comment: