Move SPFILE to ASM RAC

— Move SPFILE to ASM RAC —

Already we have a PFILE called initmove.ora which was created previously from spfile

SQL> show parameter spfile

NAME TYPE VALUE
———————————— ———– ——————————
spfile string /u02/app/oracle/product/11.2.0
/dbhome_1/dbs/spfiletest1.ora

As you can see the spfile is in Filesystem

SQL> create spfile=’+DATAC1/test/spfiletest.ora’ from pfile=’/u03/rman/initmove.ora’;

File created.

SQL> exit

Create a pfile called inittest.ora and add only below line only in it ( format is init<sid>.ora )
spfile=’+DATAC1/test/spfiletest.ora’

SQL> shutdown immediate;

Now Startup database with this pfile and automatically it will point to the SPFILE which we created in the first step

SQL> startup nomount pfile=’/u03/rman/inittest.ora’;

SQL> show parameter spfile;

NAME TYPE VALUE
———————————— ———– ——————————
spfile string +DATAC1/eccdr/spfiletest.ora
SQL> exit

As you see now the SPFILE is in ASM disk group. Modify the database with SRVCTL incase you didnt add, add like below

srvctl modify database -d test-p +DATAC1/eccdr/spfiletest.ora

Advertisements

One thought on “Move SPFILE to ASM RAC

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s