The TSM product Tivoli Data Protection for Oracle or the earlier ADSM
connect agent for Oracle work the same way.   Both of them allow Oracle's
RMAN or EBU to use the TSM Server as the repository for the backups.   In
affect, the TSM Server appears to Oracle as a storage/tape device.   It
sends data to the device and recalls it from the device.

All the workings for how database tables are handled is done by Oracle.  The
TSM product is just the interface between Oracle and the TSM server.

Answers to your questions.

1.  YES, done through Oracles RMAN or EBU
2.  The connect agent does not access the Oracle tables directly.  RMAN or
EBU send the data to the TSM server using the connect agent.
3.  Whatever amount RMAN or EBU decides to send.
4.  The connect agent does not require that the ADSM client code is
installed.   Just the API package is required.  Oracle must be configured to
use the connect agent as a storage device.  The connect agent must be
configured to talk to the ADSM Server.  Then you have
the following.
  Oracle <-> RMAN or EBU <-> Connect Agent <-> ADSM Server.

Regards,

James Thompson

From: "Etherington, Keith (K.)" <ketherin AT FORD DOT COM>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Oracle Agent
Date: Wed, 16 Aug 2000 06:42:15 -0400

We are currently running  ADSM Sever Code 3.1.2.40 on AIX 4.3.2 using an
IBM
3466 NSM
Some of our Oracle Databases have now grown to 100Gb. We shutdown the
database in a pre script run the backup
then restart the databases with the post script. However the backups take
about 7 hrs backing up the 100 GB.
My questions are using the Oracle Connect agent  :-
1)      Can the backups run allowing hot backups (database kept up whilst
backup running)
2)      How does the connect agent backup only updated parts of the Oracle
database
3)      Approx how much data will be backed up from a 100Gb database using
the connect agent
4)      Is the connect agent installed and configured on the client using
Oracle or ADSM client code

Regards,
Keith Etherington,
Snr Software Analyst,
Global Technical Services,
Room 1/148, Eagle Way,
Warley, Brentwood,
Essex, CM13 3BW

E-Mail        ketherin AT ford DOT com
Telephone  +44 (0)1277-253038
Fax             +44 (0)1277-253603

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com