Home » RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause

RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause

by tuanlp

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’

You may also like