oracle的oraah,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是这个参数 主备参数要一致.

打赏

微信扫一扫，打赏作者吧～