HP-UX 上Oracle数据库备份作业若跨带就失败-错误号174

问题

HP-UX 上Oracle数据库备份作业若跨带就失败-错误号174

 

解决方案

症状
脚本输出文件有错误信息：

…

released channel: ch00

released channel: ch01

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ch01 channel at 05/18/2010 15:56:16

ORA-27192: skgfcls: sbtclose2 returned error - failed to close file

ORA-19511: Error received from media manager layer, error text:

Failed to process backup file

ORA-19502: write error on file "bk_19885_1_719337081", blockno 15567361 (blocksize=1024)

ORA-27030: skgfwrt: sbtwrite2 returned error

ORA-19511: Error received from media manager layer, error text:

VxBSASendData: Failed with error:

RMAN> RMAN>

解决方案

一个简单的方法是将当前使用的磁带冻结，强制NetBackup在下次备份时分配新的磁带使用，但此方法无法避免再次跨带时仍出174错误；

另一种方法是调整系统的ntdd的驱动的变量：

/opt/OMImag/bin/atdd_cfg -s TRAILER
/opt/OMImag/bin/atdd_cfg -s TRAILER 1 1 "where 1 is the trailer, and 1 is the first device instance"
例子：
/opt/OMImag/bin/atdd_cfg -s TRAILER 1 2
/opt/OMImag/bin/atdd_cfg -s TRAILER 1 3
/opt/OMImag/bin/atdd_cfg -s TRAILER 1 4
使用下面命令检查确认修改后的值:
/opt/OMImag/bin/atdd_cfg -g TRAILER
例子：
# ./atdd_cfg -g TRAILER 1
TRAILER: 1
# ./atdd_cfg -g TRAILER 2
TRAILER: 1
# ./atdd_cfg -g TRAILER 3
TRAILER: 1
# ./atdd_cfg -g TRAILER 4
TRAILER: 1
建议将上述“/opt/OMImag/bin/atdd_cfg -s TRAILER ”命令放在一个脚本中，使系统在启动时能够执行，以确保此参数在系统重启后仍有效。

References
Oracle backup fails with error code 174 when NetBackup spans tape

https://www.veritas.com/support/en_US/article.000037673