Control File Backup Creation Failed with ORA-245 (Doc ID 2105570.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Database - Enterprise Edition
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

 

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

  or

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

 

 Alert log in One node would report

Sat Jan 30 06:20:22 2016
ALTER DATABASE BACKUP CONTROLFILE TO '/u01/test/control.bak' REUSE
Errors in file /u01/diag/rdbms/orcl/ORCL/trace/ORCL_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 '/u01/test/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 /u01/diag/rdbms/orcl/ORCL/trace/RDSR6DB1_ckpt_7049.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms