RMAN Duplicate From On-Premise DB Is Failing With ORA-600
(Doc ID 2230068.1)
Last updated on APRIL 28, 2024
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 '/<oracle home>/dbs/orapw<db name>' auxiliary format '/<oracle home>/dbs/orapw<db name>' ; restore clone from service '<servcice name>' spfile to '/<oracle home>/dbs/spfile<db name>.ora'; sql clone "alter system set spfile= ''/<oracle home>/dbs/spfile<db name>.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=/<oracle home>/dbs/spfile<db name>.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
