讯享网

 <span id="Label3"><p><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">环境：AIX系统的ORACLE 10g</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">&nbsp; &nbsp; &nbsp; TSM5.4</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">&nbsp; &nbsp; &nbsp; IBM带库LIB3584</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);"><br /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">问题原因：</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">迁移数据库后，在新数据库所在操作系统中重新部署TSM ba Client并开启dsmc schedule进程后</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">q event * *&nbsp;</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">发现今日调度任务中，有一个调度failed 126</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);"><br /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">问题分析：</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">1. 因为报错不是miss，判断不是因为没有调度，而是进行了调度而没有调度成功。</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">2. 进一步根据TSM actlog日志分析原因，发现结果如下：</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);"><span style="background-color:rgb(112,48,160);"><strong>日期／时间: 1/16/2015 1:05:38<br />&nbsp; &nbsp; &nbsp; 消息: ANR2579E 节点 ORA_DBS01 的域 ORA_TAPE 的调度 DATE.SH 失败（返回码 126）。 (会话: 88)</strong></span></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">3. Oracle RMAN中的日志报错为：</p><p><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">using target database control file instead of recovery catalog</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">RMAN-00571: ===========================================================</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">RMAN-00571: ===========================================================</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">RMAN-03009: failure of allocate command on t1 channel at 10/13/2009 09:47:43</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">ORA-19554: error allocating device, device type: SBT_TAPE, device name:&nbsp;</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">IBM AIX RISC System/6000 Error: 106: Reserved errno was encountered</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">Additional information: 7011</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">ORA-19511: Error received from media manager layer, error text:</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">&nbsp; &nbsp;SBT error = 7011, errno = 106, sbtopen: system error</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">Recovery Manager complete.</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">&nbsp;</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">4. 确认TSM BA客户端的配置文件是否正确</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">TSM 的五个配置文件</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">/usr/tivoli/tsm/client/ba/bin64/dsm.sys</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">/usr/tivoli/tsm/client/ba/bin64/dsm.opt<br /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">/usr/tivoli/tsm/client/api/bin64/dsm.sys</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">/usr/tivoli/tsm/client/api/bin64/dsm.opt<br /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">都配置正确。</p><p><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">5. 确认以下路径是否有oracle权限（因为RMAN脚本中需要调用）</span></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt<br /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">以及文件中以下内容</p><p><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">DSMI_ORC_CONFIG &nbsp; &nbsp;/usr/tivoli/tsm/client/oracle/bin64/dsm.opt</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">DSMI_LOG &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /usr/tivoli/tsm/client/oracle/bin</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">TDPO_NODE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ORA_DBS01</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /><span style="font-family:Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);">TDPO_PSWDPATH &nbsp; &nbsp; &nbsp;/usr/tivoli/tsm/client/oracle/bin64</span><br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);"><br /></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">结果：</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">这些目录都是root权限</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">修改权限</p><p><span style="background-color:rgb(112,48,160);font-family:Arial, Helvetica, sans-serif;font-size:12px;">chown -R &nbsp;oracle:dba &nbsp;/usr/tivoli/tsm/client/oracle/bin<br style="font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);" /></span></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);"><span style="background-color:rgb(112,48,160);">chown -R /usr/tivoli/tsm/client/oracle/bin</span></p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);">再次调度成功。。。</p><p style="margin-top:4px;margin-bottom:4px;padding:2px 0px;font-family:Arial, Helvetica, sans-serif;font-size:12px;white-space:normal;background-color:rgb(255,255,255);"><br /></p><p><br /></p><p>本文出自 “丶Only” 博客，谢绝转载！</p><p>TSM-ANR2579E ORA-19511（Oracle 备份）</p></span>