首页 » ORACLE 9i-23c » 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)评论关闭。

  1. Ariana Jurist | #1
    2011-12-21 at 13:46

    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.

  2. Susannah | #2
    2011-06-17 at 22:27

    That’s not just logic. That’s really sensblie.

    • Candie | #3
      2011-09-03 at 06:35

      Thanks for the insight. It brgins light into the dark!