ADSM-L

[ADSM-L] Strange error on TDP Oracle with DELETE OBSOLETE

2010-05-05 10:59:15
Subject: [ADSM-L] Strange error on TDP Oracle with DELETE OBSOLETE
From: Bill Boyer <bjdboyer AT VERIZON DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 5 May 2010 10:57:49 -0400
Have a TDP 5.4.1.0 running on AIX. The RMAN script does a backup of the
database, backup of the logs and then a DELETE OBSOLETE. From the output you
see the channel allocating fine and the delete starts working
until.BANG.ANS1033E Invalid TCP/IP Host. From the TSM server actlog I can
see multiple sessions start/stop for this delete obsolete. It looks like
RMAN opens/closes a session for each backup piece. So it's going along just
fine and then failing with a DNS lookup failure?? Any ideas?

RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=502 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0


RMAN> delete noprompt obsolete recovery window of 35 days device type
'SBT_TAPE';
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1528   17-APR-10
 Backup Piece       1528   17-APR-10          golbantu_1_1
Backup Set           1529   17-APR-10
 Backup Piece       1529   17-APR-10          gplbb604_1_1
Backup Set           1530   17-APR-10
 Backup Piece       1530   17-APR-10          gqlbbk1t_1_1
Backup Set           1532   18-APR-10
 Backup Piece       1532   18-APR-10          gslbd417_1_1
Backup Set           1533   18-APR-10
 Backup Piece       1533   18-APR-10          gtlbdc9s_1_1
Backup Set           1534   18-APR-10
 Backup Piece       1534   18-APR-10          gulbdqbp_1_1
Backup Set           1535   18-APR-10
 Backup Piece       1535   18-APR-10          gvlbe8dq_1_1
deleted backup piece
backup piece handle=golbantu_1_1 recid=1528 stamp=716529599
deleted backup piece
backup piece handle=gplbb604_1_1 recid=1529 stamp=716544005
deleted backup piece
backup piece handle=gqlbbk1t_1_1 recid=1530 stamp=716558398
deleted backup piece
backup piece handle=gslbd417_1_1 recid=1532 stamp=716607528
deleted backup piece
backup piece handle=gtlbdc9s_1_1 recid=1533 stamp=716615998
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_1 channel at
05/05/2010 01:36:05
ORA-19509: failed to delete sequential file, handle="gulbdqbp_1_1", parms=""

ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
  ANS1033E (RC-53)  An invalid TCP/IP address was specified.


Bill Boyer
"My childlike immaturity's the only thing standing between me and a major
midlife crisis" - ??

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