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
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’