Re: Oracle BAckup Failed. Urgent Please

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:
>
> 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.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_CLUSTER_HUGE_TABLE_TS01.DBF
> input datafile fno=00094
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_CLUSTER_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_XLARGE_TABLE_TS01.DBF
> input datafile fno=00075
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_LARGE_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_XLARGE_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_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00082
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS3_LARGE_TABLE_TS01.DBF
> input datafile fno=00103
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS9_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00049
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00061
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00047
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00096
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\USER_DATA_TS01.DBF
> input datafile fno=00106
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_MONITOR_TABLE_TS01.DBF
> input datafile fno=00084
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_LARGE_TABLE_TS01.DBF
> input datafile fno=00071
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00105
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_PG_BINDER_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_SMALL_INDEX_TS01.DBF
> input datafile fno=00067
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS5_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00056
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00066
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS4_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00048
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\PK_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00063
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS1_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00107
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_MONITOR_INDEX_TS01.DBF
> input datafile fno=00097
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_XLARGE_TABLE_OFFLINE_TS01.DBF
> input datafile fno=00065
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS3_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00046
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00011
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_SMALL_INDEX_TS01.DBF
> input datafile fno=00043
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\IMS_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00006
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_SMALL_INDEX_TS01.DBF
> input datafile fno=00010
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\RHB_SMALL_INDEX_TS01.DBF
> input datafile fno=00042
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_SMALL_TABLE_TS01.DBF
> input datafile fno=00078
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_LARGE_TABLE_TS01.DBF
> input datafile fno=00007
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\INV_SMALL_INDEX_TS01.DBF
> input datafile fno=00022
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_SMALL_INDEX_TS01.DBF
> input datafile fno=00035
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS4_SMALL_TABLE_TS01.DBF
> input datafile fno=00039
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS8_SMALL_TABLE_TS01.DBF
> input datafile fno=00070
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS8_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00018
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS6_SMALL_INDEX_TS01.DBF
> input datafile fno=00041
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_SMALL_TABLE_TS01.DBF
> input datafile fno=00013
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS1_SMALL_INDEX_TS01.DBF
> input datafile fno=00019
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS7_SMALL_INDEX_TS01.DBF
> input datafile fno=00034
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS2_SMALL_TABLE_TS01.DBF
> input datafile fno=00012
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS_SMALL_INDEX_TS01.DBF
> input datafile fno=00026
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_SMALL_TABLE_TS01.DBF
> input datafile fno=00028
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MNT_SMALL_TABLE_TS01.DBF
> input datafile fno=00040
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS9_SMALL_TABLE_TS01.DBF
> input datafile fno=00021
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS9_SMALL_INDEX_TS01.DBF
> input datafile fno=00036
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS5_SMALL_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.DBF
> 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_LARGE_TABLE_TS01.DBF
> input datafile fno=00074
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_LARGE_INDEX_TS01.DBF
> input datafile fno=00073
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_LARGE_INDEX_TS01.DBF
> input datafile fno=00081
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_LARGE_TABLE_TS01.DBF
> input datafile fno=00088
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_XLARGE_TABLE_TS01.DBF
> input datafile fno=00086
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_XLARGE_INDEX_TS01.DBF
> input datafile fno=00102
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS9_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00077
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_LARGE_TABLE_TS01.DBF
> input datafile fno=00083
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_LARGE_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_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00076
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS3_LARGE_INDEX_TS01.DBF
> input datafile fno=00057
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\INV_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00051
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00050
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TRF_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00079
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\DLR_LARGE_TABLE_TS01.DBF
> input datafile fno=00104
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\TST_PG_BINDER_TS01.DBF
> input datafile fno=00052
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\IMS_MEDIUM_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_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00054
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00068
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS6_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00053
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00045
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00055
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_MEDIUM_TABLE_OFFLINE_TS01.DBF
> input datafile fno=00064
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS2_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00058
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MNT_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00031
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SMP_SMALL_TABLE_TS01.DBF
> input datafile fno=00030
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\RHB_SMALL_TABLE_TS01.DBF
> input datafile fno=00044
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\AWS_MEDIUM_INDEX_TS01.DBF
> input datafile fno=00009
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_SMALL_INDEX_TS01.DBF
> input datafile fno=00029
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MON_SMALL_TABLE_TS01.DBF
> input datafile fno=00062
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00003
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\IMS_SMALL_INDEX_TS01.DBF
> input datafile fno=00008
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\MNT_SMALL_INDEX_TS01.DBF
> input datafile fno=00032
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS_SMALL_TABLE_TS01.DBF
> input datafile fno=00038
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS7_SMALL_TABLE_TS01.DBF
> input datafile fno=00069
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS7_MEDIUM_TABLE_TS01.DBF
> input datafile fno=00014
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS2_SMALL_INDEX_TS01.DBF
> input datafile fno=00016
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS4_SMALL_INDEX_TS01.DBF
> input datafile fno=00024
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\IMS_SMALL_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_SMALL_INDEX_TS01.DBF
> input datafile fno=00020
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS8_SMALL_INDEX_TS01.DBF
> input datafile fno=00037
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS6_SMALL_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_SMALL_TABLE_TS01.DBF
> input datafile fno=00015
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\SPS3_SMALL_INDEX_TS01.DBF
> input datafile fno=00004
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\CLM_SMALL_INDEX_TS01.DBF
> input datafile fno=00027
> name=D:\LTPP_DATABASE\IMSPROD\TABLESPACES\INV_SMALL_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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.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"