Database Software

1 error has occurred

Your session has timed out.

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Wrong format for disk backups

ora-00600May 6 2011 — edited May 9 2011

Hello Team
Im taking rman disk backups in a windows environment to R: disk. The backup seems to work find but in the middle os the execution starts to backups to $ORACLE_HOME/database path (which is on volume E:). Here is the script:
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
allocate channel d5 type disk;
CROSSCHECK BACKUP;
BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT "R:\oracle\Backup\PRM\DBF_PRM_%T_%u.db" database filesperset 8 tag LV0_PRM;
sql "alter system archive log current";
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT "R:\oracle\Backup\PRM\ARC_PRM_%T_%u.arc" DELETE INPUT tag ARC_PRM;
BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT "R:\oracle\Backup\PRM\CTL_PRM_%T_%u.ctl" tag CF_PRM;
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;
release channel d1;
release channel d2;
release channel d3;
release channel d4;
release channel d5;
}

And here is an extract of the log:

Recovery Manager: Release 10.2.0.4.0 - Production on Thu May 5 18:45:00 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: PRM (DBID=835367298)
connected to recovery catalog database

RMAN> run {
2> allocate channel d1 type disk;
3> allocate channel d2 type disk;
4> allocate channel d3 type disk;
5> allocate channel d4 type disk;
6> CROSSCHECK BACKUP;
7> BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT "R:\oracle\Backup\PRM\DBF_PRM_%T_%u.db" database filesperset 8 tag LV0_PRM;
8> sql "alter system archive log current";
9> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT "R:\oracle\Backup\PRM\ARC_PRM_%T_%u.arc" DELETE INPUT tag ARC_PRM;
10> BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT "R:\oracle\Backup\PRM\CTL_PRM_%T_%u.ctl" tag CF_PRM;
11> CROSSCHECK BACKUP;
12> DELETE NOPROMPT OBSOLETE;
13> DELETE NOPROMPT EXPIRED BACKUP;
14> release channel d1;
15> release channel d2;
16> release channel d3;
17> release channel d4;
18> }
19>
20>
21>
allocated channel: d1
channel d1: sid=69 devtype=DISK

allocated channel: d2
channel d2: sid=26 devtype=DISK

allocated channel: d3
channel d3: sid=28 devtype=DISK

allocated channel: d4
channel d4: sid=68 devtype=DISK

crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=R:\ORACLE\BACKUP\PRM\ARC_PRM_20110505_02MBJ9BM.ARC recid=1 stamp=750364028
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=R:\ORACLE\BACKUP\PRM\ARC_PRM_20110505_03MBJ9BM.ARC recid=2 stamp=750364036
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=R:\ORACLE\BACKUP\PRM\ARC_PRM_20110505_01MBJ9BM.ARC recid=3 stamp=750364025
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=R:\ORACLE\BACKUP\PRM\ARC_PRM_20110505_04MBJ9BM.ARC recid=4 stamp=750364058
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=R:\ORACLE\BACKUP\PRM\ARC_PRM_20110505_05MBJ9HE.ARC recid=5 stamp=750364213
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=R:\ORACLE\BACKUP\PRM\ARC_PRM_20110505_06MBJ9I4.ARC recid=6 stamp=750364240
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=R:\ORACLE\BACKUP\PRM\ARC_PRM_20110505_07MBJ9ID.ARC recid=7 stamp=750364255
Crosschecked 7 objects

