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

 

Advertisements
This entry was posted in Oracle Database Clone Issues. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s