首页 » ORACLE 9i-23ai » ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version…
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version…
今天从其它机器rman 备份还原到别外一台机器上，restore controlfiel ,DB mount时报ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version 10.2.0.1.0
环境备份机10.2.0.4 还原机10.2.0.4
[oracle@aix dbs]$ ora SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jun 10 16:08:46 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter database mount; alter database mount * ERROR at line 1: ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version 10.2.0.1.0 ORA-00202: control file: '/oracle/oradata/ahjcyl/control01.ctl' SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production SQL> show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 10.2.0.1.0 [oracle@aix dbs]$ oerr ora 201 00201, 00000, "control file version %s incompatible with ORACLE version %s" // *Cause: The control file was created by incompatible software. // *Action: Either restart with a compatible software release or use // CREATE CONTROLFILE to create a new control file that is // compatible with this release. [oracle@aix dbs]$ ls ab_+ASM.dat hc_ggs.dat initahjcyl.ora init.ora lk+ASM lkWENDY orapwqinwen spfileorcl.ora cretest.sql hc_orcl.dat init+ASM.ora initorcl.ora lkGGS orapwggs snapcf_orcl.f spfileorcl.ora.bak hc_ahjcyl.dat hc_qinwen.dat initdw.ora initwendy.ora lkORCL orapworcl spfileahjcyl.ora spfileqinwen.ora hc_+ASM.dat hc_wendy.dat initggs.ora lkAHJCYL lkQINWEN orapworcl.bak spfileggs.ora spfilewendy.ora [oracle@aix dbs]$ rm spfileahjcyl.ora modify pfile *.compatible='10.2.0.1.0' to *.compatible='10.2.0.4.0' [oracle@aix dbs]$ ora SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jun 10 17:07:00 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL> create spfile from pfile; File created. SQL> host [oracle@aix dbs]$ ls ab_+ASM.dat hc_ggs.dat initahjcyl.ora init.ora lk+ASM lkWENDY orapwqinwen spfileorcl.ora cretest.sql hc_orcl.dat init+ASM.ora initorcl.ora lkGGS orapwggs snapcf_orcl.f spfileorcl.ora.bak hc_ahjcyl.dat hc_qinwen.dat initdw.ora initwendy.ora lkORCL orapworcl spfileahjcyl.ora spfileqinwen.ora hc_+ASM.dat hc_wendy.dat initggs.ora lkAHJCYL lkQINWEN orapworcl.bak spfileggs.ora spfilewendy.ora [oracle@aix dbs]$ exit exit SQL> startup mount ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started. Total System Global Area 2097152000 bytes Fixed Size 2085256 bytes Variable Size 1627393656 bytes Database Buffers 452984832 bytes Redo Buffers 14688256 bytes Database mounted. .
总结，与一个参数compatible 有关，简单说就是验证数据库兼容性，默认值为它的主版本，做DG是这个参数 主备参数要一致.
微信扫一扫，打赏作者吧～
目前这篇文章有3条评论(Rss)评论关闭。