Chinaunix

标题: 磁带加compress压缩参数备份，无法load恢复，请高手帮忙！！ [打印本页]

作者: sigposson 时间: 2006-09-01 11:37
标题: 磁带加compress压缩参数备份，无法load恢复，请高手帮忙！！
我在AIX5L和Redhat Linux AS3.0下都遇到类似的问题

sybase ASE的版本是12.5.3的:

Adaptive Server Enterprise/12.5.3/EBF 13332 ESD#7/P/Linux Intel/Enterprise Linux/ase1253/1951/32-bit/OPT/Fri Mar 24

00:40:52 2006

用的是IBM原配的20G磁带机，我们只有20G磁带。
备份的时候由于库数据虽只有27G，也无法直接备份，所以我当时直接用了compress压缩参数，

例如：Linux平台命令如下

dump database shop to "compress::6::/dev/nst0" with init

执行后显示备份成功，从日志里也反映出来：
Aug 27 18:34:27 2006: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/dev/nst0::00'
Aug 27 18:34:27 2006: Backup Server: 6.28.1.1: Dumpfile name 'shop0623910532 ' section number 1 mounted on byte stream

'compress::6::/dev/nst0::00'
Aug 27 18:35:29 2006: Backup Server: 4.58.1.1: Database shop: 262224 kilobytes DUMPed.
Aug 27 18:36:25 2006: Backup Server: 4.58.1.1: Database shop: 522882 kilobytes DUMPed.
Aug 27 18:37:30 2006: Backup Server: 4.58.1.1: Database shop: 783540 kilobytes DUMPed.
Aug 27 18:38:29 2006: Backup Server: 4.58.1.1: Database shop: 1044198 kilobytes DUMPed.
Aug 27 18:39:28 2006: Backup Server: 4.58.1.1: Database shop: 1303436 kilobytes DUMPed.
Aug 27 18:40:28 2006: Backup Server: 4.58.1.1: Database shop: 1562078 kilobytes DUMPed.
Aug 27 18:41:37 2006: Backup Server: 4.58.1.1: Database shop: 1828684 kilobytes DUMPed.
Aug 27 18:42:48 2006: Backup Server: 4.58.1.1: Database shop: 2089342 kilobytes DUMPed.
Aug 27 18:43:57 2006: Backup Server: 4.58.1.1: Database shop: 2350000 kilobytes DUMPed.
Aug 27 18:45:06 2006: Backup Server: 4.58.1.1: Database shop: 2605186 kilobytes DUMPed.
Aug 27 18:46:07 2006: Backup Server: 4.58.1.1: Database shop: 2863840 kilobytes DUMPed.
Aug 27 18:47:04 2006: Backup Server: 4.58.1.1: Database shop: 3124304 kilobytes DUMPed.
Aug 27 18:48:07 2006: Backup Server: 4.58.1.1: Database shop: 3384610 kilobytes DUMPed.
Aug 27 18:49:03 2006: Backup Server: 4.58.1.1: Database shop: 3648738 kilobytes DUMPed.
Aug 27 18:50:01 2006: Backup Server: 4.58.1.1: Database shop: 3906072 kilobytes DUMPed.
Aug 27 18:51:04 2006: Backup Server: 4.58.1.1: Database shop: 4168854 kilobytes DUMPed.
Aug 27 18:52:07 2006: Backup Server: 4.58.1.1: Database shop: 4428494 kilobytes DUMPed.
Aug 27 18:53:10 2006: Backup Server: 4.58.1.1: Database shop: 4689940 kilobytes DUMPed.
Aug 27 18:54:17 2006: Backup Server: 4.58.1.1: Database shop: 4951484 kilobytes DUMPed.
Aug 27 18:55:35 2006: Backup Server: 4.58.1.1: Database shop: 5208670 kilobytes DUMPed.
Aug 27 18:56:48 2006: Backup Server: 4.58.1.1: Database shop: 5471372 kilobytes DUMPed.
Aug 27 18:57:58 2006: Backup Server: 4.58.1.1: Database shop: 5730028 kilobytes DUMPed.
Aug 27 18:58:58 2006: Backup Server: 4.58.1.1: Database shop: 5991992 kilobytes DUMPed.
Aug 27 18:59:54 2006: Backup Server: 4.58.1.1: Database shop: 6253272 kilobytes DUMPed.
Aug 27 19:00:52 2006: Backup Server: 4.58.1.1: Database shop: 6514444 kilobytes DUMPed.
Aug 27 19:01:51 2006: Backup Server: 4.58.1.1: Database shop: 6772140 kilobytes DUMPed.
Aug 27 19:02:58 2006: Backup Server: 4.58.1.1: Database shop: 7029812 kilobytes DUMPed.
Aug 27 19:04:13 2006: Backup Server: 4.58.1.1: Database shop: 7294054 kilobytes DUMPed.
Aug 27 19:05:36 2006: Backup Server: 4.58.1.1: Database shop: 7554150 kilobytes DUMPed.
Aug 27 19:06:54 2006: Backup Server: 4.58.1.1: Database shop: 7814972 kilobytes DUMPed.
Aug 27 19:08:06 2006: Backup Server: 4.58.1.1: Database shop: 8072866 kilobytes DUMPed.
Aug 27 19:09:17 2006: Backup Server: 4.58.1.1: Database shop: 8337360 kilobytes DUMPed.
Aug 27 19:10:32 2006: Backup Server: 4.58.1.1: Database shop: 8591824 kilobytes DUMPed.
Aug 27 19:11:57 2006: Backup Server: 4.58.1.1: Database shop: 8859146 kilobytes DUMPed.
Aug 27 19:13:14 2006: Backup Server: 4.58.1.1: Database shop: 9119804 kilobytes DUMPed.
Aug 27 19:14:29 2006: Backup Server: 4.58.1.1: Database shop: 9380462 kilobytes DUMPed.
Aug 27 19:15:39 2006: Backup Server: 4.58.1.1: Database shop: 9641120 kilobytes DUMPed.
Aug 27 19:16:38 2006: Backup Server: 4.58.1.1: Database shop: 9901778 kilobytes DUMPed.
Aug 27 19:17:36 2006: Backup Server: 4.58.1.1: Database shop: 10153508 kilobytes DUMPed.
Aug 27 19:18:38 2006: Backup Server: 4.58.1.1: Database shop: 10414166 kilobytes DUMPed.
Aug 27 19:19:39 2006: Backup Server: 4.58.1.1: Database shop: 10674824 kilobytes DUMPed.
Aug 27 19:20:33 2006: Backup Server: 4.58.1.1: Database shop: 10935482 kilobytes DUMPed.
Aug 27 19:21:28 2006: Backup Server: 4.58.1.1: Database shop: 11196140 kilobytes DUMPed.
Aug 27 19:22:20 2006: Backup Server: 4.58.1.1: Database shop: 11456798 kilobytes DUMPed.
Aug 27 19:23:13 2006: Backup Server: 4.58.1.1: Database shop: 11717456 kilobytes DUMPed.
Aug 27 19:24:13 2006: Backup Server: 4.58.1.1: Database shop: 11978114 kilobytes DUMPed.
Aug 27 19:25:13 2006: Backup Server: 4.58.1.1: Database shop: 12238772 kilobytes DUMPed.
Aug 27 19:26:17 2006: Backup Server: 4.58.1.1: Database shop: 12499430 kilobytes DUMPed.
Aug 27 19:27:18 2006: Backup Server: 4.58.1.1: Database shop: 12760088 kilobytes DUMPed.
Aug 27 19:28:21 2006: Backup Server: 4.58.1.1: Database shop: 13020746 kilobytes DUMPed.
Aug 27 19:29:18 2006: Backup Server: 4.58.1.1: Database shop: 13281404 kilobytes DUMPed.
Aug 27 19:30:20 2006: Backup Server: 4.58.1.1: Database shop: 13542062 kilobytes DUMPed.
Aug 27 19:31:16 2006: Backup Server: 4.58.1.1: Database shop: 13802720 kilobytes DUMPed.
Aug 27 19:32:11 2006: Backup Server: 4.58.1.1: Database shop: 14063378 kilobytes DUMPed.
Aug 27 19:33:08 2006: Backup Server: 4.58.1.1: Database shop: 14324036 kilobytes DUMPed.
Aug 27 19:34:03 2006: Backup Server: 4.58.1.1: Database shop: 14584694 kilobytes DUMPed.
Aug 27 19:35:01 2006: Backup Server: 4.58.1.1: Database shop: 14845352 kilobytes DUMPed.
Aug 27 19:36:00 2006: Backup Server: 4.58.1.1: Database shop: 15106010 kilobytes DUMPed.
Aug 27 19:36:57 2006: Backup Server: 4.58.1.1: Database shop: 15366668 kilobytes DUMPed.
Aug 27 19:37:53 2006: Backup Server: 4.58.1.1: Database shop: 15627326 kilobytes DUMPed.
Aug 27 19:38:54 2006: Backup Server: 4.58.1.1: Database shop: 15887984 kilobytes DUMPed.
Aug 27 19:39:52 2006: Backup Server: 4.58.1.1: Database shop: 16148642 kilobytes DUMPed.
Aug 27 19:40:52 2006: Backup Server: 4.58.1.1: Database shop: 16409300 kilobytes DUMPed.
Aug 27 19:41:51 2006: Backup Server: 4.58.1.1: Database shop: 16669958 kilobytes DUMPed.
Aug 27 19:42:44 2006: Backup Server: 4.58.1.1: Database shop: 16930616 kilobytes DUMPed.
Aug 27 19:43:38 2006: Backup Server: 4.58.1.1: Database shop: 17191274 kilobytes DUMPed.
Aug 27 19:44:32 2006: Backup Server: 4.58.1.1: Database shop: 17449430 kilobytes DUMPed.
Aug 27 19:45:22 2006: Backup Server: 4.58.1.1: Database shop: 17709404 kilobytes DUMPed.
Aug 27 19:46:17 2006: Backup Server: 4.58.1.1: Database shop: 17969378 kilobytes DUMPed.
Aug 27 19:47:03 2006: Backup Server: 4.58.1.1: Database shop: 18229352 kilobytes DUMPed.
Aug 27 19:48:05 2006: Backup Server: 4.58.1.1: Database shop: 18489326 kilobytes DUMPed.
Aug 27 19:49:13 2006: Backup Server: 4.58.1.1: Database shop: 18749300 kilobytes DUMPed.
Aug 27 19:50:23 2006: Backup Server: 4.58.1.1: Database shop: 19009274 kilobytes DUMPed.
Aug 27 19:51:35 2006: Backup Server: 4.58.1.1: Database shop: 19269248 kilobytes DUMPed.
Aug 27 19:52:46 2006: Backup Server: 4.58.1.1: Database shop: 19529222 kilobytes DUMPed.
Aug 27 19:53:47 2006: Backup Server: 4.58.1.1: Database shop: 19789196 kilobytes DUMPed.
Aug 27 19:54:34 2006: Backup Server: 4.58.1.1: Database shop: 20049170 kilobytes DUMPed.
Aug 27 19:55:18 2006: Backup Server: 4.58.1.1: Database shop: 20309144 kilobytes DUMPed.
Aug 27 19:56:10 2006: Backup Server: 4.58.1.1: Database shop: 20569118 kilobytes DUMPed.
Aug 27 19:57:09 2006: Backup Server: 4.58.1.1: Database shop: 20829092 kilobytes DUMPed.
Aug 27 19:57:50 2006: Backup Server: 4.58.1.1: Database shop: 21089066 kilobytes DUMPed.
Aug 27 19:58:38 2006: Backup Server: 4.58.1.1: Database shop: 21349040 kilobytes DUMPed.
Aug 27 19:59:33 2006: Backup Server: 4.58.1.1: Database shop: 21616782 kilobytes DUMPed.
Aug 27 20:00:23 2006: Backup Server: 4.58.1.1: Database shop: 21877566 kilobytes DUMPed.
Aug 27 20:01:26 2006: Backup Server: 4.58.1.1: Database shop: 22129548 kilobytes DUMPed.
Aug 27 20:02:16 2006: Backup Server: 4.58.1.1: Database shop: 22390080 kilobytes DUMPed.
Aug 27 20:02:53 2006: Backup Server: 4.58.1.1: Database shop: 22650864 kilobytes DUMPed.
Aug 27 20:03:33 2006: Backup Server: 4.58.1.1: Database shop: 22911396 kilobytes DUMPed.
Aug 27 20:04:13 2006: Backup Server: 4.58.1.1: Database shop: 23172180 kilobytes DUMPed.
Aug 27 20:04:58 2006: Backup Server: 4.58.1.1: Database shop: 23432712 kilobytes DUMPed.
Aug 27 20:05:43 2006: Backup Server: 4.58.1.1: Database shop: 23693496 kilobytes DUMPed.
Aug 27 20:06:20 2006: Backup Server: 4.58.1.1: Database shop: 23954028 kilobytes DUMPed.
Aug 27 20:06:54 2006: Backup Server: 4.58.1.1: Database shop: 24214812 kilobytes DUMPed.
Aug 27 20:07:28 2006: Backup Server: 4.58.1.1: Database shop: 24475344 kilobytes DUMPed.
Aug 27 20:08:05 2006: Backup Server: 4.58.1.1: Database shop: 24736128 kilobytes DUMPed.
Aug 27 20:08:48 2006: Backup Server: 4.58.1.1: Database shop: 24996660 kilobytes DUMPed.
Aug 27 20:09:30 2006: Backup Server: 4.58.1.1: Database shop: 25257444 kilobytes DUMPed.
Aug 27 20:10:16 2006: Backup Server: 4.58.1.1: Database shop: 25517976 kilobytes DUMPed.
Aug 27 20:11:19 2006: Backup Server: 4.58.1.1: Database shop: 25778760 kilobytes DUMPed.
Aug 27 20:12:27 2006: Backup Server: 4.58.1.1: Database shop: 26039292 kilobytes DUMPed.
Aug 27 20:13:27 2006: Backup Server: 4.58.1.1: Database shop: 26300076 kilobytes DUMPed.
Aug 27 20:14:23 2006: Backup Server: 4.58.1.1: Database shop: 26560608 kilobytes DUMPed.
Aug 27 20:15:20 2006: Backup Server: 4.58.1.1: Database shop: 26821392 kilobytes DUMPed.
Aug 27 20:15:59 2006: Backup Server: 3.43.1.1: Dump phase number 1 completed.
Aug 27 20:16:00 2006: Backup Server: 3.43.1.1: Dump phase number 2 completed.
Aug 27 20:16:05 2006: Backup Server: 3.43.1.1: Dump phase number 3 completed.
Aug 27 20:16:05 2006: Backup Server: 4.58.1.1: Database shop: 27049532 kilobytes DUMPed.
Aug 27 20:16:05 2006: Backup Server: 3.42.1.1: DUMP is complete (database shop).

