Looks like you have a missing % in your script - even though you show it in the script.
The %U should give a unique string that can be used to identify the file, but you are getting an error that says you are creating a file with a filename that includdes the U. That is wrong and not how %U works.
Your error is saying that Y:\RDBS_U was created, then, when another file was needed, the EXACT SAME FILE was tried to create, and an error is thrown.
Walt
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
From: Yves [mailto:oracledba-ezmlmshield-x90797355.[Email address protected]
Sent: Friday, September 29, 2006 13:17
To: LazyDBA Discussion
Subject: RMAN error - urgent!
I have the following script
RUN {
ALLOCATE CHANNEL d1 device TYPE disk format 'y:\rdbs_%U'; BACKUP incremental level 1 tablespace a,b,c,d,e,f,g,....; -- 40 tablespaces per line ...
10 lines
}
When I execute this script i get the following error
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on d1 channel at 09/29/2006 13:44:23
ORA-19504: failed to create file "Y:\RDBS_U"
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists
Any ideas? This is the first time I try to backup on disk.
Merci / Thanks
Yves Leonard,
Chef de Projet / Project Leader,
DDS / SDD,
RH Coats, 13-I
Téléphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page