ORA-00245: control file backup failed; target is likely on a local file system解决

报错

11.2.0.4的rac，使用rman备份，在备份控制文件时报错

错误原因

From 11gR2 onwards, the controlfile backup happens without holding the controlfile enqueue. For non-RAC database, this doesn't change anything. But for RAC database, due to the changes made to the controlfile backup mechanism in 11gR2,any instance in the cluster may write to the snapshot controlfile. Due to this snapshot controlfile need to be visible to all instances.

--从Oracle11gR2 开始，在备份控制文件时，不在需要锁住controlfile enqueue。对于非RAC 的数据库， 没有任何改变，但对于RAC 数据库，因为控制文件备份机制的改变，集群中的任何instance 可以需要写入到快照控制文件，因此snapshot controlfile需要对所有实例是可见的。

In RAC environment any form of controlfile backup may fail with ORA-0245 if the location of the Snapshot Controlfile is not a shared location.

--在RAC 环境下，如果snapshot controlfile 不在共享的位置，控制文件任何形式的都可能报ORA-245的错误。

The backup ofthe controlfile actualy makes a backup of the SNAPSHOT controlfile. TheSnapshot controlfile is created when the controlfile is about to be backed up.

--控制文件的备份实际上是生成一个SNAPSHOT controlfile，在备份时生成快照文件。

The Snapshot controlfile is a read-consistent copy of the controlfile.

--快照控制文件是控制文件的一个read-consistent copy。

The snapshot controlfile MUST be accessible by all nodes of a RAC database, if the snapshot controlfile does not reside on a shared device error will be raised at the timeof RMAN backup while taking snapshot of controlfile.

--快照控制文件必须能被所有节点访问，如果快照控制不是存放在共享设备上，那么在RMAN 进行控制文件的快照备份时就会报错。

This applies to backingup controlfile using sqlplus / having autobackup of controlfile configured on non-shared location.

ORA-245 error message description

00245, 00000, "control file backup operation failed"
Cause: Failed to create a control file backup because some process signaled an error during backup creation.
Action: Check alert files for further information. This usually happens because some process could not access the backup file during backup creation. Any process of any instance that starts a read/write control file transaction must have an access to the backup control file during backup creation.

分析

在以下的5种环境下，会出现ORA-00245的错误。

RAC 环境下，自动备份备份控制文件，会因为ORA-245的错误而失败

RAC 环境下，备份控制文件到非共享的本地路径，也会失败

在RAC 环境下，创建standby controlfile 到非共享的本地路径也会失败

在RAC 环境下，copy 当前的控制文件到本地路径

RAC 环境下，controlfile 快照备份到非共享位置，RMAN 备份也会失败

解决

1、检查快照控制文件位置

2、配置snapshot controlfile 到共享位置

如果使用了ASM，就指定到对应的ASM disk group：

参考

https://blog.csdn.net/imliuqun123/article/details/76619063

In RAC environment from 11.2 onwards BackupOr Snapshot controlfile needs to be in shared location[ID 1472171.1]

RMAN backup fails with Ora-00245 AndRman-08132 [ID 1365484.1]

RMAN BACKUP TO LOCAL DEVICE WITH SNAPSHOTON SHARED FAILS ORA-00245 [ID 1516654.1]