[已结贴]数据移植相关问题求教

entomology

我想把服务器上的sybase数据备份一份到另外一台备份机上，具体信息为：
服务器平台为sun6800 solaris 8，sybase12.0.0.8，
备份机平台为windows 2000 advanced server，sybase12.5。
1 这种情况是不是不可能dump/load，一定要用bcp？如果要dump/load的话备份机换成sybase12.5.3可以吗？或者把备份机的平台换成x86的solaris 10，sybase12.0.0.8是不是可行？
2 我用sp_helpdevice看到服务器上有data1,data2,data3.......data7和datalog这几个设备，每个为2g，然后用sp_helpdb看到data这个数据库的容量为16g。我在备份机上也建立了data1,data2,data3......data7和datalog这几个设备，每个2g，然后建data这个库的时候我应该指定那个设备呢？我指定data1之后，建起来的数据库容量好像不对。
3 看到服务器上master的设备是d_master，这是个什么设备呢？
问题比较多，谢谢大家帮助！！！

[ 本帖最后由 entomology 于 2006-4-20 20:48 编辑 ]

echoaix

1 dump/load不一定不行，sun6800 solaris 8如果是for x86可能可以，行不行应该和你备份机sybase版本没有关系，能不能dump/load主要看sybase基于的平台，字符集和页面大小等

2 建datbase用create database dbname on data1=2048,data2=2048,.... log on datalog=2048 for load 注意如果用dump/load建设备的顺序应该和原来一样，不行就先建database for load 再扩database for load

3 master的设备在sysdevices中就是d_master，master的设备路径是在run文件指定的

entomology

3xs，我先去试试

entomology

数据库建好了，由于dump过来的数据有5个分别为：data_dmp0，data_dmp1,data_dmp2,data_dmp3,data_dmp4，还有一个是log文件
我是用下面这个命令load的（只指定了第一个dump文件），但出错了，不知道是命令有问题还是表明不能跨平台dump/load：
load database fishrise from "D:\sybase\data\data_dmp0"
Server Message:  Number  3216, Severity  10
Line 1:
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.
Server Message:  Number  606602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\data\data_dmp0: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message:  Number  603602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message:  Number  603402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4:  VOL1                                                                           6 HDR1sunrise0610813592 HDR2F
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  603202, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: D:\sybase\data\data_dmp0: volume not valid or not requested (server: , session id: 5.)
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  8009, Severity  16
Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for details.

entomology

发现大于2g的文件要用stripe on命令连接，改了load命令，还是出错，继续求教：
load database fishrise from "D:\sybase\Data\data_dmp0"
stripe on "D:\sybase\Data\data_dmp1"
stripe on "D:\sybase\Data\data_dmp2"
stripe on "D:\sybase\Data\data_dmp3"
stripe on "D:\sybase\Data\data_dmp4"
stripe on "D:\sybase\Data\data_dmp5"



执行后出错

Server Message:  Number  3216, Severity  10
Line 1:
Backup Server session id is:  52.  Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message:  Number  606602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\data\data_dmp0: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message:  Number  603602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message:  Number  603402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4:  VOL1                                                                           6 HDR1sunrise0610813592 HDR2F
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  603202, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: D:\sybase\data\data_dmp0: volume not valid or not requested (server: , session id: 52.)
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  606602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\data\data_dmp1: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message:  Number  603602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message:  Number  603402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4:  VOL1                                                                           6 HDR1sunrise0610813592 HDR2F
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  606602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\data\data_dmp2: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message:  Number  603602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message:  Number  603402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4:  VOL1                                                                           6 HDR1sunrise0610813592 HDR2F
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  606602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\data\data_dmp3: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message:  Number  603602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message:  Number  603402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4:  VOL1                                                                           6 HDR1sunrise0610813592 HDR2F
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  606602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\data\data_dmp4: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message:  Number  603602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message:  Number  603402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4:  VOL1                                                                           6 HDR1sunrise0610813592 HDR2F
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  606602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device D:\sybase\data\data_dmp5: volume mounted out of order, expected volume 0001, got volume 16777216.
Server Message:  Number  603602, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.36.2.4: Header labels of rejected volume:
Server Message:  Number  603402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.34.2.4:  VOL1                                                                           6 HDR1sunrise0610813592 HDR2F
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  603202, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: D:\sybase\data\data_dmp1: volume not valid or not requested (server: , session id: 52.)
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  603202, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: D:\sybase\data\data_dmp2: volume not valid or not requested (server: , session id: 52.)
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  603202, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: D:\sybase\data\data_dmp3: volume not valid or not requested (server: , session id: 52.)
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  603202, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: D:\sybase\data\data_dmp4: volume not valid or not requested (server: , session id: 52.)
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  603202, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.32.2.3: D:\sybase\data\data_dmp5: volume not valid or not requested (server: , session id: 52.)
Server Message:  Number  101402, Severity  2
Server 'LIB_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Server Message:  Number  8009, Severity  16
Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for details.

echoaix

可能是不能dump/load

entomology

我觉得也是这个问题，到时候用第三方软件试试看，3xs-_-