sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle报错ORA-19511通过SBTTEST工具测试解决问题

时间:2016-11-02 20:27   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 运维DBA反映Oracle数据库报错ORA-19511,结合MOS官方文档分析产生原因和通过SBTTEST工具来简单的测试一下数据库与介质管理层连接是否正常。
在使用TAPE来存放ORACLE数据数据的时候,常常会遇到ORA-19511错误,ORACLE MOS中给也的ORA-19511错误为介质管理层的错误,需要介质管理厂商来处理。其实我们也可以通过SBTTEST工具来简单的测试一下数据库与介质管理层连接是否正常。下面是ORACLE对ORA-19511的说明
All ORA-19511 are indications of media management issues and can be resolved by the vendor. Media management vendors are also responsible for certifying the software against Oracle.

下面在11.2.0.3环境中测试一把,安装了NBU的客户端
[oracle@oracleplus.net tmp]$sbttest sbt_tape
The sbt function pointers are loaded from libobk.so library.
— sbtinit succeeded
— sbtinit (2nd time) succeeded
sbtinit: Media manager supports SBT API version 2.0
sbtinit: Media manager is version 5.0.0.0
sbtinit: vendor description string=Veritas NetBackup for Oracle – Release 7.1 (2011020316)
sbtinit: allocated sbt context area of 8 bytes
sbtinit: proxy copy is supported
— sbtinit2 succeeded
— regular_backup_restore starts …………………………..
— sbtbackup succeeded
write 100 blocks
— sbtwrite2 succeeded
— sbtclose2 succeeded
sbtinfo2: SBTBFINFO_NAME=sbt_tape
sbtinfo2: SBTBFINFO_SHARE=multiple users
sbtinfo2: SBTBFINFO_ORDER=sequential access
sbtinfo2: SBTBFINFO_LABEL=/opt/mhvtl/nbu/orcl9i_1400005832_C1_F1
sbtinfo2: SBTBFINFO_CRETIME=Wed May 14 02:30:32 2014
sbtinfo2: SBTBFINFO_EXPTIME=Sat Jun 14 02:30:32 2014
sbtinfo2: SBTBFINFO_COMMENT=Backup ID : orcl9i_1400005832
sbtinfo2: SBTBFINFO_METHOD=stream
— sbtinfo2 succeeded
— sbtrestore succeeded
file was created by this program:
seed=431410925, blk_size=16384, blk_count=100
read 100 buffers
— sbtread2 succeeded
— sbtclose2 succeeded
— sbtremove2 succeeded
— regular_backup_restore ends …………………………..
MMAPI error from sbtcommand: 7501, Syntax error, space found in key word :

— sbtcommand failed
这里报了7501错误,这个错误可以忽略,symantec官方有相应的文件说明
Issue
Running the Oracle sbttest program with the NetBackup for Oracle agent results in the error noted below. However, backups via RMAN are successful using both scripts and templates. Should this message be of concern

Error
Exact output obtained from sbttest utility:

$ $ORACLE_HOME/bin/sbttest test_s1_p1
The sbt function pointers are loaded from libobk.so library.
— sbtinit succeeded
— sbtinit (2nd time) succeeded
sbtinit: Media manager supports SBT API version x.0
sbtinit: Media manager is version x.0.0.0
sbtinit: vendor description string=VERITAS NetBackup for Oracle – Release x.x GA (00000000)
sbtinit: allocated sbt context area of 0 bytes
sbtinit: proxy copy is supported
— sbtinit2 succeeded
— regular_backup_restore starts …………………………..
— sbtbackup succeeded
write 100 blocks
— sbtwrite2 succeeded
— sbtclose2 succeeded
sbtinfo2: SBTBFINFO_NAME=veritas
sbtinfo2: SBTBFINFO_SHARE=single user
sbtinfo2: SBTBFINFO_ORDER=sequential access
sbtinfo2: SBTBFINFO_LABEL=A00004
sbtinfo2: SBTBFINFO_CRETIME=Sat Aug 31 12:43:07 2002
sbtinfo2: SBTBFINFO_EXPTIME=Sat Sep 7 12:43:07 2002
sbtinfo2: SBTBFINFO_COMMENT=Backup ID : sptsunnb57_1030794187
sbtinfo2: SBTBFINFO_METHOD=stream
— sbtinfo2 succeeded
— sbtrestore succeeded
file was created by this program:
seed=76573757, blk_size=16384, blk_count=100
read 100 buffers
— sbtread2 succeeded
— sbtclose2 succeeded
— sbtremove2 succeeded
— regular_backup_restore ends …………………………..
MMAPI error from sbtcommand: 7501, sbtcommand: Syntax error, space found in key word :
— sbtcommand failed
Environment

Any version of current NetBackup
Any version of current Oracle.
Cause
The sbttest program performs a database, restore, and then requests NetBackup to delete the image. All of these steps are successful.
But then sbttest emulates this RMAN command:
SEND ‘test sbtcommand string’;
The synatx of the string is defined by the MML and not by Oracle. NetBackup does not expect any spaces in the string so it returns a failure to sbttest. See the NetBackup for Oracle Admin Guide for valid SEND syntax examples.
Solution

The sbtcommand failure in the sbttest output can be ignored, it is not a valid test.
Article URL http://www.symantec.com/docs/TECH144225
本文固定链接: http://www.htz.pw/2014/10/29/sbttest%e6%b5%8b%e8%af%95oracle%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%8e%e4%bb%8b%e8%b4%a8%e7%ae%a1%e7%90%86%e8%bd%af%e4%bb%b6%e7%9a%84%e8%bf%9e%e6%8e%a5.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle报错ORA-19511通过SBTTEST工具测试解决问题

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1142.html

Oracle研究中心

关键词:

MMAPI error from sbtcommand: 7501

Oracle报错ORA-19511原因和解决办法

通过SBTTEST工具测试数据库与介质管理层连接是否正常