Duplicate from Active Database Failing with: RMAN-03009, ORA-17628, and ORA-19505 (Doc ID 1439632.1)

Last updated on JULY 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Aug-2013***

Symptoms

Recreating the standby database.

RMAN duplicate from active database failing with errors when the files already exist on disk under the same path and file name where the restore is being run.

The following errors reported:

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/22/2012 09:44:43
ORA-17628: Oracle error 19505 returned by remote Oracle server

-From the RMAN Log:


RMAN>
Starting Duplicate Db at 22-MAR-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=262 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=261 device type=DISK

contents of Memory Script:
{
backup as copy reuse
file '/db_scb/oracle/product/11.1.0/db_1/dbs/orapwautobk' auxiliary format
'/db_scp/oracle/product/11.1.0/db_1/dbs/orapwautopr' ;
}
executing Memory Script

Starting backup at 22-MAR-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=174 device type=DISK
Finished backup at 22-MAR-12

contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/ora1_scp/oradata/autopr/control01.ctl';
restore clone controlfile to '/ora1_scp/oradata/autopr/control02.ctl' from
'/ora1_scp/oradata/autopr/control01.ctl';
restore clone controlfile to '/ora1_scp/oradata/autopr/control03.ctl' from
'/ora1_scp/oradata/autopr/control01.ctl';
sql clone 'alter database mount standby database';
}
executing Memory Script

Starting backup at 22-MAR-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/db_scb/oracle/product/11.1.0/db_1/dbs/snapcf_autobk.f tag=TAG20120322T094333 RECID=17 STAMP=778585413
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 22-MAR-12

Starting restore at 22-MAR-12
using channel ORA_AUX_SBT_TAPE_1
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: skipped, AUTOBACKUP already found
channel ORA_AUX_SBT_TAPE_1: copied control file copy
Finished restore at 22-MAR-12

Starting restore at 22-MAR-12
using channel ORA_AUX_SBT_TAPE_1
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: skipped, AUTOBACKUP already found
channel ORA_AUX_SBT_TAPE_1: copied control file copy
Finished restore at 22-MAR-12

sql statement: alter database mount standby database

contents of Memory Script:
{
set newname for tempfile 1 to
"/ora1_scp/oradata/autopr/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/ora1_scp/oradata/autopr/system01.dbf";
set newname for datafile 2 to
"/ora1_scp/oradata/autopr/sysaux01.dbf";
set newname for datafile 3 to
"/ora1_scp/oradata/autopr/undotbs01.dbf";
set newname for datafile 4 to
"/ora1_scp/oradata/autopr/users01.dbf";
set newname for datafile 5 to
"/ora1_scp/oradata/autopr/mdb_DATA.dbf";
set newname for datafile 6 to
"/ora1_scp/oradata/autopr/mdb_INDEX.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/ora1_scp/oradata/autopr/system01.dbf" datafile
2 auxiliary format
"/ora1_scp/oradata/autopr/sysaux01.dbf" datafile
3 auxiliary format
"/ora1_scp/oradata/autopr/undotbs01.dbf" datafile
4 auxiliary format
"/ora1_scp/oradata/autopr/users01.dbf" datafile
5 auxiliary format
"/ora1_scp/oradata/autopr/mdb_DATA.dbf" datafile
6 auxiliary format
"/ora1_scp/oradata/autopr/mdb_INDEX.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /ora1_scp/oradata/autopr/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 22-MAR-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/ora1_scb/oradata/autobk/system01.dbf
output file name=/ora1_scp/oradata/autopr/system01.dbf tag=TAG20120322T094356 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/ora1_scb/oradata/autobk/sysaux01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/22/2012 09:44:43
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/ora1_scb/oradata/autobk/undotbs01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/22/2012 09:44:45
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/ora1_scb/oradata/autobk/mdb_DATA.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/22/2012 09:44:46
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/ora1_scb/oradata/autobk/mdb_INDEX.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/22/2012 09:44:47
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/ora1_scb/oradata/autobk/users01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/22/2012 09:44:48
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/22/2012 09:44:48
ORA-17628: Oracle error 19505 returned by remote Oracle server

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms