ITPub博客

首页 > 数据库 > Oracle > 通过rman日志诊断磁带库驱动故障

通过rman日志诊断磁带库驱动故障

原创 Oracle 作者:nickzzz 时间:2007-01-02 22:10:22 0 删除 编辑
那天收到的朋友email给我的NBU的cat错误信息,朋友说很是突然的事情而且NBU报6错误,备份失败。[@more@]

发现archivelog日志文件并没有backup并且进行归档。df-k的时候发现已经增长了20%空间。呵呵,erp服务器就是忙啊!

channel ch00: starting piece 1 at 27-DEC-06
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 12/27/2006 03:45:23
ORA-19506: failed to create sequential file, name="bk_ujui5vdcq_s1662_p1_t610252186", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: Communication with the server has not been iniatated or the server status has not been retrieved from the server.

RMAN>

Recovery Manager complete.

检查rman log 发现问题出现在开始备份archivelog的时候,也就是release channel并且create new channel和create sequential file的时候才发生的问题。这说明rman(oracle)和NBU之间的api通讯是正常的,我想问题很有可能发生在NBU调用磁带库api的时候超时或者scsi通讯出现了问题,这一般都是由于线缆、磁带库终结器或者是驱动程序造成的。没有其他scsi线缆和终结器所以尝试升级磁带库驱动程序,重启master服务器。进入NBU启动 normal backup正常 ^_^,schedule backup正常,restore testing ok!问题解决了。^_^

Sun Microsystems Inc. SunOS 5.9 Generic May 2002
$ rman target /

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: PROD (DBID=4270186773)

RMAN> list backup summary;

using target database controlfile instead of recovery catalog

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Tag
------- -- -- - ----------- --------------- ------- ------- ---

1603 B 0 A SBT_TAPE 31-DEC-06 1 1 TAG20061231T011415
1604 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1605 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1606 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1607 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1608 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1609 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1610 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1611 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1612 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1613 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1614 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1615 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1616 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1617 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1618 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1619 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1620 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1621 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1622 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1623 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1624 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1625 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1626 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1627 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1628 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1629 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1630 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1631 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1632 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1633 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1634 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1635 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1636 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1637 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1638 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1639 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1640 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1641 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1642 B A A SBT_TAPE 31-DEC-06 1 1 TAG20061231T021654
1643 B F A SBT_TAPE 31-DEC-06 1 1 TAG20061231T032310
1644 B 0 A SBT_TAPE 01-JAN-07 1 1 TAG20070101T044017
1645 B A A SBT_TAPE 01-JAN-07 1 1 TAG20070101T054415
1646 B A A SBT_TAPE 01-JAN-07 1 1 TAG20070101T054415
1647 B A A SBT_TAPE 01-JAN-07 1 1 TAG20070101T054415
1648 B A A SBT_TAPE 01-JAN-07 1 1 TAG20070101T054415
1649 B A A SBT_TAPE 01-JAN-07 1 1 TAG20070101T054415
1650 B A A SBT_TAPE 01-JAN-07 1 1 TAG20070101T054415
1651 B F A SBT_TAPE 01-JAN-07 1 1 TAG20070101T055424


Nick

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90162/viewspace-888030/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-28

  • 博文量
    25
  • 访问量
    465609