Lisa,
We deal with it the same way you do: One single entry
in root crontab.
Manuel
--- Lisa Cabanas <CABANL AT MODOT DOT NET> wrote:
>
>
>
>
>
>
> Neil,
>
> how do you deal with setting up the archiving for
> the redo logs? Our DBAs
> elected to go CRON all the way, because they were
> hung up on trying to use
> the scheduler to test the thresholds every ten
> minutes. They didn't want
> to use a number of schedulers to run the hot/full,
> hot/incr and the
> archiving to avoid the scheduler being busy doing
> one thing when it needed
> to be doing something else. They also didn't want
> some things running in
> Oracle's CRON and some by the TSM admin from the
> central scheduler, for
> simplicity's sake.
>
> Just curious how ya'll dealt with this.
>
> thanks
> lisa
>
>
>
> Neil Rasmussen
> <rasmussn AT US DOT IBM. To:
> ADSM-L AT VM.MARIST DOT EDU
> COM> cc:
> Sent by: "ADSM:
> Subject: Re: RMAN error
> Dist Stor
> Manager" <ADSM-
> L AT VM.MARIST DOT EDU>
>
>
> 07/27/2002 12:57
> AM
> Please respond to
> "ADSM: Dist Stor
> Manager"
>
>
>
>
>
>
> I have here our preferred method for starting Rman
> with the TSM Scheduler:
>
> When using the TSM scheduler to automate the TDP
> Oracle backups, the
> differences in how these two clients work must be
> taken into account.
> - The scheduler runs as root and would need
> passwordaccess generate.
> - The TDP Oracle backup runs as an Oracle user and
> need passwordaccess
> prompt.
>
> Since the TDP client requires passwordaccess prompt,
> automating the TSM
> scheduler process on the client machine often
> encounters various issues.
> The following steps should assist with clarifying
> how to setup this type
> of configuration for a working environment.
>
> To setup the TSM Scheduler for the TDP Oracle node,
> it is critical that
> the password for the node on the TSM Server be set
> so that the password
> will not expire. Then setup the TDP Oracle to use
> PasswordAccess prompt
> and setup the TSM Scheduler (for the tdp oracle
> backup) to use
> PasswordAccess generate.
>
> To use only one dsm.sys file, ensure there is a
> symbolic link to this
> single dsm.sys file so it can be seen from the API
> directory (/opt/tivoli/tsm/client/api/bin)
> and the TDP can find and use this dsm.sys.
>
> In this one dsm.sys file, there will normally be
> more than one ServerName
> stanza when using the TDP Oracle on the same
> machine. One ServerName
> stanza for the filesystem backups and another
> ServerName stanza for the
> TDP Oracle backups (which need passwordaccess
> prompt). To assist with
> setting up the TSM Scheduler for the TDP Oracle
> node, you would need to
> create a third ServerName stanza in this dsm.sys
> file.
>
> In general, the dsm.sys file would be similar to the
> following:
> servername TSMbackup
> COMMMETHOD tcpip
> TCPServeraddress xxx.xxx.xxx.xxx
> TCPPORT 1500
> NODENAME Client
> PASSWORDACCESS generate
>
> servername TSMOracle
> COMMMETHOD tcpip
> TCPServeraddress xxx.xxx.xxx.xxx
> TCPPORT 1500
> PASSWORDACCESS prompt
>
> servername TDPSched
> COMMMETHOD tcpip
> TCPServeraddress xxx.xxx.xxx.xxx
> TCPPORT 1500
> NODENAME TDPNode
> PASSWORDACCESS generate
>
>
> You would have three dsm.opt files. One for the
> Backup/Archive client
> that
> would normally be located in the
> /opt/tivoli/tsm/client/ba/bin directory.
> Based on the dsm.sys example above, this would
> contain the line:
> servername TSMbackup
>
> There would be a second dsm.opt file (which could
> have a different
> filename, such as dsmoracle.opt) for the TDP for
> Oracle. Based on the
> dsm.sys example this user option file for the Oracle
> client would contain
> the line:
> servername TSMOracle
> and would have passwordaccess prompt.
>
>
> There would be a third dsm.opt file (which could
> have a different
> filename, such as dsmsched.opt) for the TDP for
> Oracle scheduler. Based
> on the dsm.sys example this user option file for the
> Oracle client would
> contain the line:
> servername TDPSched
> and would have passwordaccess generate and have the
> NodeName for the TDP
> Oracle
> client specified.
>
>
> Environment variables would need to be utilized with
> the Oracle backup to
> point to the user option file. This would be
> specified in the
> TDPO_OPTFILE
> with the DSMI_ORC_CONFIG variable. For example:
> DSMI_ORC_CONFIG
> /opt/tivol/tsm/client/oracle/bin/dsmoracle.opt
>
>
> When starting the TSM Scheduler for the TDP Oracle
> backups, you will need
> to use the -SErvername parameter and specify which
> stanza should be used.
> Based on the example dsm.sys the scheduler command
> would be such as:
> dsmc sched -SE=TDPSched
>
> For the TDP backup, the script file for the command
> schedule backup will
> be
> launched by the scheduler daemon. Then within the
> command script launch
> the
> RMAN backup script.
>
>
>
> Regards,
>
> Neil Rasmussen
> Software Development
> TDP for Oracle
> rasmussn AT us.ibm DOT com
>
>
=====
<P>Thanks,</P>
<P>Manuel J Sanchez</P>
<P>Senior UNIX SA</P>
<P>Assurant Group</P>
<P>(305) 252-7035 x32153</P>
__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
|