This is an old revision of the document!
Table of Contents
Tivoli_Data_Protection_for_Oracle_(TDPO)
'work in progress'
Setting up RMAN to backup directly to tape
RMAN cannot backup directly to tape due to there being many different tape backup suppliers.<br /> The solution is the TDPO interface to which tape suppliers supply parameters. RMAN then knows what to do.
Files involved
- dsm.sys
- dsm.opt
- tdpo.opt
Setting up DataPump to backup directly to tape
Files involved
- dsm.sys
By default dsm.sys is located in /usr/tivoli/tsm/client/ba/bin64<br /> An example using PROMPT
0@@
An example using GENERATE
1@@
2@@
or
3@@
From yannickjaquier.com
RMAN configuration with Tivoli Data Protection for Oracle (TDPO)
tdpo is generally installed in either /opt/tivoli/tsm or /usr/tivoli/tsm<br /> The configuration and testing described in this document have been done on Red Hat Enterprise Linux Server release 5.5 (Tikanga) 64 bits with Oracle 11gR2 (11.2.0.2.0) and 10gR2 (10.2.0.5.0).<br /> First let you preferred system administrator install the product for you, you should find it in:<br />
4@@
The Tivoli Storage Manager (TSM) server configuration part is in:
5@@
The TSM client configuration (TDPO) part is in:
6@@
TSM Configuration
Configuration is made of four files:
7@@
Create the password file to be able to access to TSM server:
8@@
This command create the following password file:
9@@
Verify all is fine with:
10@@
Oracle Configuration
The Oracle configuration is quite simple, you just need to create a symbolic link on TDPO library in all your $ORACLE_HOME/lib directory:
11@@
Then ensure dba Unix group (better to provide access to DBA group in case you have multiple Oracle accounts on your server) is able to write in all log files you defined in all TSM configuration files and be able to read tdpo.opt configuration file.
With Unix commands it gives something like:
12@@
All errors I personally encountered were linked to missing rights on either log files (write permission) and read rights on configuration files. Don’t be too generous while giving those rights…
And that’s it ! You are done, you can test all is working with (even before starting RMAN):
13@@
RMAN backup
I’m not entering in all options of powerful RMAN command but below simple script will perform your first tape backup:
14@@
Troubleshooting
This has to work first.<br /> If this doesn't work, nothing will.
15@@
**Problem:**
16@@
Solution:
17@@
**Problem:**
18@@
Solution:
19@@
**Problem:**
20@@
Solution:
21@@
**Problem:**
22@@
Solution:<br /> Configuration error!<br /> Check the dsm.opt, tdpo.opt, inclexcl.lst and dsm.sys files. Compare them with a system that works.<br /> Found my error in dsm.sys:<br /> Name of the tsm server was wrong and I removed the line “ COMMmethod TCPIP” as it was not in the stanza that worked for another database.<br /> Check the parameter DSMI_LOG in tdpo.opt file<br /> Make sure that the directory it points to (and its files) is writeable by the user doing the work<br /> Remember TSM comments are * not # !
23@@
**Problem:**
24@@
Solution:
25@@
**Problem:**
26@@
Solution:
27@@
Other
- Check results from:
28@@
- Check the logs you'll find in directory pointed by the parameter DSMI_LOG in your tdpo confirguration file. The file is tdpoerror.log. There is also a trace file generated in user_dump_dest.
- Check you have a file agent.lic in opt/tivoli/tsm/client/oracle/bin64 directory.
References
- Installation de Tivoli Data Protection pour Oracle by albanlepunk
- Tivoli Storage Manager client node lacks authority to delete backup copies
- Oracle RMAN 11g Backup and Recovery