升级10.2.0.1到10.2.0.3,把初始化参数文件的compatible='10.2.0.3.0'进行升级. 如果数据库升级要考虑到降级,那么compatible应与升级前的compatible保持一致.
在做降级测试时,发现降级报错
===============================
PL/SQL procedure successfully completed.
Function created.
Function dropped.
DECLARE
*
ERROR at line 1:
ORA-39707: compatibile parameter 10.2.0.3.0 too high for downgrade to
10.2.0.1.0
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at line 28
============================
compatible高于降级的版本,以至数据库不能完成降级,尝试修改compatible='10.2.0.1.0',在startup后报错.
=====================================
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 5368709120 bytes
Fixed Size 2062520 bytes
Variable Size 939525960 bytes
Database Buffers 4412407808 bytes
Redo Buffers 14712832 bytes
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version
10.2.0.1.0
ORA-00202: control file: 'K:\MRPC\CONTROL01.CTL'
====================================
When to Set the COMPATIBLE Initialization Parameter
Once the upgrade is complete, you can increase the setting of the COMPATIBLE initialization parameter to the maximum level for the Oracle Database 10g release. However, after you do this, the database cannot subsequently be downgraded.
阅读(1622) | 评论(0) | 转发(0) |
