ADSM-L

Re: RMAN with TDP for oracle error

2006-12-26 09:28:38
Subject: Re: RMAN with TDP for oracle error
From: "Cargill, Bill" <BHCargill AT SNOPUD DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 26 Dec 2006 06:28:13 -0800
   What is your OS level? if it's 5.3 ML5 and no SP's than it could BE
an  APAR that is fixed in SP2. Also there is an Oracle patch to go with
it. I had this problem, don't recall the IBM APAR number, but this
sounds like the same problem I had. Both the IBM APAR and Oracle patch
will need to go on together.


   Bill

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Ahmed Al-Saidi
Sent: Tuesday, December 26, 2006 12:41 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: RMAN with TDP for oracle error

Hi all,
 
I face a problem this morning with oracle backup using TDP for oracle 
 
RMAN-03009: failure of backup command on ORA_DISK_1 channel at
12/26/2006 09:30:26
ORA-19502: write error on file "df_610190894_54_4", blockno 39297
(blocksize=8192)
ORA-27072: skgfdisp: 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.
 
I didn't find any error in tdpoerror.log
 
 
Did anyone face same problem???
 
This is RMAN log file
 
 
RMAN> run
2> {
3>    allocate channel t1 type 'sbt_tape' parms
4>       'ENV=(TDPO_OPTFILE=C:\Program
Files\Tivoli\TSM\AgentOBA\tdpo.opt)';
5> 
6>   shutdown immediate 
7>   startup mount
8> 
9>   backup
10>     filesperset 64
11>     format 'df_%t_%s_%p'
12>     (database);
13> 
14>   alter database open;
15> 
16> }
17> 
18> 
using target database controlfile instead of recovery catalog
allocated channel: t1
channel t1: sid=20 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0
 
database closed
database dismounted
Oracle instance shut down
 
connected to target database (not started)
Oracle instance started
database mounted
 
Total System Global Area    1209082940 bytes
 
Fixed Size                      455740 bytes
Variable Size               1182793728 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes
 
Starting backup at 26/12/06 09:28:12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00008 name=E:\ORACLE\ORADATA\COPYDB\COPY01.ORA
input datafile fno=00009 name=E:\ORACLE\ORADATA\COPYDB\COPY02.ORA
input datafile fno=00010 name=E:\ORACLE\ORADATA\COPYDB\COPY03.ORA
input datafile fno=00011 name=E:\ORACLE\ORADATA\COPYDB\COPY04.ORA
input datafile fno=00012 name=E:\ORACLE\ORADATA\COPYDB\COPY17.ORA
input datafile fno=00013 name=E:\ORACLE\ORADATA\COPYDB\COPY18.ORA
input datafile fno=00014 name=E:\ORACLE\ORADATA\COPYDB\COPY19.ORA
input datafile fno=00015 name=E:\ORACLE\ORADATA\COPYDB\COPY05.ORA
input datafile fno=00016 name=E:\ORACLE\ORADATA\COPYDB\COPY06.ORA
input datafile fno=00017 name=E:\ORACLE\ORADATA\COPYDB\COPY07.ORA
input datafile fno=00018 name=E:\ORACLE\ORADATA\COPYDB\COPY08.ORA
input datafile fno=00019 name=E:\ORACLE\ORADATA\COPYDB\COPY09.ORA
input datafile fno=00020 name=E:\ORACLE\ORADATA\COPYDB\COPY10.ORA
input datafile fno=00021 name=E:\ORACLE\ORADATA\COPYDB\COPY11.ORA
input datafile fno=00022 name=E:\ORACLE\ORADATA\COPYDB\COPY12.ORA
input datafile fno=00023 name=E:\ORACLE\ORADATA\COPYDB\COPY13.ORA
input datafile fno=00024 name=E:\ORACLE\ORADATA\COPYDB\COPY14.ORA
input datafile fno=00025 name=E:\ORACLE\ORADATA\COPYDB\COPY15.ORA
input datafile fno=00026 name=E:\ORACLE\ORADATA\COPYDB\COPY16.ORA
input datafile fno=00001 name=E:\ORACLE\ORADATA\COPYDB\SYSTEM01.DBF
input datafile fno=00002 name=E:\ORACLE\ORADATA\COPYDB\UNDOTBS01.DBF
input datafile fno=00007 name=E:\ORACLE\ORADATA\COPYDB\XDB01.DBF
input datafile fno=00004 name=E:\ORACLE\ORADATA\COPYDB\INDX01.DBF
input datafile fno=00003 name=E:\ORACLE\ORADATA\COPYDB\DRSYS01.DBF
input datafile fno=00006 name=E:\ORACLE\ORADATA\COPYDB\USERS01.DBF
input datafile fno=00005 name=E:\ORACLE\ORADATA\COPYDB\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 26/12/06 09:28:16
channel ORA_DISK_1: finished piece 1 at 26/12/06 09:28:51
piece handle=C:\ORACLE\ORA92\DATABASE\DF_610190894_54_1 comment=NONE
channel ORA_DISK_1: starting piece 2 at 26/12/06 09:28:51
channel ORA_DISK_1: finished piece 2 at 26/12/06 09:29:26
piece handle=C:\ORACLE\ORA92\DATABASE\DF_610190894_54_2 comment=NONE
channel ORA_DISK_1: starting piece 3 at 26/12/06 09:29:26
channel ORA_DISK_1: finished piece 3 at 26/12/06 09:30:01
piece handle=C:\ORACLE\ORA92\DATABASE\DF_610190894_54_3 comment=NONE
channel ORA_DISK_1: starting piece 4 at 26/12/06 09:30:01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at
12/26/2006 09:30:26
ORA-19502: write error on file "df_610190894_54_4", blockno 39297
(blocksize=8192)
ORA-27072: skgfdisp: 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.

<Prev in Thread] Current Thread [Next in Thread>