RMAN Duplicate From On-Premise DB Is Failing With ORA-600 (Doc ID 2230068.1)

Last updated on FEBRUARY 17, 2017

Applies to:

Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

RMAN Active Database duplicate to create standby fails with errors.

RMAN> run
{
allocate channel prmy1 type disk;
allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
allocate auxiliary channel stby3 type disk;
allocate auxiliary channel stby4 type disk;
duplicate target database for standby from active database
section size 300M dorecover ;
}

Starting Duplicate Db at 31-JAN-2017 15:44:56
current log archived
contents of Memory Script:
{
backup as copy reuse targetfile '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwHRCLD'
auxiliary format '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwHRCLD' ;
restore clone from service 'HRCLD' spfile to '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfileHRCLD.ora';
sql clone "alter system set spfile= ''/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfileHRCLD.ora''";
}
executing Memory Script
Starting backup at 31-JAN-2017 15:44:58
ignoring encryption for proxy or image copies Finished backup at 31-JAN-2017 15:44:59
Starting restore at 31-JAN-2017 15:44:59
channel stby1: starting datafile backup
set restore channel stby1: using network backup
set from service HRCLD channel stby1: restoring SPFILE output file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfileHRCLD.ora
released channel: prmy1 PSDRPC returns significant error 600.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/31/2017 15:45:02
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-17627: ORA-03113: end-of-file on communication channel Process ID: Session ID: 367 Serial number: 51289
ORA-19558: error de-allocating device
ORA-19557: device error, device type: DISK, device name:
ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
ORA-17627: ORA-03113: end-of-file on communication channel Process ID: Session ID: 367 Serial number: 51289

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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