sybase15数据恢复报错，请帮忙看看.

a774050174

语句如下 , 导入跟导出都加了compress语法应该是没有问题的，是不是数据文件出了问题还是后台环境的问题。
bash-3.00# cat /tmp/sybaserestore.sql
load database imaplogdb from "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_0.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_1.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_2.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_3.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_4.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_5.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_6.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_7.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_8.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_9.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_10.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_11.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_12.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_13.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_14.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_15.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_16.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_17.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_18.dmp"
stripe on "compress::/export/home1/fc_C06toC11/I2000_DB/imaplogdb/imaplogdb_19.dmp"
go
online database imaplogdb
go
执行sql报如下错误：
Backup Server session id is: 21. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server Internal Error: 4.126.3.1: Unable to get current date and time.
Internal error.
Msg 8009, Level 16, State 1:
Server 'SYB', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for
details.
Database 'imap_db' is now online.

D_D_D_D

貌似已经online了，另外看看backup server的log有没有其他的信息。

andkylee

修改backupserver的字符集与服务器端保持一致。

wfcjz

andkylee 发表于 2012-03-20 19:06
修改backupserver的字符集与服务器端保持一致。

一语中的！

andkylee

楼主还没反馈呢~~

D_D_D_D

andkylee 发表于 2012-03-20 19:06
修改backupserver的字符集与服务器端保持一致。

学习了。

a774050174

呵呵，后来在backup server启动文件中加入一行-Lus_english重启backup server就ok了，这个是sybase15的一个BUG

xiangzl

学习了。