15.0 跨平台dump/load error message

entomology

还是没有最终搞定，又出来错误。
从sun solaris 8.0（sybase12.0） dump 出来的数据load到win2000 advanced server（15.0 beta2）出错，具体信息：

11:56:52.203        DBMS        libfish -- Error:  Number (606602) Severity (2) State (1) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\Horizon_BackupData\cnhorizon_dmp2: volume mounted out of order, expected volume 0001, got volume 16777216.
11:56:52.234        DBMS        libfish -- Error:  Number (603602) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.36.2.4: Header labels of rejected volume:
11:56:52.281        DBMS        libfish -- Error:  Number (603402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.34.2.4:
11:56:52.296        DBMS        libfish -- VOL1                                0                                          6
11:56:52.328        DBMS        libfish -- HDR1sunrise0610813592
11:56:52.343        DBMS        libfish -- HDR2F
11:56:52.375        DBMS        libfish -- Error:  Number (101402) Severity (2) State (2) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:52.421        DBMS        libfish -- Error:  Number (603202) Severity (2) State (3) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.32.2.3: D:\sybase\Horizon_BackupData\cnhorizon_dmp2: volume not valid or not requested (server: , session id: 5.)
11:56:52.453        DBMS        libfish -- Error:  Number (101402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:52.484        DBMS        libfish -- Error:  Number (606602) Severity (2) State (1) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\Horizon_BackupData\cnhorizon_dmp1: volume mounted out of order, expected volume 0001, got volume 16777216.
11:56:52.515        DBMS        libfish -- Error:  Number (603602) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.36.2.4: Header labels of rejected volume:
11:56:52.578        DBMS        libfish -- Error:  Number (603402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.34.2.4:
11:56:52.609        DBMS        libfish -- VOL1                                0                                          6
11:56:52.640        DBMS        libfish -- HDR1sunrise0610813592
11:56:52.671        DBMS        libfish -- HDR2F
11:56:52.703        DBMS        libfish -- Error:  Number (101402) Severity (2) State (2) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:52.750        DBMS        libfish -- Error:  Number (606602) Severity (2) State (1) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\Horizon_BackupData\cnhorizon_dmp4: volume mounted out of order, expected volume 0001, got volume 16777216.
11:56:52.796        DBMS        libfish -- Error:  Number (603602) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.36.2.4: Header labels of rejected volume:
11:56:52.843        DBMS        libfish -- Error:  Number (603402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.34.2.4:
11:56:52.875        DBMS        libfish -- VOL1                                0                                          6
11:56:52.906        DBMS        libfish -- HDR1sunrise0610813592
11:56:52.937        DBMS        libfish -- HDR2F
11:56:52.984        DBMS        libfish -- Error:  Number (101402) Severity (2) State (2) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:53.031        DBMS        libfish -- Error:  Number (606602) Severity (2) State (1) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\Horizon_BackupData\cnhorizon_dmp5: volume mounted out of order, expected volume 0001, got volume 16777216.
11:56:53.093        DBMS        libfish -- Error:  Number (603602) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.36.2.4: Header labels of rejected volume:
11:56:53.140        DBMS        libfish -- Error:  Number (603402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.34.2.4:
11:56:53.171        DBMS        libfish -- VOL1                                0                                          6
11:56:53.218        DBMS        libfish -- HDR1sunrise0610813592
11:56:53.250        DBMS        libfish -- HDR2F
11:56:53.312        DBMS        libfish -- Error:  Number (101402) Severity (2) State (2) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:53.359        DBMS        libfish -- Error:  Number (603202) Severity (2) State (3) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.32.2.3: D:\sybase\Horizon_BackupData\cnhorizon_dmp1: volume not valid or not requested (server: , session id: 5.)
11:56:53.421        DBMS        libfish -- Error:  Number (101402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:53.484        DBMS        libfish -- Error:  Number (603202) Severity (2) State (3) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.32.2.3: D:\sybase\Horizon_BackupData\cnhorizon_dmp4: volume not valid or not requested (server: , session id: 5.)
11:56:53.546        DBMS        libfish -- Error:  Number (101402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:53.625        DBMS        libfish -- Error:  Number (603202) Severity (2) State (3) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.32.2.3: D:\sybase\Horizon_BackupData\cnhorizon_dmp5: volume not valid or not requested (server: , session id: 5.)
11:56:53.687        DBMS        libfish -- Error:  Number (101402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:53.765        DBMS        libfish -- Error:  Number (606602) Severity (2) State (1) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\Horizon_BackupData\cnhorizon_dmp3: volume mounted out of order, expected volume 0001, got volume 16777216.
11:56:53.828        DBMS        libfish -- Error:  Number (603602) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.36.2.4: Header labels of rejected volume:
11:56:53.921        DBMS        libfish -- Error:  Number (603402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.34.2.4:
11:56:53.968        DBMS        libfish -- VOL1                                0                                          6
11:56:54.000        DBMS        libfish -- HDR1sunrise0610813592
11:56:54.046        DBMS        libfish -- HDR2F
11:56:54.125        DBMS        libfish -- Error:  Number (101402) Severity (2) State (2) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:54.203        DBMS        libfish -- Error:  Number (603202) Severity (2) State (3) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.32.2.3: D:\sybase\Horizon_BackupData\cnhorizon_dmp3: volume not valid or not requested (server: , session id: 5.)
11:56:54.281        DBMS        libfish -- Error:  Number (101402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:54.375        DBMS        libfish -- Error:  Number (101402) Severity (2) State (2) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:54.453        DBMS        libfish -- Error:  Number (603202) Severity (2) State (3) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 6.32.2.3: D:\sybase\Horizon_BackupData\cnhorizon_dmp0: volume not valid or not requested (server: , session id: 5.)
11:56:54.593        DBMS        libfish -- Error:  Number (101402) Severity (2) State (4) Server (LIBFISH_BS) Procedure (bs_read_header) Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
11:56:54.687        DBMS        libfish -- Error:  Number (8009) Severity (16) State (1) Server (LIBFISH) Error encountered by Backup Server.  Please refer to Backup Server messages for details.

大家帮忙，谢谢了！

echoaix

15不是很清楚，我的理解是在15这个版本不同平台之间的备份可以相互load
可是你从sun solaris 8.0（sybase12.0） dump 出来的数据load到win2000 advanced server（15.0 beta2），应该是不行的

entomology

阿，也就是可能同版本的sybase（15.0）才能跨平台dump/load，郁闷阿

ggpl

跨平台可以试一下dba中的数据迁移功能，不怕麻烦可以用bcp：）

entomology

ggpl 能不能具体讲讲该怎么做？是用第三方的软件吗，我用dbartisan 7.2.1的schema migration功能试过，但是没有成功，只导入了表结构，表数据都没有迁移过来，还有数据库中的user里的用户也都没有拷贝进来，我的操作步骤为：
目标服务器：A
要导入数据库的服务器：B
先在要B上建和A一样的数据库设备，然后建一样的数据库（用sybase sentral的ddl功能得到sql语句），然后用dbartisan 7.2.1的schema migration功能把A中的一个数据库（使用此功能默认勾上的几个选项，没有勾上bcp）导入到B中，导入花了大概一个多小时，中间有很多错误，以下这个错误最多：
11:48:31.531        DBMS        fish -- Number (17231) Severity (16) State (1) Server (FISH) Procedure (sp_adduser) No login with the specified name exists.
还有一个出现频率很高的错误是说从临时目录（导入数据的时候会先从A获取数据到C:\Documents and Settings\fish\Local Settings\Temp这个目录，再把这个临时文件中的数据导入到B数据库）获取数据导入到B数据库时失败。
导入完成后就发现存储过程，表结构，触发器之类的都已经导过来了，就是表里没有数据，还有原来建的用户都没有过来。

不知道有没有讲清楚，大家先帮忙看看吧,3xs

jiangzx

呵呵，可能大家对sybase跨平台的dump/load概念有些误解
sybase所谓的跨平台，是指相同CPU指令集的平台才可以跨
32bit系统和64bit系统是不能跨的
不同指令集CPU系统之间也是不能跨的

entomology

原来是这样，那intel至强的cpu指令集和sun sparc cpu的指令集是不是不一样的？也就是这两个平台是不可能进行跨平台导库的？

donniejeck

我看过一些资料说,12.53可以在不同平台之间互相load/dump.想求证.