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