求助！sybase load问题，恢复失败

[daefiysq]

环境：
A主机----AIX 6.1
B主机----Red Hat Linux 5.4
数据库版本：sybase ASE 12.5
问题描述：迁移数据库，从A主机迁移到B主机，在B主机上创建好了数据库，配置和A一致
在A上dump数据库，日志如下：
====2013-01-15 04:30:00 begin backup====
Backup Server session id is: 30. 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::/sybasedata/sybasebak/SMGP_SERVER20130115.dmp.gz::00'
Backup Server: 6.28.1.1: Dumpfile name '_SERVER1301503F49' section number 1
mounted on byte stream
'compress::/sybasedata/sybasebak/SMGP_SERVER20130115.dmp.gz::00'
Backup Server: 4.58.1.1: Database SMGP_SERVER: 1150718 kilobytes DUMPED.
Backup Server: 4.58.1.1: Database SMGP_SERVER: 2301304 kilobytes DUMPED.
省去中间过程
Backup Server: 4.58.1.1: Database SMGP_SERVER: 116164846 kilobytes DUMPED.
Backup Server: 3.43.1.1: Dump phase number 1 completed.
Backup Server: 3.43.1.1: Dump phase number 2 completed.
Backup Server: 3.43.1.1: Dump phase number 3 completed.
Backup Server: 4.58.1.1: Database SMGP_SERVER: 116278608 kilobytes DUMPED.
Backup Server: 3.42.1.1: DUMP is complete (database SMGP_SERVER).
(0 rows affected)
====2013-01-15 05:51:30 end dump SMGP_SERVER====
WARNING: In order to LOAD the master database, the SQL Server must run in
single-user mode. If the master database dump uses multiple volumes, you must
execute sp_volchanged on another SQL Server at LOAD time in order to signal
volume changes.
Backup Server session id is: 33. 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::/sybasedata/sybasebak/SMGP_SERVER_master20130115.dmp.gz::00'
Backup Server: 6.28.1.1: Dumpfile name 'master1301505262 ' section number 1
mounted on byte stream
'compress::/sybasedata/sybasebak/SMGP_SERVER_master20130115.dmp.gz::00'
Backup Server: 4.58.1.1: Database master: 5130 kilobytes DUMPED.
Backup Server: 4.58.1.1: Database master: 5300 kilobytes DUMPED.
Backup Server: 4.58.1.1: Database master: 5472 kilobytes DUMPED.
Backup Server: 4.58.1.1: Database master: 5642 kilobytes DUMPED.
Backup Server: 4.58.1.1: Database master: 5806 kilobytes DUMPED.
Backup Server: 3.43.1.1: Dump phase number 1 completed.
Backup Server: 3.43.1.1: Dump phase number 2 completed.
Backup Server: 3.43.1.1: Dump phase number 3 completed.
Backup Server: 4.58.1.1: Database master: 5814 kilobytes DUMPED.
Backup Server: 3.42.1.1: DUMP is complete (database master).
====2013-01-15 05:51:33 end dump SMGP_SERVER_master====

在B上执行load，日志如下：
====2013-01-14 16:35:06 load database start====
Backup Server session id is: 8. 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::/sybase/work/lzp/SMGP_SERVER20130114.dmp.gz::00'
Backup Server: 6.28.1.1: Dumpfile name '_SERVER1301403F49' section number 1
mounted on byte stream
'compress::/sybase/work/lzp/SMGP_SERVER20130114.dmp.gz::00'
Backup Server: 4.58.1.1: Database SMGP_SERVER: 2177628 kilobytes LOADED.
省去中间过程
Backup Server: 4.58.1.1: Database SMGP_SERVER: 208418578 kilobytes LOADED.
Backup Server: 4.58.1.1: Database SMGP_SERVER: 208925394 kilobytes LOADED.
Backup Server: 3.42.1.1: LOAD is complete (database SMGP_SERVER).
Started cross-platform conversion for database SMGP_SERVER.
Started cross-platform conversion for system objects.
Cross-platform conversion for database SMGP_SERVER: 10000 pages completed.
省去中间过程
Cross-platform conversion for database SMGP_SERVER: 409443 pages completed.
Completed cross-platform conversion for system objects.

Started cross-platform conversion for user objects.
Cross-platform conversion for database SMGP_SERVER: 1044505 pages completed.
Cross-platform conversion for database SMGP_SERVER: 2088985 pages completed.
省去中间过程
Cross-platform conversion for database SMGP_SERVER: 104037985 pages completed.
Completed cross-platform conversion for user objects.
Started cross-platform conversion for log records.
Msg 3151, Level 16, State 3:
Server 'HYDB', Line 1:
Adaptive Server cannot load this database because the database that was dumped
was not quiescent when the dump was performed. Run sp_flushstats before DUMP
DATABASE and ensure that the database is not updated during the dump.
Msg 930, Level 14, State 1:
Server 'HYDB', Line 1:
Database 'SMGP_SERVER' cannot be opened because either an earlier system
termination left LOAD DATABASE incomplete or the database is created with 'for
load' option. Load the database or contact a user with System Administrator (SA)
role.
====2013-01-14 22:03:05 load database end====

[sybasebbs]

-Red Hat Linux 5.4 数据库版本：sybase ASE 12.5 这二个东东能不能共享一下啊？

[daefiysq]

引用 1 楼 ehxz 的回复:

-Red Hat Linux 5.4 数据库版本：sybase ASE 12.5 这二个东东能不能共享一下啊？

linux网上多的是，sybase我这也没有安装包。

[iihero]

Adaptive Server cannot load this database because the database that was dumped was not quiescent when the dump was performed. 这是错误提示。。。。

[daefiysq]

引用 3 楼 iihero 的回复:

Adaptive Server cannot load this database because the database that was dumped was not quiescent when the dump was performed. 这是错误提示。。。。

是否因为跨平台迁移，备份时A主机的数据库没有停？

[iihero]

引用 4 楼 daefiysq 的回复:

引用 3 楼 iihero 的回复:Adaptive Server cannot load this database because the database that was dumped was not quiescent when the dump was performed. 这是错误提示。。。。 是否因为跨平台迁移，备份时A主机的数据库没有停？ ……

如果数据库不停，是会产生错误的

[daefiysq]

实验用bcp out 和in的方法来同步数据，遇到字符集的问题。 在A主机bcp out出来的dat数据，在B主机bcp in之后，中文显示乱码，请教如何解决？ A主机服务器环境： 1> select id,name from syscharsets 2> go id name --- ------------------------------ 0 ascii_8 1 iso_1 2 cp850 3 cp437 1> sp_configure "default char" 2> go Parameter Name Default Memory Used Config Value Run Value Unit Type ------------------------------ ----------- ----------- ------------ ----------- -------------------- ---------- default character set id 1 0 1 1 id static B主机环境已经配置为和A主机一样。

[qq_19821559]

引用 4 楼 daefiysq 的回复:

[quote=引用 3 楼 iihero 的回复:] Adaptive Server cannot load this database because the database that was dumped was not quiescent when the dump was performed. 这是错误提示。。。。

是否因为跨平台迁移，备份时A主机的数据库没有停？[/quote]备份时A主机的数据库怎么停，shutdown？那不是做不了dump了吗？不是已经单用户模式了吗？请教