Thursday, June 12, 2014

How to solve RMAN-06217 during cloning from active database


RMAN-03002: failure of Duplicate Db command at 06/12/2014 12:28:00
 RMAN-05501: aborting duplication of target database
 RMAN-06217: not connected to auxiliary database with a net service name

Workaround is to connect to the auxiliary database using username and password, followed by the TNS alias.
So instead of
 connect target sys/<password>@PRODDB01
 connect rmanuser/<password>@RMANCAT
 connect auxiliary /
use
 connect target sys/<password>@PRODDB01
 connect rmanuser/<password>@RMANCAT
 connect auxiliary sys/<password>@AUX01

1 comment:

  1. How do you handle the below error during the duplication while the script try to start up the clone instance
    RMAN-03002: failure of Duplicate Db command at 03/16/2021 19:20:24

    RMAN-05501: aborting duplication of target database

    RMAN-03015: error occurred in stored script Memory Script

    RMAN-04014: startup failed: ORA-01031: insufficient privileges

    ReplyDelete