Control File Backup Creation Failed with ORA-245
Last updated on DECEMBER 06, 2017
Applies to:Oracle Database - Enterprise Edition
Information in this document applies to any platform.
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
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
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