Re: [ADSM-L] Strange error on TDP Oracle with DELETE OBSOLETE
2010-05-05 11:16:40
Bill. Weird. Just a thought though... Is the TCPSERVERADDRESS in your
dsm.sys stanza a hostname or an IP address? Could a name lookup of the TSM
server be crazily failing from time to time, particularly evident when
opening and closing lots of sessions (making lots of name server lookup
calls) in quick succession? If it is a name, perhaps replacing with an IP
address and testing could be interesting. Like I say, just a thought...
/DMc
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bill Boyer
Sent: 05 May 2010 15:58
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Strange error on TDP Oracle with DELETE OBSOLETE
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" - ??
|
|
|