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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s