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

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

If your "show parameter spfile" returns an empty output, you are not currently using a spfile.
So your database is currently using a pfile.

Put your spfile in $ORACLE_HOME/dbs folder, with the appropriate name.
Restart your db and your database will use that spfile.

The name of the sfile should be spfile<SID>.ora

Ex: If your ORACLE_SID=TEST, then spfile should be named as spfileTEST.ora