1. Create spfile in ASM "+DATA" disk group :
SQL> connect / as sys
SQL> show parameter spfile NAME TYPE VALUE ------- ------- ------------------------------ spfile string /u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb11.ora SQL> create pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb11.ora' from spfile='/u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdb11.ora'; SQL> create pfile from spfile File created. SQL> create spfile='+DATA' from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb11.ora'; File created. SQL> exit
2. Modify inittestpk1.ora on rac1 and inittestpk2.ora on rac2 files to point to location in ASM
[oracle@rac1 dbs]$ echo "SPFILE='+RACDB_DATA/racdb1/spfileracdb1.ora'" > /u01/app/oracle/product/11.2.0/db_1/dbs/initracdb11.ora [oracle@rac1 dbs]$ ssh rac2 "echo \"SPFILE='+RACDB_DATA/racdb1/spfileracdb1.ora'\" > /u01/app/oracle/product/11.2.0/db_1/dbs/initracdb12.ora"
3. Update OCR with new SPFILE location
[oracle@rac1 dbs]$ srvctl modify database -d racdb1 -p +RACDB_DATA/racdb1/spfileracdb1.ora
4. Rename any existing spfiles in $ORACLE_HOME/dbs
5. Restart all instances to switch to new SPFILE
6. Check New Location For Spfile .
No comments:
Post a Comment