Skip to Main Content

Database Software

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!

Rman Tape Backup Error

847798Oct 25 2011 — edited Oct 25 2011
Dear all,

We have scheduled Rman tape backup at 3 am.It was running successfully from past 6 months but now we are getting the following error.Even we have contacted storage vendors they are saying nothing fault in tivoli level.Please see the output and suggest me some solution.
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
allocated channel: c1
channel c1: sid=293 instance=gcprod1 devtype=SBT_TAPE
channel c1: Data Protection for Oracle: version 5.4.1.0

allocated channel: c2
channel c2: sid=331 instance=gcprod1 devtype=SBT_TAPE
channel c2: Data Protection for Oracle: version 5.4.1.0

sql statement: alter system archive log current

Starting backup at 25-OCT-11
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00016 name=+ASMIND/gcprod/datafile/ts_indx.257.671916253
input datafile fno=00021 name=+ASMDB/gcprod/datafile/ins.292.723319939
input datafile fno=00022 name=+ASMDB/gcprod/datafile/ins.293.733098445
input datafile fno=00017 name=+ASMDB/gcprod/datafile/ins.285.679091079
input datafile fno=00024 name=+ASMDB/gcprod/datafile/ins.294.749302139
input datafile fno=00027 name=+ASMDB/gcprod/datafile/ins.288.758370003
input datafile fno=00005 name=+ASMDB/gcprod/datafile/undotbs2.264.661355167
input datafile fno=00013 name=+ASMDB/gcprod/datafile/conftbs.283.670512553
input datafile fno=00032 name=+ASMDB/gcprod/datafile/ts_cholamarine.296.761396131
input datafile fno=00009 name=+ASMDB/gcprod/datafile/reins.271.663181465
input datafile fno=00033 name=+ASMIND/gcprod/datafile/ts_indx.263.763834593
input datafile fno=00026 name=+ASMIND/gcprod/datafile/ts_indx.261.758369829
input datafile fno=00030 name=+ASMDB/gcprod/datafile/ts_cholacordys.290.761253865
input datafile fno=00035 name=+ASMDB/gcprod/datafile/ins.301.765025251
input datafile fno=00011 name=+ASMDB/gcprod/datafile/bi.273.663181547
input datafile fno=00020 name=+ASMDB/gcprod/datafile/ts_dasboard.287.695750257
input datafile fno=00001 name=+ASMDB/gcprod/datafile/system.256.661355085
channel c1: starting piece 1 at 25-OCT-11
channel c2: starting compressed full datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00015 name=+ASMIND/gcprod/datafile/ts_indx.256.671916039
input datafile fno=00023 name=+ASMIND/gcprod/datafile/ts_indx.259.733098623
input datafile fno=00006 name=+ASMDB/gcprod/datafile/ins.268.663179477
input datafile fno=00019 name=+ASMDB/gcprod/datafile/ins.286.688736973
input datafile fno=00007 name=+ASMDB/gcprod/datafile/conftbs.269.663180985
input datafile fno=00025 name=+ASMIND/gcprod/datafile/ts_indx.260.753906969
input datafile fno=00002 name=+ASMDB/gcprod/datafile/undotbs1.258.661355087
input datafile fno=00008 name=+ASMDB/gcprod/datafile/conftbs.270.663181203
input datafile fno=00031 name=+ASMDB/gcprod/datafile/ts_cholacordys.291.761254763
input datafile fno=00028 name=+ASMDB/gcprod/datafile/ins.289.761069847
input datafile fno=00014 name=+ASMDB/gcprod/datafile/cognos.284.670592467
input datafile fno=00029 name=+ASMIND/gcprod/datafile/ts_indx.262.761071139
input datafile fno=00034 name=+ASMDB/gcprod/datafile/ins.300.764349473
input datafile fno=00003 name=+ASMDB/gcprod/datafile/sysaux.257.661355085
input datafile fno=00012 name=+ASMDB/gcprod/datafile/intrfc.274.663181585
input datafile fno=00010 name=+ASMDB/gcprod/datafile/analyst.272.663181499
input datafile fno=00018 name=+ASMIND/gcprod/datafile/ts_cholaweb.258.682097565
input datafile fno=00004 name=+ASMDB/gcprod/datafile/users.259.661355087
channel c2: starting piece 1 at 25-OCT-11
RMAN-03009: failure of backup command on c2 channel at 10/25/2011 04:01:56
ORA-19502: write error on file "2mmpv0o1_1_1", blockno 513 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1235E (RC-72)  An unknown system error has occurred from which TSM cannot recover.
channel c2 disabled, job failed on it will be run on another channel
channel c1: finished piece 1 at 25-OCT-11
piece handle=2lmpv0o0_1_1 tag=TAG20111025T030120 comment=API Version 2.0,MMS Version 5.4.1.0
channel c1: backup set complete, elapsed time: 02:09:22
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00015 name=+ASMIND/gcprod/datafile/ts_indx.256.671916039
input datafile fno=00023 name=+ASMIND/gcprod/datafile/ts_indx.259.733098623
input datafile fno=00006 name=+ASMDB/gcprod/datafile/ins.268.663179477
input datafile fno=00019 name=+ASMDB/gcprod/datafile/ins.286.688736973
input datafile fno=00007 name=+ASMDB/gcprod/datafile/conftbs.269.663180985
input datafile fno=00025 name=+ASMIND/gcprod/datafile/ts_indx.260.753906969
input datafile fno=00002 name=+ASMDB/gcprod/datafile/undotbs1.258.661355087
input datafile fno=00008 name=+ASMDB/gcprod/datafile/conftbs.270.663181203
input datafile fno=00031 name=+ASMDB/gcprod/datafile/ts_cholacordys.291.761254763
input datafile fno=00028 name=+ASMDB/gcprod/datafile/ins.289.761069847
input datafile fno=00014 name=+ASMDB/gcprod/datafile/cognos.284.670592467
input datafile fno=00029 name=+ASMIND/gcprod/datafile/ts_indx.262.761071139
input datafile fno=00034 name=+ASMDB/gcprod/datafile/ins.300.764349473
input datafile fno=00003 name=+ASMDB/gcprod/datafile/sysaux.257.661355085
input datafile fno=00012 name=+ASMDB/gcprod/datafile/intrfc.274.663181585
input datafile fno=00010 name=+ASMDB/gcprod/datafile/analyst.272.663181499
input datafile fno=00018 name=+ASMIND/gcprod/datafile/ts_cholaweb.258.682097565
input datafile fno=00004 name=+ASMDB/gcprod/datafile/users.259.661355087
channel c1: starting piece 1 at 25-OCT-11
channel c1: finished piece 1 at 25-OCT-11
piece handle=2nmpv8ai_1_1 tag=TAG20111025T030120 comment=API Version 2.0,MMS Version 5.4.1.0
channel c1: backup set complete, elapsed time: 01:58:36
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 25-OCT-11
channel c1: finished piece 1 at 25-OCT-11
piece handle=35mpvf8u_1_1 tag=TAG20111025T030120 comment=API Version 2.0,MMS Version 5.4.1.0
channel c1: backup set complete, elapsed time: 00:00:08
Finished backup at 25-OCT-11

Starting backup at 25-OCT-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 25-OCT-11
channel c1: finished piece 1 at 25-OCT-11
piece handle=36mpvf9d_1_1 tag=TAG20111025T070933 comment=API Version 2.0,MMS Version 5.4.1.0
channel c1: backup set complete, elapsed time: 00:00:04
Finished backup at 25-OCT-11

Starting Control File and SPFILE Autobackup at 25-OCT-11
piece handle=c-1251728398-20111025-02 comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 25-OCT-11

sql statement: alter system archive log current

released channel: c1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 10/25/2011 07:09:46
RMAN-06012: channel: c2 not allocated

RMAN>

Recovery Manager complete.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2011
Added on Oct 25 2011
8 comments
949 views