在使用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@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 |
SBTTEST测试ORACLE数据库与介质管理软件的连接：等您坐沙发呢！