My Oracle Support Banner

EXADATA While Duplicate Database From Activate Database Countered Error ORA-17628 (Doc ID 1643134.1)

Last updated on JANUARY 01, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Checked for relevance on 02-JUL-2015

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Database Name:  HRDSSD

*************

Executing RMAN duplicate command and experiencing remote server disconnect errors. 

rman target sys/<password>@<target service> auxiliary sys/<password>@<auxiliary service> log rman_dup.log trace rman_dup.trc
RMAN> connect target *
2> connect auxiliary *
3> run{
4> allocate channel c1 type disk;
5> allocate channel c2 type disk;
6> allocate channel c3 type disk;
7> allocate channel c4 type disk;
8> allocate channel c5 type disk;
9> allocate channel c6 type disk;
10> allocate auxiliary channel cr1 type disk;
debug on;
16> DUPLICATE TARGET DATABASE TO HRDSSD FROM ACTIVE DATABASE;
debug off
17> }

DBGRPC:               CMD type=backup cmdid=1 status=STARTED
DBGRPC:                     1 STEPstepid=1 cmdid=1 status=STARTED devtype=DISK
DBGRPC:               krmqgns: no work found for channel cr1 (krmqgns)
DBGRPC:                (krmqgns)
DBGRPC:              EXITED krmqgns with status 1
DBGRPC:              krmxpoq - returning rpc_number: 19 with status: FINISHED16 for channel c1
DBGRPC:              krmxr - channel c1 calling peicnt
DBGRPC:              krmxrpc - channel c1 kpurpc2 err=19583 db=target proc=SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE excl: 162
DBGRPC:              krmxrpc - caloing krmxtrim: with message of length 162: @@@ORA-19583: conversation terminated due to error
DBGRPC:              ORA-17628: Oracle error 19505 returned by remote Oracle server
DBGRPC:              ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 1381
DBGRPC:              @@@
DBGMISC:             ENTERED krmzejob [06:52:20.650]
DBGMISC:              Input Args(failed=1),(errnum=-19583) [06:52:20.650] (krmzejob)
DBGMISC:              duration(stepid=1),endtime=842619140,jobtime=391s [06:52:20.650] (krmzejob)
DBGMISC:              duration(stepid=1), remaining(chn sec,bytes)=(0,183599104) [06:52:20.650] (krmzejob)
DBGMISC:             EXITED krmzejob with status 0 (FALSE) [06:52:20.650] elapsed time [00:00:00:00.000]
DBGRPC:              krmxrpc - channel c1 kpurpc2 err=0 db=target proc=SYS.DBMS_BACKUP_RESTORE.GETLIMIT excl: 0
DBGRPC:              krmxr - channel c1 returned from peicnt
DBGMISC:             ENTERED krmstrim [06:52:20.650]
DBGMISC:              Trimming message: ORA-19583: conversation terminated due to error [06:52:20.650] (krmstrim)
DBGMISC:              ORA-17628: Oracle error 19505 returned by remote Oracle server (krmstrim)
DBGMISC:              ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 1381 (krmstrim)
DBGMISC:              ORA-06512: at line 631 (krmstrim)
DBGMISC:               (185) (krmstrim)

             RMAN-08584: copying current control file
DBGMISC:             EXITED krmzlog [06:48:45.587] elapsed time [00:00:00:00.000]
DBGRPC:              krmxrpc - channel c1 kpurpc2 err=0 db=target proc=SYS.DBMS_BACKUP_RESTORE.BACKUPSTATUS excl: 0
DBGRPC:              krmxrpc - channel c1 kpurpc2 err=0 db=target proc=SYS.DBMS_BACKUP_RESTORE.SETLIMIT excl: 0
DBGRPC:              krmxrpc - channel c1 kpurpc2 err=0 db=target proc=SYS.DBMS_BACKUP_RESTORE.GENPIECENAME excl: 0
DBGRPC:              krmxrpc - channel c1 kpurpc2 err=0 db=target proc=SYS.DBMS_BACKUP_RESTORE.ISFILENAMEOMF excl: 0
DBGRPC:              krmxrpc - channel c1 kpurpc2 err=3123 db=target proc=SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE excl: 0

 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/19/2014 06:52:21
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on c1 channel at 03/19/2014 06:52:20
ORA-17628: Oracle error 19505 returned by remote Oracle server

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.