Starting a Rac Instance from the spfile of another instance for Oracle Database

At a Glance:

Create pfile. Modify pfile with the correct location Start instance with the new pfile.

Step 1: Create pfile from spfile:

create pfile='/tmp/pfile_n1_01062017' from spfile;

Step 2: Transfer the file to target node:

scp /tmp/pfile_n1_01062017 oracle@sdbabut2:/tmp/pfile_n1_01062017.ora

Step 3: Modify the file according to target node:

Fields: thread, instance_number,dispatchers

Replace source node service name by target host service name

:%s/source_host_service_name/target_host_service_name/g

Step 4: Start instance from modified pfile:

sqlplus / as sysdba > startup mount pfile=’/tmp/modifiedpfile.ora’

If it shows error, in that case modify accordingly.

If case of successfully start up,  need to alter the mode of the database.

sqlplus> alter database open;

If everything seems fine, create the spfile from the memory.

sqlplus> create spfile from memory;