My Oracle Support Banner

Control File Backup Creation Failed with ORA-245 from sqplus or Rman (Doc ID 2105570.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 This issue is applicable only to Rac database.

 Snapshot controlfile is configured in shared location .

 Controlfile binary backup is taken to local destination using either Rman or sqlplus

 

SQLPLUS

SQL> ALTER DATABASE BACKUP CONTROLFILE TO <local system> reuse

  or

RMAN

RMAN> copy current controlfile to '/<directory>/control_backup.bak';

or

RMAN > backup as copy current controlfile format '/<directory>/ctlfile.bkp';

RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/23/2015 10:20:08
ORA-00245: control file backup failed; target is likely on a local file system


 

 

 Alert log in One node would report

Sat Jan 30 06:20:22 2016
ALTER DATABASE BACKUP CONTROLFILE TO '<directory>/control.bak' REUSE
Errors in file <adr_home>/diag/rdbms/<db_unique_home>/<instance_name>/trace/<instance_name>_ora_17779.trc:
ORA-00245: control file backup failed; target is likely on a local file system
ORA-245 signalled during: ALTER DATABASE BACKUP CONTROLFILE TO '<directory>/control.bak' REUSE...
ALTER DATABASE BACKUP CONTROLFILE TO TRACE

 

 Alert log in other node might report

Control file backup creation failed.
Backup target file size found to be zero.
Errors in file <adr_home>/diag/rdbms/<db_unique_home>/<instance_name>/trace/<instance_name>_ckpt_7049.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
 Applies to:
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.