暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version…

张维照 2019-05-31
783

问题描述

今天从其它机器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是这个参数 主备参数要一致.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论