Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle BAckup Failed. Urgent Please

Oracle BAckup Failed. Urgent Please

From: Rukmini Madduluri <rmadduluri_at_stantec.com>
Date: 10 Jul 2003 07:02:29 -0700
Message-ID: <a4d18386.0307100602.1392eeb4@posting.google.com> 





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
Received on Thu Jul 10 2003 - 09:02:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US