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
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
COM> cc:
Sent by: "ADSM: Subject: Re: RMAN error
Dist Stor
Manager" <ADSM-
[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
