当前位置: 首页 > BACKUP & RESTORE, ORACLE > 正文

SBTTEST测试ORACLE数据库与介质管理软件的连接

          在使用TAPE来存放ORACLE数据数据的时候,常常会遇到ORA-19511错误,ORACLE MOS中给也的ORA-19511错误为介质管理层的错误,需要介质管理厂商来处理。其实我们也可以通过SBTTEST工具来简单的测试一下数据库与介质管理层连接是否正常。下面是ORACLEORA-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@www.htz.pw 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 : <test sbtcommand string>

 

— 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 : <test sbtcommand string>

— 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 | 认真就输

该日志由 huangtingzhong 于2014年10月29日发表在 BACKUP & RESTORE, ORACLE 分类下, 通告目前不可用,你可以至底部留下评论。
原创文章转载请注明: SBTTEST测试ORACLE数据库与介质管理软件的连接 | 认真就输
关键字: , ,