ORA-00245

APPLIES TO

Operating System - Oracle Linux Server 7.9
Oracle Database - Enterprise Edition - version 11.2.0.4.0
Oracle Grid Infrastructure - version 11.2.0.4.0

SYMPTOMS

Starting backup at 15-FEB-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/15/2024 18:09:16
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/15/2024 18:09:16
ORA-00245: control file backup failed; target is likely on a local file system

CAUSE

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.

SOLUTION

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/coco/snapcf_coco.f';