第二天，当数据库出现故障，在同一机器上（操作系统，数据库没有任何更改）用load进行恢复时，始终不能够成功。命令如下

1> load database shop from "compress::6::/dev/nst0"
2> go
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.132.1.1: Attempting to open byte stream device:
'compress::6::/dev/nst0::00'
Backup Server: 6.28.1.1 : Dumpfile name 'shop0623910532 ' section number 1
mounted on byte stream 'compress::6::/dev/nst0::00'
Backup Server: 4.124.2.1: Archive API error for
device='compress::6::/dev/nst0::00': Vendor application name=Compress API,
Library version=1, API routine=syb_read(), Message=
Msg 8009, Level 16, State 1:
Server 'shopdb', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.
1> Aug 31 23:48:30 2006 Backup Server: 6.32.2.3: compress::6::/dev/nst0::00: vol
ume not valid or not requested (server: , session id: 5.)
Aug 31 23:48:30 2006 Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
  This DUMP or LOAD session must exit.

首先，可以排除磁带坏的可能，因为所有磁带都报这个错，而且仅距离备份成功10几个小时。
其次，我专门咨询过sybase客户服务和技术支持，说可以支持磁带加compress参数进行备份

我尝试多很多种方法：
1.用不同的load语句，包括加with file="shop0623910532",或不加compress选项
2.在RUN_shopdb_back里面加上“-D32”参数启动
3.其它方式

