Label validation error: first label not VOL1.Volume rejected.

1.  问题

1> load database msgdb from "/usr/u/weng/msgdb.cmp"

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.10.2.1: Label validation error: first label not VOL1.

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: /usr/u/weng/msgdb.cmp: volume not valid or not

requested (server: , session id: 5.)

2.解决办法

load database msgdb from "compress::/usr/u/nweng/msgdb.cmp"

3.原因

备份文件是压缩备份的，所以。。。。

This usually indicates that the file is either not an ASE dump file at all, or is a dump file created using the "compress::"  backupserver API module (or some other custom backupserver API module).

诊断办法

On UNIX systems, run the "strings" utility on the dump file and pipe to the "more" utility.  If this is a normal dump file (you might want to compare outputs doing the same thing to some known good dump files), you will typically see about 18 lines of readable text including the values "VOl1", "HDR1", the name of the databse, "HDR2", the name of the database, "EOF1", EOF2", "EOF3", "VOL1", "USTH", and versions strings for an ASE and a Backupserver, followed by some system table names.  (sample output here).

假设备份文件是 "/work/model.dmp"   

Backupserver Normal Strings Output Example

bret-sun2% strings /work/model.dmp | head -30

VOL1                                0                                          7

HDR1model132540832B

000100 13254 13254

Sybase  0832B

HDR2F

Backupserver Compressed Strings Output Example

bret-sun2% strings /work/model.cmp.dmp | head -30

`]Gu7>   H d   ;   ) , K

PbYz

. +PB 4,

ei n_

 ~mJ X? MKX

 I

 9g

  s