Wednesday, January 29, 2020


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

  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...