ITPub博客

首页 > Linux操作系统 > Linux操作系统 > sybase ase 无法备份(backup.log中,提示with error number 109 )

sybase ase 无法备份(backup.log中,提示with error number 109 )

原创 Linux操作系统 作者:msdnchina 时间:2008-12-24 20:54:41 0 删除 编辑

现象描述:

sybase的dump备份备份不了,

环境:win 2k ase115,


d:\sybase为装sybase的目录


查看d:\sybase\install\errorlog,和backup.log,有错误,with   error   number   109   (管道已结束?.   Refer   to   your   operating   system   documentation   for   further   details.  

使用bat备份时(因为sqladv.exe也用不了,提示:非法的win32程序),现象如下:

Microsoft Windows 2000 [Version 5.00.2195]
(C) 版权所有 1985-2000 Microsoft Corp.

C:\Documents and Settings\Administrator>H:

H:\>cd backup

H:\backup>cd 3

H:\backup\3>backup.bat

H:\backup\3>d:\sybase\bin\isql -Usa -P -ih:\backup\3\backup.sql
拒绝访问。

H:\backup\3>backup.bat

H:\backup\3>d:\sybase\bin\isql -Usa -P -ih:\backup\3\backup.sql
Backup Server session id is:  5.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.142.2.74: [0] The 'GetBinaryType' call failed with error number

193 (Cannot get operating system error tex). Refer to your operating system
documentation for further details.
Backup Server: 4.133.2.1: Invalid path or no execute permission for
multibuffering subprocess binary: d:\sybase\bin\sybmbuf.exe
Msg 8009, Level 16, State 1:
Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.

 

解决方法:

找一个机器,装一个ase115的客户端,此机器会形成D:\Sybase\bin\的文件夹,此文件夹下面有三个exe文件,是执行dump database 命令所必须要的。sybmbuf.exe

isql.exe

sqladv.exe

当然了,还有其他的exe文件是运行sybase所必须的,这里不再一一列出,可能是病毒感染时,因为sybase 服务正在使用这些文件,病毒没有感染成功。

 

将以上三个exe文件复制到服务器上的d:\sybase\bin\目录里,再执行bat,就没有问题了

 

H:\backup\3>backup.bat

H:\backup\3>d:\sybase\bin\isql -Usa -P -ih:\backup\3\backup.sql
Backup Server session id is:  8.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'cwbase6083590E9D2' section number 0001
mounted on disk file 'h:\backup\3\cwbase6.dup'
Backup Server: 4.58.1.1: Database cwbase6: 32056 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 109844 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 145816 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 186482 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 214776 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 236230 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 256524 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 285088 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 348304 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 415228 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 450010 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 460482 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 494502 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 528268 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 558818 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 567764 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 592674 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 628744 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 674476 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 692638 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 713840 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 753146 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 767166 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 792382 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 822416 kilobytes DUMPed.

 

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

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

注册时间:2008-07-30

  • 博文量
    498
  • 访问量
    1393831