问题描述
客户的11.2 RAC数据库在备份是出现ORA-245错误。
从告警日志中可以看到错误信息为:
Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18335.trc: ORA-00245: control file backup operation failed
专家解答
详细TRACE信息为:
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18335.trc Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production WITH the Partitioning, REAL Application Clusters, Automatic Storage Management, OLAP, DATA Mining AND REAL Application Testing options ORACLE_HOME = /u01/app/oracle/product/11.2.0 System name: Linux Node name: node-1 Release: 2.6.18-274.el5 Version: #1 SMP Fri Jul 8 17:36:59 EDT 2011 Machine: x86_64 Instance name: orcl1 Redo thread mounted BY this instance: 1 Oracle process NUMBER: 157 Unix process pid: 18335, image: oracle@node-1 (TNS V1-V3) *** 2012-03-30 00:01:45.301 *** SESSION ID:(633.29287) 2012-03-30 00:01:45.301 *** CLIENT ID:() 2012-03-30 00:01:45.301 *** SERVICE NAME:(SYS$USERS) 2012-03-30 00:01:45.301 *** MODULE NAME:(rman@node-1 (TNS V1-V3)) 2012-03-30 00:01:45.301 *** ACTION NAME:(0000012 STARTED114) 2012-03-30 00:01:45.301 ORA-00245: control file backup operation failed
查询MOS发现是Oracle 11.2上Oracle改变了控制文件镜像的访问方式。11.2之前,RAC的各个节点上的ORACLE_HOME/dbs目录分别保存镜像。而11.2之后,Oracle要求这个镜像控制文件在两个节点上都可以访问到,因此可以通过设置控制文件镜像到共享磁盘的方式解决这个问题,语法类似:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+DATA/orcl/snapcf_orcl.f’;
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。