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

 

When backup is taken with Rman, it creates the snapshot of the control file and uses it as backup file.

The name of the directory and file to which this file is created is specified in the Rman configuration. This directory should be accessible from all nodes on RAC systems.

In cases where ASM is used, it is useful to assign a location in the ASM for the parameter rman SNAPSHOT CONTROLFILE NAME.

If the file system is to be used, either the cluster file system must be used or nfs must be defined on a node. This will allow other nodes to access this directory.

I’ve shown below how to specify a directory in ASM.

First, let’s query the current configuration.

 

The parameter SNAPSHOT CONTROLFILE NAME should be changed in a common area as follows.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *