今天从其它机器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是这个参数 主备参数要一致.
It’s not easy finding information on this topic that is well-written, easy to read and easy to grasp. That’s why I felt moved to put a comment here to let you know this is great.
Thats not just logic. Thats really sensblie.
Thanks for the insight. It brgins light into the dark!