今天从其它机器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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
【纯干货】Oracle 19C RU 19.27 发布,如何快速升级和安装?
Lucifer三思而后行
686次阅读
2025-04-18 14:18:38
Oracle RAC 一键安装翻车?手把手教你如何排错!
Lucifer三思而后行
635次阅读
2025-04-15 17:24:06
Oracle数据库一键巡检并生成HTML结果,免费脚本速来下载!
陈举超
546次阅读
2025-04-20 10:07:02
【活动】分享你的压箱底干货文档,三篇解锁进阶奖励!
墨天轮编辑部
493次阅读
2025-04-17 17:02:24
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
490次阅读
2025-04-22 00:20:37
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
479次阅读
2025-04-22 00:13:51
一页概览:Oracle GoldenGate
甲骨文云技术
469次阅读
2025-04-30 12:17:56
火焰图--分析复杂SQL执行计划的利器
听见风的声音
418次阅读
2025-04-17 09:30:30
3月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
372次阅读
2025-04-15 14:48:05
OR+DBLINK的关联SQL优化思路
布衣
357次阅读
2025-05-05 19:28:36
热门文章
移除DataGuard Standby配置导致Primary启动失败
2023-08-17 21345浏览
使用dblink产生的”SELECT /*+ FULL(P) +*/ * FROM XXXXX P ” 解析
2023-06-20 20905浏览
Troubleshooting 'ORA-28041: Authentication protocol internal error' change password 12c R2 DB
2020-04-08 13698浏览
浅谈ORACLE免费数据库Oracle Database XE (Express Edition) 版
2018-10-31 7675浏览
High wait event ‘row cache mutex’ in 12cR2、19c
2020-08-14 5606浏览