ADSM-L

Re: Backing Up Oracle DB with TSM 4.2.1

2002-06-26 19:26:30
Subject: Re: Backing Up Oracle DB with TSM 4.2.1
From: Steve Harris <Steve_Harris AT HEALTH.QLD.GOV DOT AU>
Date: Thu, 27 Jun 2002 09:20:24 +1000
Yes Bill,

Your point is correct if the pre/post commands are coded in dsm.sys.  However 
is possible to specify them on the command line and hence through the -opt 
parameter of a schedule, in which case they only apply to that schedule.

Steve.


>>> bill.boyer AT VERIZON DOT NET 26/06/2002 22:53:03 >>>
Just a little comment on #2...the pre/postschedule commands run every time
you run a schedule against that node! So if you were to maybe run a
CLIENTACTION against the node to do a special backup of a file/directory,
not necessarily the whole server, you're shutting down your database. If
that's in the middle of the day, the users ain't gonna be to happy with ya.
For Orcale COLD backups, we have a shell script that shuts down the Oracle
instance, does other maintenance tasks then calls DSMC I to do an
incremental backup, Checks the return code and alerts on != 0 and then
restarts Oracle instance.

We have found this works better than the pre/post commands. We can do a
better job of return code checking of Oracle tasks before running the
backup. Now with the new and improved! return code checking in V5.1 maybe we
could make it work, but you gotta remember that this command will be run
every time you run a schedule against the node!!

Bill Boyer
DSS, Inc.

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