RMAN-06136: ORACLE error from auxiliary database: ORA-00201: control file versio n 12.1.0.0.0 incompatible with ORACLE version 12.0.0.0.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 12.1.0.0.0 incompatible with ORACLE version 12.0.0.0.0
Cause:
Target database might be having lower Compatibility set in parameter file /SPFILE
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 12.1.0.0
nls_comp string BINARY
plsql_v2_compatibility boolean FALSE
Solution
==========
create pfile manually ( initTEST.ora)
Add below lines only
DB_NAME=TEST
*.compatible='12.1.0.0.0'
No comments:
Post a Comment