Re: RMAN error
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
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
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
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:
You would have three dsm.opt files. One for the Backup/Archive client
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:
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
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:
and would have passwordaccess generate and have the NodeName for the TDP
Environment variables would need to be utilized with the Oracle backup to
point to the user option file. This would be specified in the
with the DSMI_ORC_CONFIG variable. For example:
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
launched by the scheduler daemon. Then within the command script launch
RMAN backup script.
TDP for Oracle
rasmussn AT us.ibm DOT com