ADSM-L

[ADSM-L] Problems with Oracle TDP

2010-08-11 15:23:10
Subject: [ADSM-L] Problems with Oracle TDP
From: Howard Coles <Howard.Coles AT ARDENTHEALTH DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 11 Aug 2010 14:21:49 -0500
Gents, I'm having some weirdness with the TDP that's driving me crazy
because my DBQ is wearing me out about it.

The problem is that we're seeing errors that a transaction failed,
mainly with the "Requested data was not found" errors.  My contention is
that these jobs are getting retried, as was the case in times past.
However, I don't see that in the logs in later versions of the TDP.

 

Here are some snips from the logs:
>From dsmerror.log:

08/07/10   23:00:31 ANS0278S The transaction will be aborted.

08/07/10   23:00:31 ANS1309I The requested data is offline.

08/07/10   23:00:33 ANS1303E Client ended transaction

 

-- These are warnings, unlike the ones on 8/7 and 8/10

08/08/10   23:58:10 ANS4992W TDP Oracle AIX ANU0599 TDP for Oracle:
(21884988):

=>(tulhci01-oracle) ANU2604W The object /tulhci01_hcidb/
/c-506694242-20100808-06 was not found on the TSM Server

 

08/09/10   00:10:44 ANS4992W TDP Oracle AIX ANU0599 TDP for Oracle:
(21266518):

=>(tulhci01-oracle) ANU2604W The object /tulhci01_hcidb/
/c-251359303-20100809-00 was not found on the TSM Server

 

08/10/10   23:00:42 ANS0278S The transaction will be aborted.

08/10/10   23:00:42 ANS1309I The requested data is offline.

08/10/10   23:02:07 ANS1303E Client ended transaction

 

>From tdpoerror.log:

08/07/10   23:00:31 TID<26927212> ==> ANS0278S (RC157)  The transaction
will be aborted.

08/07/10   23:00:31 TID<26927212> ==> ANS1309I (RC9)    The requested
data is offline.

08/07/10   23:00:31 TID<26927212> ==> ANU2539E sbtwrite2(): Error - buf
pointer is NULL.

08/07/10   23:00:31 TID<26927212> ==> ANU2539E sbtwrite2(): Error - buf
pointer is NULL.

08/07/10   23:00:31 TID<26927212> ==> ANU2539E sbtwrite2(): Error - buf
pointer is NULL.

 

 

08/10/10   23:00:42 TID<28192938> ==> ANS0278S (RC157)  The transaction
will be aborted.

08/10/10   23:00:42 TID<28192938> ==> ANS1309I (RC9)    The requested
data is offline.

08/10/10   23:00:42 TID<28192938> ==> ANU2539E sbtwrite2(): Error - buf
pointer is NULL.

08/10/10   23:00:42 TID<28192938> ==> ANU2539E sbtwrite2(): Error - buf
pointer is NULL.

08/10/10   23:00:42 TID<28192938> ==> ANU2539E sbtwrite2(): Error - buf
pointer is NULL.

 

Information from the Client/Server:

Client OS:  AIX 5.3.11

TSM BA Client: 6.2.1

TSM Server: 5.5.3

TSM TDP: 5.5.2

 

I found the doc about the "Requested Data not found" and I understand
what that means.  However, the TDP is reporting the backup completed,
(as shown by looking at the details of the filespaces), and this is
coming from a full backup.  

My stance is that the backups are getting done, and that this
transaction is being retried, but the DBA doesn't see it that way, and
since I can't show it definitively in the log I need some help on this.

 

 

See Ya'

Howard Coles Jr.

RHCE, CDE, CNE

Sr. Systems Engineer

(615) 296-3416

John 3:16!

 

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