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

Basically one day at work, my colleague handed over an issue related to RMAN.

 
Starting backup at 14-FEB-2016 06:02:44
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1444 instance=CXXXEU22 device type=DISK channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/14/2016 06:02:46
ORA-00245: control file backup failed; target is likely on a local file system

RMAN>

So i check the location of snapshot controlfile.

 
RMAN>  show snapshot controlfile name;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name XXXCEU2 are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/optware/oracle/11.2.0.4/db_1/dbs/snapcf_CXXXEU22.f'; # default

RMAN> 

but database is running in 2 node cluster..

 
oracle@xxxycdb22u[XXXCEU22] /home/oracle => srvctl status database -d XXXCEU2
Instance XXXCEU21 is running on node xxxycdb21u
Instance XXXCEU22 is running on node xxxycdb22u
oracle@xxxycdb22u[XXXCEU22] /home/oracle =>

to fix the issue, i change the location of snapshot controlfile and put it inside the ASM.

 
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/XXXCEU2/controlfile/snapcf_XXXCEU2.f';

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/XXXCEU2/controlfile/snapcf_XXXCEU2.f';
new RMAN configuration parameters are successfully stored

RMAN>

issue is fixed.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s