RMAN-06136: ORACLE error from auxiliary database: ORA-00201: control file version 12.1.0.2.0 incompatible with ORACLE version 12.1.0.0.0

Posted on December 14, 2020 by kishan1 Minute Read

Cause:

When cloning a database ,controlfile version is 12.1.0.0.0 in destination which is not compatible with the source database controlfile version 12.1.0.2.0 to restore

Solution:

SQL> alter system set compatible='12.1.0.2.0' scope=spfile;

System altered.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  218103808 bytes
Fixed Size                  2922712 bytes
Variable Size             159385384 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes

Published by kishan

Hungry and obsessive to learn ! Generic technology enthusiast who have dynamic experience in database and other technologies. I have persistence to learn any niche skills faster. Served multiple DBA roles in fortune 500 companies to proactively prevent unexpected failure events. Inclined to take risks,face challenging situations and embrace fear! ***Last but not the least. I would like to share my thoughts and ideas to this world !*** View all posts by kishan