Category Archives: Oracle Database Clone Issues

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

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

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

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

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

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 | 2 Comments

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

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