都不能解决，在AIX平台也遇到类似问题。但可以确定磁带里有内容，因为加with headeronly可以看到这个文件。

实在无可奈何了，有哪位高手解决过这一类似问题，请不吝指教，先谢了！！这个磁带数据非常重要，因为硬盘备份坏掉了。

作者: RS9000 时间: 2006-09-01 16:09
Do not use the compression_level variable for the load command.

load database shop from "compress::/dev/nst0"

作者: sigposson 时间: 2006-09-01 16:46
标题: 还是不成,
执行了未加级别的compress还是一样,

1> load database shop from "compress::/dev/nst0"
2> go
Backup Server session id is:  14.  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/nst0::00'
Backup Server: 6.28.1.1: Dumpfile name 'shop0623910532 ' section number 1
mounted on byte stream 'compress::/dev/nst0::00'
Backup Server: 4.124.2.1: Archive API error for
device='compress::/dev/nst0::00': Vendor application name=Compress API, Library
version=1, API routine=syb_read(), Message=
Msg 8009, Level 16, State 1:
Server 'shopdb', Line 2:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.
1> Sep  1 16:37:37 2006 Backup Server: 6.32.2.3: compress::/dev/nst0::00: volume
not valid or not requested (server: , session id: 14.)
Sep  1 16:37:37 2006 Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.
  This DUMP or LOAD session must exit.

作者: fieldchen 时间: 2006-09-03 14:28
因为磁带自身就带压缩的了，所以不能加压缩参数。只要在dump的时候把CAPACITY值扩大一些就可以了，因为IBM磁带机压缩后可以放40G的东西，试试

作者: RS9000 时间: 2006-09-04 10:09
楼主搞定了美

作者: sigposson 时间: 2006-09-04 15:57
标题: 被迫用其它方式
最后不用sybase的load命令了，直接用
mt -f /dev/nst0 fsf 1 （跳过master的备份文件）
dd if=/dev/nst0 of=/shop.dump bs=512k

bs参数小了还不行。至少256k。

把文件从磁带机读出来了，load这个文件shop.dump最后不成功，检查日志发现说时间戳不对。数据库不能checkpoint，但能在紧急模式下能够读出数据，已经用bcp把数据导出来了。

谢谢各位关注

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)