ORA-00201，ORA-00202

来源：互联网发布：动漫抱枕淘宝编辑：程序博客网时间：2024/04/29 20:01

11.2.0.4数据库参数文件中如果不写明compatible参数，则默认为11.2.0.0.0，主要是手动创建pfile才会发生，正常创建的数据库基本不需要考虑这种问题

RMAN> startup force mount

Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 02/08/2017 07:22:08
ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0
ORA-00202: control file: '/oradata/ORACLE/controlfile/o1_mf_d9nof2hf_.ctl'

RMAN> sql "alter system set compatible=''11.2.0.4.0'' scope=spfile";

sql statement: alter system set compatible=''11.2.0.4.0'' scope=spfile

RMAN> startup force mount

Oracle instance started
database mounted

Total System Global Area 217157632 bytes

Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes

RMAN>

0 0