How to resolve the error RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause ?
Error:
Starting Duplicate Db at 9-SEP-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 9/12/2014 11:27:52
RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause
I got this error while trying to duplicate a database from backup location.
duplicating database:
http://orcl11gdba.blogspot.in/2014/03/duplicate-or-clone-database-from_10.html
http://orcl11gdba.blogspot.in/2014/03/duplicate-or-clone-database-from.html
Cause:
it is required to startup the database with pfile before we are going to connect to auxiliary instance.
Action:
shut down the database
sql> shut immediate /shut abort
startup the database with pfile
sql> startup nomount pfile =’initpavantes.ora’