Re: Oracle BAckup Failed. Urgent Please

"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message news:<3f0d9225$0$49103$e4fe514c_at_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

Thanks,

I do understand now about what is happening. Can you tell me where to look for the RMAN persistent settings that make it to start a new back up after the first one. When I backup another database I do not face with thsi problem Received on Wed Jul 23 2003 - 12:38:46 CDT