Monday 15 September 2014

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

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'




No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...