Home » RDBMS Server » Backup & Recovery » O/S-Error: (OS 3) The system cannot find the path specified. (windows xp 64bit, oracle 10.2)
O/S-Error: (OS 3) The system cannot find the path specified. [message #517088] Fri, 22 July 2011 07:12 Go to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
when i am running this syntax in rman i got this error so can you suggust me a correct syntax


Quote:

RMAN> run{
2> allocate channel c1 device type disk maxpiecesize 5m;
3> set backup copies = 2;
4> backup datafile 1 format 'E:\rol\%u_%c','E:\rol\%u_%c';
5> }

allocated channel: c1
channel c1: sid=142 devtype=DISK

executing command: SET BACKUP COPIES

Starting backup at 22-JUL-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF

channel c1: starting piece 1 at 22-JUL-11
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 07/22/2011 17:37:27
ORA-19504: failed to create file "E:\ROL\0DMI3G2M_1"
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.
Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #517093 is a reply to message #517088] Fri, 22 July 2011 07:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is not clear in "The system cannot find the path specified"?

Regards
Michel
Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #517271 is a reply to message #517093] Mon, 25 July 2011 02:49 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
but michel i already given a correct path ok where i have to change in my this sytax

i already given path 'E:\rol\%u_%c' this E:\rol\%u_%c its not correct so which is correct
Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #517275 is a reply to message #517271] Mon, 25 July 2011 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can know only what you post and what you post is that OS cannot find 'E:\ROL' directory.

By the way, you gave "format 'E:\rol\%u_%c','E:\rol\%u_%c'" so twice the same name, I doubt RMAN can write twice into the same file at the same time (assuming it uses the same unique name for both).
Try to first use only one value.


Regards
Michel
Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #517642 is a reply to message #517275] Wed, 27 July 2011 00:57 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
michel i did this i change this directory name but still same error

C:\Documents and Settings\Administrator>rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jul 27 11:22:06 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1284698519)

RMAN> run{
2> allocate channel c1 device type disk maxpiecesize 5m;
3> set backup copies = 2;
4> backup datafile 1 format 'E:\rol\%u_%c','E:\ral\%u_%c';
5> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=143 devtype=DISK

executing command: SET BACKUP COPIES

Starting backup at 27-JUL-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF

channel c1: starting piece 1 at 27-JUL-11
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 07/27/2011 11:24:29
ORA-19504: failed to create file "E:\ROL\0NMIG03B_1"
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.

RMAN>
Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #517643 is a reply to message #517642] Wed, 27 July 2011 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dir E:\
dir E:\ROL

Is E: a local drive or a network one?

Regards
Michel

[Updated on: Wed, 27 July 2011 01:01]

Report message to a moderator

Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #517648 is a reply to message #517643] Wed, 27 July 2011 01:25 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
yes its a local drive
Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #517651 is a reply to message #517648] Wed, 27 July 2011 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the result of the DIR commands?

Regards
Michel
Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #608606 is a reply to message #517643] Fri, 21 February 2014 05:56 Go to previous messageGo to next message
mr.trilok
Messages: 1
Registered: February 2014
Location: Bangalore
Junior Member
Seems, He has not created the directory structure prior to run above RMAN backup command.
Re: O/S-Error: (OS 3) The system cannot find the path specified. [message #608645 is a reply to message #608606] Fri, 21 February 2014 10:10 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Sure but we will never know as OP refused to post the obvious result of DIR commands.

Previous Topic: Problem with backup
Next Topic: restore database
Goto Forum:
  


Current Time: Fri Apr 19 18:52:07 CDT 2024