Starting backup at 05-MAY-11
channel d1: starting compressed full datafile backupset
channel d1: specifying datafile(s) in backupset
input datafile fno=00094 name=S:\ORACLE\PRM\SAPDATA3\PRM700_7\PRM700.DATA7
.
.
input datafile fno=00091 name=S:\ORACLE\PRM\SAPDATA3\PRM700_5\PRM700.DATA5
channel d1: starting piece 1 at 05-MAY-11
channel d2: starting compressed full datafile backupset
channel d2: specifying datafile(s) in backupset
input datafile fno=00011 name=S:\ORACLE\PRM\SAPDATA2\PRM_8\PRM.DATA8
.
.
input datafile fno=00090 name=S:\ORACLE\PRM\SAPDATA3\PRM700_4\PRM700.DATA4
channel d2: starting piece 1 at 05-MAY-11
channel d3: starting compressed full datafile backupset
channel d3: specifying datafile(s) in backupset
input datafile fno=00010 name=S:\ORACLE\PRM\SAPDATA2\PRM_7\PRM.DATA7
.
.
input datafile fno=00088 name=S:\ORACLE\PRM\SAPDATA3\PRM700_2\PRM700.DATA2
channel d3: starting piece 1 at 05-MAY-11
channel d4: starting compressed full datafile backupset
channel d4: specifying datafile(s) in backupset
input datafile fno=00002 name=S:\ORACLE\PRM\SAPDATA1\UNDO_1\UNDO.DATA1
.
.
input datafile fno=00093 name=S:\ORACLE\PRM\SAPDATA4\PRMUSR_1\PRMUSR.DATA1
channel d4: starting piece 1 at 05-MAY-11
channel d4: finished piece 1 at 05-MAY-11
piece handle=R:\ORACLE\BACKUP\PRM\DBF_PRM_20110505_0BMBJAFO.DB tag=TAG20110505T184609 comment=NONE
channel d4: backup set complete, elapsed time: 01:06:17
channel d4: starting compressed full datafile backupset
channel d4: specifying datafile(s) in backupset
input datafile fno=00012 name=S:\ORACLE\PRM\SAPDATA2\PRM_9\PRM.DATA9
input datafile fno=00031 name=S:\ORACLE\PRM\SAPDATA2\PRM_28\PRM.DATA28
input datafile fno=00039 name=S:\ORACLE\PRM\SAPDATA2\PRM_36\PRM.DATA36
input datafile fno=00058 name=S:\ORACLE\PRM\SAPDATA2\PRM_55\PRM.DATA55
input datafile fno=00062 name=S:\ORACLE\PRM\SAPDATA2\PRM_59\PRM.DATA59
input datafile fno=00074 name=S:\ORACLE\PRM\SAPDATA2\PRM_71\PRM.DATA71
input datafile fno=00084 name=S:\ORACLE\PRM\SAPDATA2\PRM_81\PRM.DATA81
input datafile fno=00019 name=S:\ORACLE\PRM\SAPDATA2\PRM_16\PRM.DATA16
channel d4: starting piece 1 at 05-MAY-11
channel d2: finished piece 1 at 05-MAY-11
piece handle=R:\ORACLE\BACKUP\PRM\DBF_PRM_20110505_09MBJAFM.DB tag=TAG20110505T184609 comment=NONE
channel d2: backup set complete, elapsed time: 01:07:20
channel d2: starting compressed full datafile backupset
channel d2: specifying datafile(s) in backupset
input datafile fno=00014 name=S:\ORACLE\PRM\SAPDATA2\PRM_11\PRM.DATA11
input datafile fno=00033 name=S:\ORACLE\PRM\SAPDATA2\PRM_30\PRM.DATA30
input datafile fno=00041 name=S:\ORACLE\PRM\SAPDATA2\PRM_38\PRM.DATA38
input datafile fno=00053 name=S:\ORACLE\PRM\SAPDATA2\PRM_50\PRM.DATA50
input datafile fno=00065 name=S:\ORACLE\PRM\SAPDATA2\PRM_62\PRM.DATA62
input datafile fno=00077 name=S:\ORACLE\PRM\SAPDATA2\PRM_74\PRM.DATA74
input datafile fno=00006 name=S:\ORACLE\PRM\SAPDATA2\PRM_3\PRM.DATA3
input datafile fno=00020 name=S:\ORACLE\PRM\SAPDATA2\PRM_17\PRM.DATA17
channel d2: starting piece 1 at 05-MAY-11
channel d3: finished piece 1 at 05-MAY-11
piece handle=R:\ORACLE\BACKUP\PRM\DBF_PRM_20110505_0AMBJAFN.DB tag=TAG20110505T184609 comment=NONE
channel d3: backup set complete, elapsed time: 01:07:22
channel d3: starting compressed full datafile backupset
channel d3: specifying datafile(s) in backupset
input datafile fno=00015 name=S:\ORACLE\PRM\SAPDATA2\PRM_12\PRM.DATA12
input datafile fno=00034 name=S:\ORACLE\PRM\SAPDATA2\PRM_31\PRM.DATA31
input datafile fno=00042 name=S:\ORACLE\PRM\SAPDATA2\PRM_39\PRM.DATA39
input datafile fno=00054 name=S:\ORACLE\PRM\SAPDATA2\PRM_51\PRM.DATA51
input datafile fno=00066 name=S:\ORACLE\PRM\SAPDATA2\PRM_63\PRM.DATA63
input datafile fno=00078 name=S:\ORACLE\PRM\SAPDATA2\PRM_75\PRM.DATA75
input datafile fno=00007 name=S:\ORACLE\PRM\SAPDATA2\PRM_4\PRM.DATA4
input datafile fno=00021 name=S:\ORACLE\PRM\SAPDATA2\PRM_18\PRM.DATA18
channel d3: starting piece 1 at 05-MAY-11
channel d1: finished piece 1 at 05-MAY-11
piece handle=R:\ORACLE\BACKUP\PRM\DBF_PRM_20110505_08MBJAFL.DB tag=TAG20110505T184609 comment=NONE
channel d1: backup set complete, elapsed time: 01:10:11
channel d1: starting compressed full datafile backupset
channel d1: specifying datafile(s) in backupset
input datafile fno=00002 name=S:\ORACLE\PRM\SAPDATA1\UNDO_1\UNDO.DATA1
input datafile fno=00047 name=S:\ORACLE\PRM\SAPDATA2\PRM_44\PRM.DATA44
input datafile fno=00059 name=S:\ORACLE\PRM\SAPDATA2\PRM_56\PRM.DATA56
input datafile fno=00070 name=S:\ORACLE\PRM\SAPDATA2\PRM_67\PRM.DATA67
input datafile fno=00081 name=S:\ORACLE\PRM\SAPDATA2\PRM_78\PRM.DATA78
input datafile fno=00085 name=S:\ORACLE\PRM\SAPDATA2\PRM_82\PRM.DATA82
input datafile fno=00091 name=S:\ORACLE\PRM\SAPDATA3\PRM700_5\PRM700.DATA5
channel d1: starting piece 1 at 05-MAY-11
channel d2: finished piece 1 at 05-MAY-11
piece handle=E:\ORACLE\PRM\102\DATABASE\0DMBJEDV_1_1 tag=LV0_PRM comment=NONE
channel d2: backup set complete, elapsed time: 00:20:20
channel d2: starting compressed full datafile backupset
channel d2: specifying datafile(s) in backupset
input datafile fno=00016 name=S:\ORACLE\PRM\SAPDATA2\PRM_13\PRM.DATA13
input datafile fno=00035 name=S:\ORACLE\PRM\SAPDATA2\PRM_32\PRM.DATA32
input datafile fno=00043 name=S:\ORACLE\PRM\SAPDATA2\PRM_40\PRM.DATA40
input datafile fno=00055 name=S:\ORACLE\PRM\SAPDATA2\PRM_52\PRM.DATA52
input datafile fno=00061 name=S:\ORACLE\PRM\SAPDATA2\PRM_58\PRM.DATA58
input datafile fno=00072 name=S:\ORACLE\PRM\SAPDATA2\PRM_69\PRM.DATA69
input datafile fno=00008 name=S:\ORACLE\PRM\SAPDATA2\PRM_5\PRM.DATA5
input datafile fno=00089 name=S:\ORACLE\PRM\SAPDATA3\PRM700_3\PRM700.DATA3
channel d2: starting piece 1 at 05-MAY-11
channel d3: finished piece 1 at 05-MAY-11
piece handle=E:\ORACLE\PRM\102\DATABASE\0EMBJEE2_1_1 tag=LV0_PRM comment=NONE
channel d3: backup set complete, elapsed time: 00:20:18
channel d3: starting compressed full datafile backupset
channel d3: specifying datafile(s) in backupset
input datafile fno=00013 name=S:\ORACLE\PRM\SAPDATA2\PRM_10\PRM.DATA10
input datafile fno=00032 name=S:\ORACLE\PRM\SAPDATA2\PRM_29\PRM.DATA29
input datafile fno=00040 name=S:\ORACLE\PRM\SAPDATA2\PRM_37\PRM.DATA37
input datafile fno=00052 name=S:\ORACLE\PRM\SAPDATA2\PRM_49\PRM.DATA49
input datafile fno=00025 name=S:\ORACLE\PRM\SAPDATA2\PRM_22\PRM.DATA22
input datafile fno=00080 name=S:\ORACLE\PRM\SAPDATA2\PRM_77\PRM.DATA77
input datafile fno=00024 name=S:\ORACLE\PRM\SAPDATA2\PRM_21\PRM.DATA21
input datafile fno=00090 name=S:\ORACLE\PRM\SAPDATA3\PRM700_4\PRM700.DATA4
channel d3: starting piece 1 at 05-MAY-11
channel d4: finished piece 1 at 05-MAY-11
piece handle=E:\ORACLE\PRM\102\DATABASE\0CMBJEC3_1_1 tag=LV0_PRM comment=NONE
channel d4: backup set complete, elapsed time: 00:21:25
channel d4: starting compressed full datafile backupset
channel d4: specifying datafile(s) in backupset
input datafile fno=00017 name=S:\ORACLE\PRM\SAPDATA2\PRM_14\PRM.DATA14
input datafile fno=00036 name=S:\ORACLE\PRM\SAPDATA2\PRM_33\PRM.DATA33
input datafile fno=00044 name=S:\ORACLE\PRM\SAPDATA2\PRM_41\PRM.DATA41
input datafile fno=00049 name=S:\ORACLE\PRM\SAPDATA2\PRM_46\PRM.DATA46
input datafile fno=00068 name=S:\ORACLE\PRM\SAPDATA2\PRM_65\PRM.DATA65
input datafile fno=00023 name=S:\ORACLE\PRM\SAPDATA2\PRM_20\PRM.DATA20
input datafile fno=00022 name=S:\ORACLE\PRM\SAPDATA2\PRM_19\PRM.DATA19
input datafile fno=00088 name=S:\ORACLE\PRM\SAPDATA3\PRM700_2\PRM700.DATA2
channel d4: starting piece 1 at 05-MAY-11
channel d1: finished piece 1 at 05-MAY-11
piece handle=E:\ORACLE\PRM\102\DATABASE\0FMBJEJ8_1_1 tag=LV0_PRM comment=NONE
channel d1: backup set complete, elapsed time: 00:17:42
channel d1: starting compressed full datafile backupset
channel d1: specifying datafile(s) in backupset
input datafile fno=00026 name=S:\ORACLE\PRM\SAPDATA2\PRM_23\PRM.DATA23
input datafile fno=00037 name=S:\ORACLE\PRM\SAPDATA2\PRM_34\PRM.DATA34
input datafile fno=00045 name=S:\ORACLE\PRM\SAPDATA2\PRM_42\PRM.DATA42
input datafile fno=00051 name=S:\ORACLE\PRM\SAPDATA2\PRM_48\PRM.DATA48
input datafile fno=00067 name=S:\ORACLE\PRM\SAPDATA2\PRM_64\PRM.DATA64
input datafile fno=00079 name=S:\ORACLE\PRM\SAPDATA2\PRM_76\PRM.DATA76
input datafile fno=00009 name=S:\ORACLE\PRM\SAPDATA2\PRM_6\PRM.DATA6
input datafile fno=00087 name=S:\ORACLE\PRM\SAPDATA3\PRM700_1\PRM700.DATA1
channel d1: starting piece 1 at 05-MAY-11
channel d2: finished piece 1 at 05-MAY-11
piece handle=E:\ORACLE\PRM\102\DATABASE\0GMBJFK4_1_1 tag=LV0_PRM comment=NONE
channel d2: backup set complete, elapsed time: 00:20:58
channel d2: starting compressed full datafile backupset
channel d2: specifying datafile(s) in backupset
input datafile fno=00094 name=S:\ORACLE\PRM\SAPDATA3\PRM700_7\PRM700.DATA7
input datafile fno=00092 name=S:\ORACLE\PRM\SAPDATA3\PRM700_6\PRM700.DATA6
input datafile fno=00048 name=S:\ORACLE\PRM\SAPDATA2\PRM_45\PRM.DATA45
input datafile fno=00060 name=S:\ORACLE\PRM\SAPDATA2\PRM_57\PRM.DATA57
input datafile fno=00071 name=S:\ORACLE\PRM\SAPDATA2\PRM_68\PRM.DATA68
input datafile fno=00082 name=S:\ORACLE\PRM\SAPDATA2\PRM_79\PRM.DATA79
input datafile fno=00018 name=S:\ORACLE\PRM\SAPDATA2\PRM_15\PRM.DATA15
channel d2: starting piece 1 at 05-MAY-11
channel d3: finished piece 1 at 05-MAY-11
piece handle=E:\ORACLE\PRM\102\DATABASE\0HMBJFK5_1_1 tag=LV0_PRM comment=NONE
channel d3: backup set complete, elapsed time: 00:20:58
channel d3: starting compressed full datafile backupset
channel d3: specifying datafile(s) in backupset
input datafile fno=00028 name=S:\ORACLE\PRM\SAPDATA2\PRM_25\PRM.DATA25
input datafile fno=00086 name=S:\ORACLE\PRM\SAPDATA2\PRM_83\PRM.DATA83
input datafile fno=00046 name=S:\ORACLE\PRM\SAPDATA2\PRM_43\PRM.DATA43
input datafile fno=00050 name=S:\ORACLE\PRM\SAPDATA2\PRM_47\PRM.DATA47
input datafile fno=00069 name=S:\ORACLE\PRM\SAPDATA2\PRM_66\PRM.DATA66
input datafile fno=00073 name=S:\ORACLE\PRM\SAPDATA2\PRM_70\PRM.DATA70
input datafile fno=00083 name=S:\ORACLE\PRM\SAPDATA2\PRM_80\PRM.DATA80
input datafile fno=00001 name=S:\ORACLE\PRM\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
channel d3: starting piece 1 at 05-MAY-11
channel d4: finished piece 1 at 05-MAY-11
piece handle=E:\ORACLE\PRM\102\DATABASE\0IMBJFK9_1_1 tag=LV0_PRM comment=NONE
channel d4: backup set complete, elapsed time: 00:20:55
channel d4: starting compressed full datafile backupset
channel d4: specifying datafile(s) in backupset
input datafile fno=00010 name=S:\ORACLE\PRM\SAPDATA2\PRM_7\PRM.DATA7
input datafile fno=00029 name=S:\ORACLE\PRM\SAPDATA2\PRM_26\PRM.DATA26
input datafile fno=00027 name=S:\ORACLE\PRM\SAPDATA2\PRM_24\PRM.DATA24
input datafile fno=00056 name=S:\ORACLE\PRM\SAPDATA2\PRM_53\PRM.DATA53
input datafile fno=00063 name=S:\ORACLE\PRM\SAPDATA2\PRM_60\PRM.DATA60
input datafile fno=00075 name=S:\ORACLE\PRM\SAPDATA2\PRM_72\PRM.DATA72
input datafile fno=00004 name=S:\ORACLE\PRM\SAPDATA2\PRM_1\PRM.DATA1
input datafile fno=00003 name=S:\ORACLE\PRM\SAPDATA1\SYSAUX_1\SYSAUX.DATA1
channel d4: starting piece 1 at 05-MAY-11
channel d1: finished piece 1 at 05-MAY-11
piece handle=E:\ORACLE\PRM\102\DATABASE\0JMBJFKE_1_1 tag=LV0_PRM comment=NONE
channel d1: backup set complete, elapsed time: 00:20:58
channel d1: starting compressed full datafile backupset
channel d1: specifying datafile(s) in backupset
input datafile fno=00011 name=S:\ORACLE\PRM\SAPDATA2\PRM_8\PRM.DATA8
input datafile fno=00030 name=S:\ORACLE\PRM\SAPDATA2\PRM_27\PRM.DATA27
input datafile fno=00038 name=S:\ORACLE\PRM\SAPDATA2\PRM_35\PRM.DATA35
input datafile fno=00057 name=S:\ORACLE\PRM\SAPDATA2\PRM_54\PRM.DATA54
input datafile fno=00064 name=S:\ORACLE\PRM\SAPDATA2\PRM_61\PRM.DATA61
input datafile fno=00076 name=S:\ORACLE\PRM\SAPDATA2\PRM_73\PRM.DATA73
input datafile fno=00005 name=S:\ORACLE\PRM\SAPDATA2\PRM_2\PRM.DATA2
input datafile fno=00093 name=S:\ORACLE\PRM\SAPDATA4\PRMUSR_1\PRMUSR.DATA1
channel d1: starting piece 1 at 05-MAY-11
RMAN-03009: failure of backup command on d1 channel at 05/05/2011 20:40:58
ORA-19502: write error on file "E:\ORACLE\PRM\102\DATABASE\0NMBJGRP_1_1", blockno 189697 (blocksize=8192)
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
channel d1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on d2 channel at 05/05/2011 20:40:59
ORA-19502: write error on file "E:\ORACLE\PRM\102\DATABASE\0KMBJGRE_1_1", blockno 197377 (blocksize=8192)
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
channel d2 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on d3 channel at 05/05/2011 20:40:59
ORA-19502: write error on file "E:\ORACLE\PRM\102\DATABASE\0LMBJGRF_1_1", blockno 196609 (blocksize=8192)
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
channel d3 disabled, job failed on it will be run on another channel
released channel: d1
released channel: d2
released channel: d3
released channel: d4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on d4 channel at 05/05/2011 20:40:59
ORA-19502: write error on file "E:\ORACLE\PRM\102\DATABASE\0MMBJGRH_1_1", blockno 199681 (blocksize=8192)
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.

Recovery Manager complete.

Can you people see that suddenly start to write the backup pieces on E: rather than on R: ?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2011

Added on May 6 2011

#performance-availability, #recovery-manager-rman

7 comments

181 views

Database Software

Wrong format for disk backups

Comments

Post Details