当前位置:  数据库>oracle

详解Oracle升高或降低参数Compatible

    来源: 互联网  发布时间:2017-04-15

    本文导语: 今天在看Oracle 10g的文档,注意到Irreversible Compatibility这个说法。 Starting with Oracle Database 10g, the COMPATIBLE initialization parameter becomes irreversible; that is, it cannot be set to a value that is less than a previous value. Therefore, the compatibility of the databas...

今天在看Oracle 10g的文档,注意到Irreversible Compatibility这个说法。

Starting with Oracle Database 10g, the COMPATIBLE initialization parameter becomes irreversible; that is, it cannot be set to a value that is less than a previous value. Therefore, the compatibility of the database can go only forward and never backward.
For example, suppose that you set COMPATIBLE to 10.0.0 and start up the database, then shut down the database to restart with COMPATIBLE set to 9.2.0. During startup, you get an error indicating that the compatible setting cannot be reversed.
If you do advance the compatibility of your database with the COMPATIBLE initialization parameter, there is no way to start the database using a lower compatibility level setting, except by doing a point-in-time recovery to a time before compatibility was advanced. Any changes since, are lost.

Consequently, the ALTER DATABASE RESET COMPATIBILITY command is now obsolete.

从10g开始COMPATIBLE 不能由高降低,难道9I可以?将compatiable从9.2.0.5改为9.2.0.1?我测试后果然可以。

以前我一直以为COMPATIBLE 在所有版本(包括patch set)都不能修改为更小的值,以为每次修改compatiable都会去修改所有的datafile header.

SQL> startup
ORACLE instance started.

Total System Global Area 272629760 bytes
Fixed Size 2035592 bytes
Variable Size 201330808 bytes
Database Buffers 62914560 bytes
Redo Buffers 6348800 bytes
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version 10.2.0.1.0
ORA-00202: control file: '/oracle/DDS/data03/lewu/data/cntrl_lewu_1.dbf'





看日志.

Starting ORACLE instance (normal)
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
compatible = 9.2.0.5


ARCH: STARTING ARCH PROCESSES
ARCH: STARTING ARCH PROCESSES COMPLETE
ALTER DATABASE MOUNT
Completed: ALTER DATABASE MOUNT
Wed Aug 27 20:53:23 2008
ALTER DATABASE OPEN
Completed: ALTER DATABASE OPEN





ALTER DATABASE CLOSE NORMAL
Completed: ALTER DATABASE CLOSE NORMAL

Starting ORACLE instance (normal)
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:

compatible = 9.2.0.0

ARCH: STARTING ARCH PROCESSES
ARCH: STARTING ARCH PROCESSES COMPLETE
ALTER DATABASE MOUNT
Completed: ALTER DATABASE MOUNT
ALTER DATABASE OPEN
Completed: ALTER DATABASE OPEN




数据库能够mount,但无法启动。看不来不能够跨大版本。

SQL> startup
ORACLE instance started.

Total System Global Area 689409008 bytes
Fixed Size 732144 bytes
Variable Size 352321536 bytes
Database Buffers 335544320 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-00402: database changes by release 9.2.0.0.0 cannot be used by release 8.1.7.0.0
ORA-00405: compatibility type "Locally Managed SYSTEM tablespace"






oracle@:/export/home/oracle/products/9205/dbs > oerr ora 00402
00402, 00000, "database changes by release %s cannot be used by release %s"
// *Cause: Changes have been made to the database that require a newer
// software release or that violate the compatibility parameters.
// *Action: Use a version of the software that can understand the changes or
// relax the compatibility requirements in the init file.





结论纠正以前的一个误区:compatible在9i的时候能降能升。10g开始不行了。


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • html保留字符详解
  • 关于tcp/ip详解卷2中的代码
  • Linux/centos/redhat下各种压缩解压缩方式详解
  • 请问哪儿有java2编程详解的电子书下载??本人急需!!跟贴有分!!!
  • linux c malloc函数定义及用法详解
  • 哪有LINUX命令详解下??
  • TCP协议报头字段详解及报头图
  • 请问:setTimeout(p1,p2) 的函数详解,马上给分的。
  • Web前端设计:html上标<sup>标签与下标<sub>标签详解
  • 求 sun ldoms 配置 虚拟化服务器 步骤详解
  • TCP协议三次握手过程详解
  • 请问:哪里可以下tcp/ip详解书上程序的源码
  • HTML 5 <acronym> 标签定义用法详解
  • linux 2.4 内核软中断详解?
  • c++断言assert()函数的头文件及其用法详解
  • 哪本书介绍mutex、POSIX 线程详解
  • html5/css3文本阴影(text-shadow)详解及示例
  • 哪位java同门师兄有《java2编程详解》电子文档,注意不是影印版
  • HTML 5中<address> 标签定义用法详解及几个示例
  • 如何在Linux下使用脚本实现程序的自动重启!望各位详解!
  • linux下进程占用内存空间详解
  • 大家推荐几本详解Linux或unix 操作系统源代码的书籍!!!!


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    oracle iis7站长之家