ORA-01580: error creating control backup file e/control.bakORA-27040: file create error, unable to create fileOSD-04002: unable to open fileO/S-Error: (OS 3) The system cannot find the path specified.

Cause:

ORA-01580 error occur if the file or directory you provide on the command doesnot exist on windows or linux server path

SQL> alter database backup controlfile to 'e/control.bak';
alter database backup controlfile to 'e/control.bak'
*
ERROR at line 1:
ORA-01580: error creating control backup file e/control.bak
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:

In windows , if you specify the drive path,specify with proper drive location which will be confusing lot of time.

SQL> alter database backup controlfile to 'e:/control.bak';

Database altered.

Leave a Reply