salam alekom

i need to do a back up for my database (oracle 10g) in a windows XP platform
i need to have the backup to be located on a network drive
this is the RMAN command i did:
run {
crosscheck backup;
crosscheck archivelog all;
allocate channel t1 type disk;
allocate channel c1 type disk;
BACKUP INCREMENTAL LEVEL 1 DATABASE
format 'Z:\meera\RMAN\%d_%s_%p.bkp' tag=fullbkp
PLUS ARCHIVELOG
format 'Z:\meera\RMAN\ARC_%d_%s_%p.bkp' tag=arcbkp;
release channel t1;
release channel c1;
crosscheck backup;
crosscheck archivelog all;
DELETE NOPROMPT OBSOLETE;
}
i get the follwing ERRORS:
MAN-03009: failure of backup command on t1 channel at 10/30/2008 09:25:44
ORA-19504: failed to create file "Z:\MALKUWARI\RMAN\ARC_QF_8_1.BKP"
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.
channel t1 disabled, job failed on it will be run on another channel
MAN-03009: failure of backup command on c1 channel at 10/30/2008 09:25:44
ORA-19504: failed to create file "Z:\MALKUWARI\RMAN\ARC_QF_9_1.BKP"
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.
channel c1 disabled, job failed on it will be run on another channel
released channel: t1
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 10/30/2008 09:25:44
PLEASE any Solution for this Issue
Best regards,,,,
Meera

الاخت الكريمة


انا لم اعمل على هذه التقنية من قبل ولكنني قرأت مقالا للأخ الكبير dr.click

http://www.araboug.org/ib/index.php?showto...591&hl=rman

أتمنى ان يكون هو المطلوب

بالتوفيق

شكرا لك اخى العزيز rose_4_pretty

Dear Sister

unfortunately RMAN doesnt support Mounted drives but the actual path of shared file
i need you to follow this action plan and post me your results

Action Plan 
1 - Activate GUEST account on the remote machine
2 - make sure the shared folder is accessible as read/write priviliage to your domain user 
3 - restart the backup operation with format like this 
RMAN> backup incremental level 1 skip inaccessible tag saturday_Diff_Backup format '\\1.1.1.1\bkp\DIFF_PROD_Level1_%D_%M_%Y_%U' database;
4 - check your shared folder for backup data

but if u scheduled backup patches to run in aspecific time u must make sure of the availabilty of this folder or the backup operation fails

hope i could help
regards
Eng.Ahmed Hamdy

hello,,

Thank you every one for reply

I have read the metalink Note#:145843.1[/u],1,1,1,helvetica"]145843.1 ((How to Configure RMAN to Write to Shared Drives on Windows NT/2000)) and follow all the steps, it's really help me
and the backup work

The SYSTEM account should not be granted access to the shared drive, therefore the Oracle services for the TARGET DB need to be reconfigured to
logon using an Administrator account


Thans again

تم تعديل 6 نوفمبر 200817 سنة بواسطة dana_rose

I have read the metalink Note#:145843.1

selection from the metalink doc

As Windows 2003 has a changed access behavior compared to Windows 2000,
the solution is a little restrict :

Don't use local drive letters for mapping network shares.
Workaround is to use UNC locations directly, e.g. backup to \\B\share
Since this is in fact an absolute location this is always the same for any
node in the network.
So whether accessed from node A or node B, \\B\share is always the shared
location on B.

you will still need to disable mapping letters (Z) and write the location directly which was the real meaning of the error ..as if oracle server cant reach or connect to the remote machine ..it will result another error differs from O/S-Error: (OS 3) The system cannot find the path specified. ,
that was just clarification
Regards