ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 备份导致ORA-245错误

备份导致ORA-245错误

原创 Linux操作系统 作者:yangtingkun 时间:2012-04-24 23:52:13 0 删除 编辑

客户的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.2Oracle改变了控制文件镜像的访问方式。11.2之前,RAC的各个节点上的ORACLE_HOME/dbs目录分别保存镜像。而11.2之后,Oracle要求这个镜像控制文件在两个节点上都可以访问到,因此可以通过设置控制文件镜像到共享磁盘的方式解决这个问题,语法类似:

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+DATA/orcl/snapcf_orcl.f’;

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-722464/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10368988