RMAN-03009: failure of Control File and SPFILE autobackup

💡 While running the database error following error occurred:

ERROR:

RMAN-03009: failure of Control File and SPFILE Autobackup command on ch00 channe
l at 08/16/2018 04:53:13
ORA-19504: failed to create file "E:\RMAN\ORA_CFC-2809772908-20180816-00.CTL"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

🚢SOLUTION:

Check auto backup is on for the control file. If yes then check the location in second command is this location exists in Operating system.If not needed then switch off the auto-backup otherwise change the location to the existing one in operating system.

Show all setting and check the following two lines:

RMAN> Show all;

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\rman\ora_cf%F.ctl';

Set the following:

CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\rman\ora_cf%F.ctl';

Related posts

Error: ORA-16765: Redo Apply is running

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB