ASE12.5 在AIX上，利用磁带恢复出错，恳求指导

li_lsl

备份数据库zjszyy到磁带上：备份语句为：dump database zjszyy to "compress::/dev/rmt0.1" with init；顺利备份完成。

从磁带上恢复zjszyy：恢复语句为：load database zjszyy_his from "compress::/dev/rmt0.1"，结果出错，输出文件如下：
1> load database zjszyy from "compress::/dev/rmt0.1"
2> go
Backup Server session id is:  83.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::/dev/rmt0.1::00'
Backup Server: 6.28.1.1: Dumpfile name 'zjszyy06066002AF ' section number 1
mounted on byte stream 'compress::/dev/rmt0.1::00'
Backup Server: 4.58.1.1: Database zjszyy: 24710 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 49802 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 74510 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 99218 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 123926 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 148634 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 160988 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 185696 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 210404 kilobytes LOADed.
中间是连续的load信息
Backup Server: 4.58.1.1: Database zjszyy: 35682296 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 35708924 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 35735552 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 35749058 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 35775686 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 35802314 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 35815436 kilobytes LOADed.
Backup Server: 4.58.1.1: Database zjszyy: 35842064 kilobytes LOADed.
Backup Server: 4.124.2.1: Archive API error for
device='compress::/dev/rmt0.1::00': Vendor application name=Compress API,
Library version=1, API routine=syb_read(), Message=
Msg 8009, Level 16, State 1:
Server 'eahisaix1', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.
1> load database zjszyy from "compress::5::/dev/rmt0.1"
2> go
Backup Server session id is:  86.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::5::/dev/rmt0.1::00'
Backup Server: 4.124.2.1: Archive API error for
device='compress::5::/dev/rmt0.1::00': Vendor application name=Compress API,
Library version=1, API routine=syb_read(), Message=
Backup Server: 6.31.2.4: Volume rejected.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD
session must exit.
Backup Server: 6.32.2.3: compress::5::/dev/rmt0.1::00: volume not valid or not
requested (server: , session id: 86.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD
session must exit.
Msg 8009, Level 16, State 1:
Server 'eahisaix1', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.
1>
2>
3>

1017of

just try this:load database zjszyy_his from "/dev/rmt0.1"
I hope there was not device problem went to you.

li_lsl

谢谢1017of

load database zjszyy_his from "/dev/rmt0.1" 这个语句已经试过了，还是出错（因为我的备份是带compress参数的）；过程如下：
1>load database zjszyy from "/dev/rmt0.1"
2> go
Backup Server session id is:  59.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.
Backup Server: 6.32.2.2: /dev/rmt0.1: volume not valid or not requested (server:

, session id: 59.)
Backup Server: 1.14.2.3: Unrecoverable I/O or volume error.  This DUMP or LOAD
session must exit.
Backup Server: 6.32.2.3: /dev/rmt0.1: volume not valid or not requested (server:

, session id: 59.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD
session must exit.
Msg 8009, Level 16, State 1:
Server 'eahisaix1', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.

1017of

just once again:load database zjszyy_his from "compress::/dev/rmt0.1"

li_lsl

你好，1017of
load database zjszyy_his from "compress::/dev/rmt0.1"
我在第一个提问中，就是用这个语句的，结果出错

1017of

don't worry,just try once again.
then try to tar some files to and from another tape,to confirm where could be some matters.

li_lsl

好的，我再试试，我也考虑过是不是磁带的问题，所以买了10盒新磁带来测试。（屏蔽掉磁带损坏的可能）

Eisen

"compress::/dev/rmt0.1"这句话就有错,dump的时候compress是只能用在备份成文件模式的时候,而且语法也是"compress::[压缩级数]::[备份目标文件名]"。照你一开始的命令，一开始做的dump应该就已经是坏的了，那么之后的恢复应该也不可能恢复出来才是。

1017of

according to reference from technical library of sybase,[compress::[compression_level::]] is an option of command dump database.it is hard to say dump database xxx to "compress::/xxxxxxx" could has solecism.
I did not find any describtion for compress option has limit to file system,so I had no idea of it.
as load-log shown,I prefered some device error could block the load procedure.of course no explicit evidence supported me,so more actions should be necessary.

li_lsl

Eisen  你好！ 谢谢您的帮助。

compress的语法是"compress::[压缩级数]::[备份目标文件名]"，但是“压缩级数”可以不加，此时ASE有一个默认的“压缩级数”；因为同样的备份语句，备份数据库zjszyy到本地磁盘上：备份语句为：dump database zjszyy to "compress::/sybase_db/zjszyy20060307.dmp"；顺利备份完成 。从磁盘上恢复zjszyy：恢复语句为：load database zjszyy from "compress::/sybase/zjszyy20060307.dmp"，恢复顺利完成 。

主要是在磁带上的备份和恢复有问题。