Category Archives: Oracle Database Clone Issues

RMAN-03009: failure of backup command on C05 channel at 02/12/2019 09:22:10 ORA-17628: Oracle error 19505 returned by remote Oracle server continuing other job steps, job failed will not be re-run

Posted on February 15, 2019 by pradeepvattem

Issue: While the RMAN Active Duplicate is initiated, the rman job failed with the below errors, RMAN-03009: failure of backup command on C05 channel at 02/12/2019 09:22:10 ORA-17628: Oracle error 19505 returned by remote Oracle server continuing other job steps, … Continue reading →

Posted in Oracle Database, Oracle Database Clone Issues | Leave a comment

ORA-01547, ORA-01194: file 1 needs more recovery to be consistent, ORA-01110, ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL

Posted on February 14, 2017 by pradeepvattem

About the issue/Background: The Database clone from PROD to Non-Prod environment is being performed using the Snap clone functionality. So, the essential part of DBA team is to put the Source Database in Begin Backup Mode. And once the Snap … Continue reading →

Posted in Oracle Database, Oracle Database Clone Issues | Leave a comment

ORA-17502: ksfdcre:4 Failed to create file, ORA-15046: ASM file name is not in single-file creation form

Posted on February 12, 2017 by pradeepvattem

Issue: While recreating the controlfile in an Oracle Database, below issue has been cropped in SQL> @SIT1_ora_11129.trc CREATE CONTROLFILE SET DATABASE “SIT” RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-00200: control file could not be created … Continue reading →

Posted in Oracle Database, Oracle Database Clone Issues | Leave a comment

RMAN-06136: ORACLE error from auxiliary database: ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.3.0

Posted on February 6, 2017 by pradeepvattem

Issue: While performing the clone of Oracle Database using ‘Active Duplication’, the clone may fail with below errors, RMAN-06136: ORACLE error from auxiliary database: ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.3.0 Cause: Target database might be having lower … Continue reading →

Posted in Oracle Database Clone Issues | Leave a comment

RMAN-06034: at least 1 channel must be allocated to execute this command

Posted on February 1, 2017 by pradeepvattem

Error: RMAN-06034: at least 1 channel must be allocated to execute this command Cause: During the active duplication, the channels need to be allocated for target database as well as the Auxiliary Database. So, the cause is ‘missing Channel Allocation’ … Continue reading →

Posted in Oracle Database Clone Issues | Leave a comment

ORA-04024: self-deadlock detected while trying to mutex pin cursor 0xC1F2B19A8, ORA-01092: ORACLE instance terminated. Disconnection forced

Posted on January 25, 2017 by pradeepvattem

I was performing a clone from a cold backup in a 12c (12.1.0.2) environment and was stuck with the errors (ORA-04024 and ORA-01092). The database restore was completed but while performing the ‘alter database open resetlogs’ it was giving the … Continue reading →

Posted in Oracle Database Clone Issues | 3 Comments

ORA-01187: cannot read from file because it failed verification tests, ORA-01110: data file 2514: ‘/u01/oracle/oratemp/fs01/temp1_07.dbf’

Posted on October 22, 2016 by pradeepvattem

The errors (ORA-01187, ORA-01110) occurred while registering Golden Gate processes with the Database. Below is the error observed in GG Logfile, Error in GG Logfile: 2016-10-14 08:35:14  ERROR   OGG-00664  Oracle GoldenGate Capture for Oracle, Capture1.prm:  OCI Error creating temporary LOB to … Continue reading →

Posted in Oracle Database Clone Issues | Leave a comment