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 -> Re: Oracle BAckup Failed. Urgent Please

Re: Oracle BAckup Failed. Urgent Please

From: Anton Buijs <remove_aammbuijs_at_xs4all.nl>
Date: Thu, 10 Jul 2003 18:20:12 +0200
Message-ID: <3f0d9225$0$49103$e4fe514c@news.xs4all.nl> 





See comment inline



Rukmini Madduluri <rmadduluri_at_stantec.com> schreef in berichtnieuws
a4d18386.0307100602.1392eeb4_at_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

|

|




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.



| 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';


                          ^^^^^^^^  here you set your format mask


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



| 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




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.



| 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.DB
F


| 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

|




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.



| RMAN>


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

|

| RMAN>


|

| Recovery Manager complete.

|

| child process exited abnormally

Received on Thu Jul 10 2003 - 11:20:12 CDT












Original text of this message













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