Tivoli Data Protection for Oracle (TDPO) - Revision history

Stuart: /* Problem: */

2015-06-01T14:27:14Z

‎Problem:

Stuart: /* Troubleshooting */

2015-06-01T14:26:39Z

‎Troubleshooting

Stuart: /* Files involved */

2014-08-12T11:26:24Z

‎Files involved

Stuart: /* Setting up DataPump to backup directly to tape */

2014-08-12T11:24:19Z

‎Setting up DataPump to backup directly to tape

Stuart: /* Troubleshooting */

2014-06-08T09:29:43Z

‎Troubleshooting

Stuart: /* Troubleshooting */

2014-06-07T15:56:58Z

‎Troubleshooting

Stuart: /* Troubleshooting */

2014-06-07T15:24:33Z

‎Troubleshooting

Stuart: /* Troubleshooting */

2014-06-07T15:17:08Z

‎Troubleshooting

Stuart: /* Troubleshooting */

2014-06-07T15:10:51Z

‎Troubleshooting

Stuart: /* Other */

2014-06-07T15:05:29Z

‎Other

@@ Line 438: / Line 438: @@
 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
+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 # !
 <pre>
@@ Line 444: / Line 444: @@
 chmod 777 /home/ibmtools/logs/rman/tdpoerror_APITSMP3/tdpoerror.log
 </pre>
 ===='''Problem:'''====
 <pre>

@@ Line 353: / Line 353: @@
 </pre>
-'''Problem:'''
+===='''Problem:'''====
 <pre>
 RMAN-00571: ===========================================================
@@ Line 373: / Line 373: @@
 </pre>
-'''Problem:'''
+===='''Problem:'''====
 <pre>
 Starting backup at 06-JUN-2014 15:43:34
@@ Line 401: / Line 401: @@
 </pre>
-'''Problem:'''
+===='''Problem:'''====
 <pre>
 RMAN-00571: ===========================================================
@@ Line 419: / Line 419: @@
 chmod 644 dsm.sys
 </pre>
-'''Problem:'''
+===='''Problem:'''====
 <pre>
 RMAN-00571: ===========================================================
@@ Line 434: / Line 434: @@
 '''Solution:'''<br />
 Configuration error!<br />
-Check the dsm.opt, tdpo.opt and dsm.sys files. Compare them with a system that works.<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
 <pre>
 chown oraibm:dba /home/ibmtools/logs/rman/tdpoerror_APITSMP3
 chmod 777 /home/ibmtools/logs/rman/tdpoerror_APITSMP3/tdpoerror.log
 </pre>
-'''Problem:'''
+===='''Problem:'''====
 <pre>
 # RMAN-00571: ===========================================================
@@ Line 459: / Line 460: @@
 chmod 755  libobk.a
 </pre>
-'''Problem:'''
+===='''Problem:'''====
 <pre>
 # RMAN-00571: ===========================================================

@@ Line 61: / Line 61: @@
 <pre>
-scrbdbsbeant311:root[/home/ibmtools/scripts/rman]# cat tdpo_SINTP1.opt
+cat tdpo_SINTP1.opt  # PROMPT
 DSMI_ORC_CONFIG    /oracle/SINTP1/admin/dsm.opt
 DSMI_LOG           /home/ibmtools/logs/rman/tdpoerror_SINTP1
@@ Line 69: / Line 69: @@
 *tdpo_trace_flags orclevel0 orclevel1 orclevel2
 *tdpo_trace_file   /home/ibmtools/logs/rman/tdpo_SINTP1.out
 </pre>

@@ Line 13: / Line 13: @@
 * dsm.sys
-By default dsm.sys is located in /usr/tivoli/tsm/client/ba/bin64
+By default dsm.sys is located in /usr/tivoli/tsm/client/ba/bin64<br />
+An example using PROMPT
 <pre>
 SErvername                 TSM_SINTP1_TDPO
@@ Line 38: / Line 37: @@
     DIRMC                   D01NOS_T1
 </pre>
+An example using GENERATE
 <pre>

@@ Line 322: / Line 322: @@
     allocate channel t1 type 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';	(or wherever your optfile is)
+}
 </pre>

@@ Line 320: / Line 320: @@
 <pre>
 run {
-    allocate channel t1 type 'sbt_tape' parms 'env=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';	(or wherever your optfile is)
+    allocate channel t1 type 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';	(or wherever your optfile is)
+}
 </pre>
@@ Line 405: / Line 405: @@
 chmod ug+rwx dsmerror.log
 </pre>
 ===Other===
 * Check results from:

@@ Line 352: / Line 352: @@
 </pre>
 ===Other===
 * 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.