ITPub博客

首页 > 数据库 > Oracle > ORA-00245: control file backup failed

ORA-00245: control file backup failed

原创 Oracle 作者:小宇12333 时间:2017-08-24 16:36:50 0 删除 编辑
一套12c的RAC在二节点rman备份控制文件时报错。

1.现象
1节点日志中出现如下错误:
ORA-27037: unable to obtain file status

2节点日志中出现如下错误:
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

2.问题分析
[oracle@db1 ~]$ oerr ora 245
00245, 00000, "control file backup failed; in Oracle RAC, target might not be on shared storage"
// *Cause:  Failed to create a control file backup because some process
//          signaled an error during backup creation. This is likely caused
//          by the backup target (i.e., RMAN snapshot controlfile) being on
//          a local file system so it could not be accessed by other instances.
//          It can also be caused by other I/O errors to the backup target.
//          Any process of any instance that starts a read/write control file
//          transaction must have access to the backup control file during
//          backup creation.
// *Action: Check whether RMAN snapshot controlfile is on shared storage.
//          Also, check alert files of all instances for further information.
==>上述提到了snapshot controlfile是在本地文件系统上,其他实例无法获取。要求检查rman配置中 snapshot controlfile是否放在共享存储上。

3.解决方法
1,2节点通过进入rman,通过show all;命令发现2个节
snapshot control file都配置在了本地文件系统上。
执行以下命令将snapshot control file配置到共享存储上:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA_CDB/cdb/snapcf_cdb.f’;

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

请登录后发表评论 登录
全部评论

注册时间:2013-07-22

  • 博文量
    31
  • 访问量
    95060