RMAN-03002: failure of Duplicate Db command at 06/18/2021 18:48:14-RMAN-05501: aborting duplication of target database-RMAN-05603: not connected to target database with a net service name

Cause:

I was trying to connect to target database without specifying service name

[oracle@orcl ~]$ rman target sys/password auxiliary sys/password@orcldgp

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jun 18 18:42:04 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1559282684)
connected to auxiliary database: ORCLDGP (not mounted)



RMAN> duplicate target database for standby from active database using backupset section size 300M nofilenamecheck;

Starting Duplicate Db at 18-JUN-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/18/2021 18:48:14
RMAN-05501: aborting duplication of target database
RMAN-05603: not connected to target database with a net service name

RMAN> exit

Workaround:

Specify the service name of target database to connect

[oracle@orcl ~]$ rman target sys/password@orcl auxiliary sys/password@orcldgp

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jun 18 18:48:49 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1559282684)
connected to auxiliary database: ORCLDGP (not mounted)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s