Re: 2 Spfiles during restoration through RMAN on a different server

Posted by ErmanArslansOracleBlog on Jul 13, 2018; 7:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/2-Spfiles-during-restoration-through-RMAN-on-a-different-server-tp6395p6401.html

It may change according to your env.
You may be using ASM .. what is os and what is the Oracle version ...

Anyways, execute

sqlplus "/as sysdba"

Then execute;

SQL > show parameter spfile (this will show you your current spfile location)

Then, shutdown your database, backup your current spfile; put your restored spfile to this location with the same name as the current spfile), start your database..