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 Compatibility set in parameter file /SPFILE
Resolution:
Connect to sqlplus ‘/ as sysdba’ in target Database and issue the below command to check the compatibility set in Parameter file/SPFILE
SQL> show parameter comp
NAME TYPE Value
—————- ———— —————-
cell_offload_compaction string ADAPTIVE
compatible string 11.2.0.3
nls_comp string BINARY
plsql_v2_compatibility boolean FALSE
The above highlighted Parameter Name “compatible” is what we have to consider.
Give the exact same command “show parameter comp” in source environment as well and make sure “Compatible” is set the same value as Source.
alter system set compatible=’11.2.0.4′ scope=spfile;
Restart the instance and check the compatibility again and you may re-initiate the clone.
