Hi gurus,

I'm facing this problem where I'm trying to backup using BAckup tool
in Oracle EM and it says file already exists. Can you please look at
the RMAN job Output list below and lwt mw know what I'm doing wrong.
If I do not specify my own backup file format but leave Orcale default
foramt %u%s%t something like that teh back creates two files and it
runs ok. But the problem occurs only when in specify channel format
something like 'D:\backup\july9.bak'

Thanks
Rukmini
Rmadduluri (AT) stantec (DOT) com


Recovery Manager: Release 9.2.0.3.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: IMSPROD (DBID=2330130086)
using target database controlfile instead of recovery catalog

RMAN>
RMAN> run {
2> allocate channel Channel1 type disk format
'D:\Backup\ims\July1.bak';
3> backup
4> ( database include current controlfile );
5>
6> }
allocated channel: Channel1
channel Channel1: sid=9 devtype=DISK

Starting backup at JUL 03 2003 18:38:28
channel Channel1: starting full datafile backupset
channel Channel1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00095
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_CLUS TER_HUGE_TABLE_TS01.DBF
input datafile fno=00094
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_CLUS TER_HUGE_INDEX_TS01.DBF
input datafile fno=00091
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_HUGE _TABLE_TS01.DBF
input datafile fno=00090
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_HUGE _TABLE_TS01.DBF
input datafile fno=00087
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_XLAR GE_TABLE_TS01.DBF
input datafile fno=00075
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_LARG E_INDEX_TS01.DBF
input datafile fno=00001
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SYSTEM01 .DBF
input datafile fno=00085
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_XLAR GE_INDEX_TS01.DBF
input datafile fno=00100
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_DATA _SHEET_TABLE_TS01.DBF
input datafile fno=00072
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_MEDI UM_TABLE_TS01.DBF
input datafile fno=00082
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS3_LAR GE_TABLE_TS01.DBF
input datafile fno=00103
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS9_MED IUM_TABLE_TS01.DBF
input datafile fno=00049
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_MEDI UM_INDEX_TS01.DBF
input datafile fno=00061
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_MEDI UM_TABLE_TS01.DBF
input datafile fno=00047
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_MEDI UM_INDEX_TS01.DBF
input datafile fno=00096
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\USER_DAT A_TS01.DBF
input datafile fno=00106
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_MONI TOR_TABLE_TS01.DBF
input datafile fno=00084
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_LARG E_TABLE_TS01.DBF
input datafile fno=00071
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_MEDI UM_TABLE_TS01.DBF
input datafile fno=00105
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_PG_B INDER_INDEX_TS01.DBF
input datafile fno=00098
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_VWS_ HUGE_TABLE_TS01.DBF
input datafile fno=00023
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_SMAL L_INDEX_TS01.DBF
input datafile fno=00067
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS5_MED IUM_TABLE_TS01.DBF
input datafile fno=00056
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_MEDI UM_TABLE_TS01.DBF
input datafile fno=00066
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS4_MED IUM_TABLE_TS01.DBF
input datafile fno=00048
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\PK_MEDIU M_INDEX_TS01.DBF
input datafile fno=00063
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS1_MED IUM_TABLE_TS01.DBF
input datafile fno=00107
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_MONI TOR_INDEX_TS01.DBF
input datafile fno=00097
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_XLAR GE_TABLE_OFFLINE_TS01.DBF
input datafile fno=00065
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS3_MED IUM_TABLE_TS01.DBF
input datafile fno=00046
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_MEDI UM_INDEX_TS01.DBF
input datafile fno=00011
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_SMAL L_INDEX_TS01.DBF
input datafile fno=00043
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\IMS_MEDI UM_INDEX_TS01.DBF
input datafile fno=00006
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_SMAL L_INDEX_TS01.DBF
input datafile fno=00010
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\RHB_SMAL L_INDEX_TS01.DBF
input datafile fno=00042
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_SMAL L_TABLE_TS01.DBF
input datafile fno=00078
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_LARG E_TABLE_TS01.DBF
input datafile fno=00007
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\INV_SMAL L_INDEX_TS01.DBF
input datafile fno=00022
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_SMAL L_INDEX_TS01.DBF
input datafile fno=00035
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS4_SMA LL_TABLE_TS01.DBF
input datafile fno=00039
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS8_SMA LL_TABLE_TS01.DBF
input datafile fno=00070
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS8_MED IUM_TABLE_TS01.DBF
input datafile fno=00018
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS6_SMA LL_INDEX_TS01.DBF
input datafile fno=00041
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_SMAL L_TABLE_TS01.DBF
input datafile fno=00013
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS1_SMA LL_INDEX_TS01.DBF
input datafile fno=00019
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS7_SMA LL_INDEX_TS01.DBF
input datafile fno=00034
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS2_SMA LL_TABLE_TS01.DBF
input datafile fno=00012
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS_SMAL L_INDEX_TS01.DBF
input datafile fno=00026
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_SMAL L_TABLE_TS01.DBF
input datafile fno=00028
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MNT_SMAL L_TABLE_TS01.DBF
input datafile fno=00040
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS9_SMA LL_TABLE_TS01.DBF
input datafile fno=00021
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS9_SMA LL_INDEX_TS01.DBF
input datafile fno=00036
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS5_SMA LL_TABLE_TS01.DBF
channel Channel1: starting piece 1 at JUL 03 2003 18:38:33
channel Channel1: finished piece 1 at JUL 03 2003 18:40:48
piece handle=D:\BACKUP\IMS\JULY1.BAK comment=NONE
channel Channel1: backup set complete, elapsed time: 00:02:16
channel Channel1: starting full datafile backupset
channel Channel1: specifying datafile(s) in backupset
input datafile fno=00002
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\UNDO01.D BF
input datafile fno=00092
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\PK_HUGE_ INDEX_TS01.DBF
input datafile fno=00093
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_HUGE _TABLE_TS01.DBF
input datafile fno=00089
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_HUGE _INDEX_TS01.DBF
input datafile fno=00080
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_LARG E_TABLE_TS01.DBF
input datafile fno=00074
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_LARG E_INDEX_TS01.DBF
input datafile fno=00073
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_LARG E_INDEX_TS01.DBF
input datafile fno=00081
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_LARG E_TABLE_TS01.DBF
input datafile fno=00088
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_XLAR GE_TABLE_TS01.DBF
input datafile fno=00086
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_XLAR GE_INDEX_TS01.DBF
input datafile fno=00102
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS9_MED IUM_INDEX_TS01.DBF
input datafile fno=00077
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_LARG E_TABLE_TS01.DBF
input datafile fno=00083
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_LARG E_TABLE_TS01.DBF
input datafile fno=00101
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_DATA _SHEET_INDEX_TS01.DBF
input datafile fno=00059
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_MEDI UM_TABLE_TS01.DBF
input datafile fno=00076
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS3_LAR GE_INDEX_TS01.DBF
input datafile fno=00057
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\INV_MEDI UM_TABLE_TS01.DBF
input datafile fno=00051
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_MEDI UM_INDEX_TS01.DBF
input datafile fno=00050
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_MEDI UM_INDEX_TS01.DBF
input datafile fno=00079
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_LARG E_TABLE_TS01.DBF
input datafile fno=00104
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_PG_B INDER_TS01.DBF
input datafile fno=00052
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\IMS_MEDI UM_TABLE_TS01.DBF
input datafile fno=00099
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_OWS_ HUGE_TABLE_OFFLINE_TS01.DBF
input datafile fno=00060
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\RHB_MEDI UM_TABLE_TS01.DBF
input datafile fno=00054
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_MEDI UM_TABLE_TS01.DBF
input datafile fno=00068
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS6_MED IUM_TABLE_TS01.DBF
input datafile fno=00053
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_MEDI UM_TABLE_TS01.DBF
input datafile fno=00045
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_MEDI UM_INDEX_TS01.DBF
input datafile fno=00055
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_MEDI UM_TABLE_OFFLINE_TS01.DBF
input datafile fno=00064
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS2_MED IUM_TABLE_TS01.DBF
input datafile fno=00058
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MNT_MEDI UM_TABLE_TS01.DBF
input datafile fno=00031
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_SMAL L_TABLE_TS01.DBF
input datafile fno=00030
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\RHB_SMAL L_TABLE_TS01.DBF
input datafile fno=00044
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_MEDI UM_INDEX_TS01.DBF
input datafile fno=00009
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_SMAL L_INDEX_TS01.DBF
input datafile fno=00029
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_SMAL L_TABLE_TS01.DBF
input datafile fno=00062
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS_MEDI UM_TABLE_TS01.DBF
input datafile fno=00003
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\IMS_SMAL L_INDEX_TS01.DBF
input datafile fno=00008
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MNT_SMAL L_INDEX_TS01.DBF
input datafile fno=00032
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS_SMAL L_TABLE_TS01.DBF
input datafile fno=00038
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS7_SMA LL_TABLE_TS01.DBF
input datafile fno=00069
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS7_MED IUM_TABLE_TS01.DBF
input datafile fno=00014
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS2_SMA LL_INDEX_TS01.DBF
input datafile fno=00016
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS4_SMA LL_INDEX_TS01.DBF
input datafile fno=00024
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\IMS_SMAL L_TABLE_TS01.DBF
input datafile fno=00005
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DE_SMALL _INDEX_TS01.DBF
input datafile fno=00017
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS5_SMA LL_INDEX_TS01.DBF
input datafile fno=00020
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS8_SMA LL_INDEX_TS01.DBF
input datafile fno=00037
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS6_SMA LL_TABLE_TS01.DBF
input datafile fno=00025
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DE_SMALL _TABLE_TS01.DBF
input datafile fno=00033
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS1_SMA LL_TABLE_TS01.DBF
input datafile fno=00015
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS3_SMA LL_INDEX_TS01.DBF
input datafile fno=00004
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_SMAL L_INDEX_TS01.DBF
input datafile fno=00027
name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\INV_SMAL L_TABLE_TS01.DBF
channel Channel1: starting piece 1 at JUL 03 2003 18:40:50
released channel: Channel1
RMAN-00571: ================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571: ================================================== =========
RMAN-03009: failure of backup command on Channel1 channel at
07/03/2003 18:40:51
ORA-19504: failed to create file "D:\Backup\ims\July1.bak"
ORA-27038: skgfrcre: file exists
OSD-04010: <create> option specified, file already exists

