Just write a Unix script that tsm kicks off with a command action
schedule and then have that script put the tablespaces in backup mode, do a
dsmc arch of the data files, control files, and archive logs then have it
take the tablespaces back out of backup mode. You can get a list of data
file and control files by selecting them out of v$datafile I believe the
view is and v$controlfile the dba would know what I'm talking about.

      That's the best way unless you want to use RMAN which I'm not sure
how that works on Linux systems. I mean it's Oracle the O/S shouldn't
matter for the most part. Now remember the database needs to be in:
"ARCHIVE-LOG-MODE" and there must be a user like on defined in the O/S, in
the "/etc/passwd" file in Oracle as well identified externally this way
"sqlplus -s \" can login automatically by the script to put the tablespaces
in and out of backupmode and issue the queries against the views.

      We have this running nicely on Redhat 7 Linux systems just fine with
Oracle 8 databases going to TSM client 5.1.0 and TSM server 4.2.2.13

--Justin Richard Bleistein
Unix Systems Administrator (Sungard eSourcing)
Desk: (856) 866 - 4017
Cell:    (856) 912 - 0861
Email: justin.bleistein AT sungard DOT com



                      "Camilo A.
                      Marrugo"                 To:       ADSM-L AT VM.MARIST 
DOT EDU
                      <camilo@DIALTONE.        cc:
                      COM>                     Subject:  Oracle backup in linux 
with tivoli
                      Sent by: "ADSM:
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      01/24/2003 10:04
                      AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






I have a customer which is implementing an Oracle dabase on his linux
redhat machine, and I was wondering if any of you gurus, knew what could
be done with tivoli to back this up.

The customer says he preffers hot backups. What do you think.

Thanks,
Camilo Marrugo
--
Camilo A. Marrugo
Data Storage Manager
Dialtone Interland
camilo AT dialtone DOT com - http://www.dialtone.com
Voice: 1.800.621.8309 ext. 1503  Toll Free

Confidentiality Note: The information transmitted is intended only
for the person or entity to whom or which it is addressed and may
contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities
other than the intended recipient is prohibited. If you receive this in
error, please delete this material immediately.