----

3. When lowering the value of COMPATIBLE:

• You cannot start the database with lower compatibility, unless restoring from a backup. This is because datafiles contain COMPATIBLE information in their headers. If the parameter is increased and the database is then restarted, the datafile headers will be updated to the higher release. If then you decide to lower the parameter, this will fail with ORA-201/ORA-202.
• A default value is considered lower than a specific patchset value for the setting of the COMPATIBLE parameter. E.g. 10.2.0 is considered lower than 10.2.0.1, 10.2.0.2 etc.

-----

PURPOSE

This document aims to explain the circumstances when you may receive the below errors and what to consider in such cases: 
- ORA-201: control file version <num> incompatible with Oracle version <num> 
- ORA-202: control file: <name>

TROUBLESHOOTING STEPS

Getting ORA-201 and ORA-202 is directly connected to the COMPATIBLE initialization parameter:

• either you are trying to set COMPATIBLE to a wrong value
• or an incompatible operation is performed with regards to the current setting of COMPATIBLE

Significance and use of COMPATIBLE parameter:

• COMPATIBLE allows you to use a new release of Oracle, while at the same time guaranteeing backward compatibility with an earlier release. This is helpful if it becomes necessary to revert to the earlier release.
• It specifies the release with which Oracle needs to keep compatibility, at the same time permitting you to use some of the advantages of a newer release. Trying to use the new specific features which require compatibility set to the higher release will return errors.

Some requirements and restrictions that will help you to avoid ORA-201/ORA-202:

1. At upgrade/downgrade:

• For upgrade from 9.2.0.x to 11g it is mandatory to set the COMPATIBLE parameter to at least 10.1.0. After the upgrade has been completed successfully, it can be further increased accordingly if necessary.
• For upgrade from 10.1.0.x or 10.2.0.x to 11g you can leave the COMPATIBLE parameter set to its current value until the upgrade has been completed successfully.
• Downgrades from 11g to 9iR2 are not supported. This is because in the upgrade process the compatible parameter is set to a minimum 10.1.0. This prevents downgrades. For additional information, see 
  Note 388604.1 - ORA-00201 while downgrading from 10gR2 to 10gR1 or 9iR2

2. At database creation:

• For 11.2, the default value of the COMPATIBLE parameter is 11.2.0. The minimum value is 10.0.0.
• For 11.1, the default value of the COMPATIBLE parameter is 11.1.0. The minimum value is 10.0.0.
• For 10.2, the default value of the COMPATIBLE parameter is 10.2.0. The minimum value is 9.2.0.
• For 10.1, the default value of the COMPATIBLE parameter is 10.0.0. The minimum value is 9.2.0.
• For 9.2, the default value of the COMPATIBLE parameter is 8.1.0. The range of values is between 8.1.0 to the current release.

3. When lowering the value of COMPATIBLE:

• You cannot start the database with lower compatibility, unless restoring from a backup. This is because datafiles contain COMPATIBLE information in their headers. If the parameter is increased and the database is then restarted, the datafile headers will be updated to the higher release. If then you decide to lower the parameter, this will fail with ORA-201/ORA-202.
• A default value is considered lower than a specific patchset value for the setting of the COMPATIBLE parameter. E.g. 10.2.0 is considered lower than 10.2.0.1, 10.2.0.2 etc.

What to do if you get ORA-201/ORA-202

1. Set the COMPATIBLE initialization parameter to an appropriate value.
2. The impossibility to lower COMPATIBLE in some cases should not be confused with the ability to downgrade a database. It is possible to 'downgrade' a database but only as far as the compatible value setting. That is, if the db has been operating with compatible=9.2.0, you can downgrade from 10.x to 9.2.0.1.0. If the db was operating with compatible=10.1.0, you can downgrade to 10.1.0.2.0 (initial 10g Release). Outside of these restrictions you must use export/import to downgrade.
3. Another option, if you need the COMPATIBLE setting lowered, you can do a point-in-time recovery to a time before the compatibility was advanced.
4. Recreate the control files to make them compatible with the needed release. There is a problem at controlfile level when the error message does not contain version numbers: "control file version incompatible with Oracle version" . This may indicate that the controlfile is corrupt. This may also help when no backup is available

Other observations

• to avoid the errors in RAC the instances must have the COMPATIBLE parameter set to the same value
• to avoid the errors in standby database, this parameter must have the same value on both the primary and standby databases

4. If Controlfile is corrupted, check ORA-00227, ORA-00202: BRING UP INSTANCE AFTER MACHINE CRASH (Doc ID 1072762.6)

最新文章

1. 跨域攻击xss
2. jieba
3. Javascript中对象的Obeject.defineProperty()方法-------------（ES5/个人理解）
4. &lt;关于数据仓库&gt;基于docker的Mysql与Hadoop/Hive之间的数据转移 (使用Apache Sqoop™)
5. 定时组件quartz系列&lt;二&gt;quartz的集群原理
6. bzoj1034
7. js 实现 di
8. 文本注释系统 + MarkDown
9. hdu_3062_Party(2-SAT)
10. 判断android文件是否加壳
11. 十条很实用的jQuery代码片段
12. Ubuntu常用软件
13. A锚点实现，滚动页面内容改变tab选项
14. Tomcat服务启动成功，但访问index.jsp出错 (jspInit)【转】
15. SpringBoot启动方式讲解和部署war项目到tomcat9
16. C#将List&lt;&gt;转换为Json，将DataSet转成List&lt;T&gt;
17. [转载] Web Service工作原理及实例
18. 信息安全-加密：AES 加密
19. linux下将本地文件上传到github中？
20. 前端最全的 API 集锦

热门文章

1. function几种自执行的形式
2. 杭电acm刷题（3）：1062，Text Reverse 标签： 杭电acm 2017-05-15 08:26 126人阅读 评论(0)
3. HTML5应用程序缓存Application Cache.RP
4. getline()函数的两种用法
5. 通过ADB命令行卸载或删除你的Android设备中的应用（转载）
6. Exception in thread "main" brut.androlib.err.UndefinedResObject: resource spec: 0x01030200
7. ubuntu - 14.04，安装Eclipse（开源开发工具）
8. numpy中argsort函数用法
9. ReentrantReadWriteLock原理
10. c++ string.c_str()小结