Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

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

Posted by Mir Sayeed Hassan on February 13th, 2021

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

Got the error while taking the backup of the controlfile.

Connect to RMAN & Initiate the backup of controlfile

[oracle@racdb1 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Feb 13 09:54:49 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: racdb (DBID=3955984012)

RMAN> backup current controlfile;

Starting backup at 13-FEB-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4716 instance=racdb1 device type=DISK
channel ORA_DISK_1: starting 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/13/2021 09:54:58
ORA-00245: control file backup failed; target is likely on a local file system

View the Configuration of the snapshot controlfile

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name racdb are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/controlfile_autobkp/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 20 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ORADATA/racdb/test/snapcf_racdb.f';

This issue is occur due to the incorrect location assign for the snapshot controlfile backup.

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ORADATA/racdbsnapcf_racdb.f';

old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ORADATA/racdb/test/snapcf_racdb.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ORADATA/racdbsnapcf_racdb.f';
new RMAN configuration parameters are successfully stored

Verify

RMAN> show snapshot controlfile name;

RMAN configuration parameters for database with db_unique_name RACDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ORADATA/racdbsnapcf_racdb.f';

Take the backup of the current controlfile

RMAN> backup current controlfile;

Starting backup at 13-FEB-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4716 instance=racdb1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 13-FEB-21
channel ORA_DISK_1: finished piece 1 at 13-FEB-21
piece handle=+ORADATA/racdb/backupset/2021_02_13/ncnnf0_tag20210213t100235_0.1984.1064397757 tag=TAG20210213T100235 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-FEB-21

Starting Control File and SPFILE Autobackup at 13-FEB-21
piece handle=/controlfile_autobkp/c-3955984012-20210213-00 comment=NONE
Finished Control File and SPFILE Autobackup at 13-FEB-21

Therefore its resolved after assign the correct location to the configuration of controlfile

=====Hence resolved, tested & verified=====