今天从其它机器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
总结,与一个参数compatible 有关,简单说就是验证数据库兼容性,默认值为它的主版本,做DG是这个参数 主备参数要一致.
环境备份机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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