RMAN>
RMAN> **end-of-file**

RMAN>

Recovery Manager complete.

child process exited abnormally

RMAN cannot backup to a file that already exists. You'll either have to
remove this file before you start the RMAN backup, or you'll have to
make sure that the file name does not match one that exists. This is why
RMAN has included the %u directive, to give unique file names.

HTH,
Brian

Rukmini Madduluri wrote:
--
================================================== =================

Brian Peasland
dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

See comment inline

Rukmini Madduluri <rmadduluri (AT) stantec (DOT) com> schreef in berichtnieuws
a4d18386.0307100602.1392eeb4 (AT) po...OT) google.com...
So you DO NOT use Oracle default format.
You set a format when you allocate a channel., and you do it wrong, see
below.
Set something like format July9_%s_%p.bak or use %U if you like. I don't use
OEM for RMAN backups but I can't imagine it is not possible to set a format
mask there.
Tip: you make or generate a new rman script every day, because you include
the day in the mask. Add a tag too then to make live easy.

Note that it does NOT include any mask to make it a unique file within this
rman backup run.

You finished your first backup piece in 2 minutes. Are your disks so fast or
are these files (a lot of files by the way) so small? Other files go in a
new backup set. It seems you have some persistent settings that makes rman
to decide a new backup set must start here.

F
But there is no unique making mask in the format. The second backup piece
gets the same name in your setup.
You are lucky RMAN refuses to overwrite a backup piece.