Home » RMAN-03009: failure of Control File and SPFILE autobackup

RMAN-03009: failure of Control File and SPFILE autobackup

by tuanlp

💡 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';

You may also like