Welcome 微信登录

首页 / 数据库 / MySQL / Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明

一．问题说明
操作系统： RedHat 5.8数据库： 11.2.0.32节点RAC.使用RMAN 备份的时候，报如下错误：ORA-00245: control file backup failed;target is likely on a local file system这个问题只存在Oracle 11gR2以后的RAC 环境。二．ORA-245 触发条件
在以下的5种环境下，会出现ORA-00245的错误。2.1 RAC 环境下，自动备份备份控制文件，会因为ORA-245的错误而失败Autobackup of controlfile in RMAN isfailing with error:
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3009: failure of Control File and SPFILE Autobackup command on
ORA_DISK_1 channel at 10/27/2010 12:13:31
ORA-245: control file backup operation failed2.2 RAC 环境下，备份控制文件到非共享的本地路径，也会失败
SQL> ALTER DATABASE BACKUP CONTROLFILETO "/u01/backup/control.bk" REUSE
*
ERROR at line 1:
ORA-245: control file backup operation failed2.3 在RAC 环境下，创建standby controlfile 到非共享的本地路径也会失败
SQL> alter database create standby controlfileas "/home/oracle/renostdbycntrl.ctl";alter database create standby controlfileas
"/home/oracle/renostdbycntrl.ctl"
*
ERROR at line 1:
ORA-245: control file backup operation failed2.4 在RAC 环境下，copy 当前的控制文件到本地路径
channel ch1: starting datafile copy
copying current control file
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3009: failure of backup command on 10/07/2011 11:36:42 channel at ch1
ORA-245: control file backup operation failed2.5 RAC 环境下，controlfile 快照备份到非共享位置，RMAN 备份也会失败
RMAN-00571:========================================================
RMAN-00569: ============ ERROR MESSAGE STACK FOLLOWS =============
RMAN-00571: =========================================================
RMAN-03009: failure of resync command on default channel at 03/13/2012 10:19:41
ORA-00245: control file backup operation failed
  • 1
  • 2
  • 下一页
详解MySQL配置的优化RMAN-01009: syntax error: found “dot” 解决方法相关资讯      Oracle 11g RAC 
  • Oracle 11g RAC 启动时无法识别ASM  （今 15:36）
  • Oracle 11g RAC跨实例控制并行  （04月22日）
  • Oracle 11g RAC 二节点root.sh执行  （12/27/2015 18:47:25）
  • Oracle 11g RAC 应用补丁简明版  （09月23日）
  • Oracle 11g RAC安装注意事项杂记  （12/27/2015 18:49:31）
  • Oracle 11g RAC自动打GI PSU补丁（  （12/27/2015 18:43:50）
本文评论 查看全部评论 （0）
表情： 姓名： 字数