sybase15數(shù)據(jù)恢復(fù)報錯，請幫忙看看.

a774050174

語句如下 , 導(dǎo)入跟導(dǎo)出都加了compress語法應(yīng)該是沒有問題的，是不是數(shù)據(jù)文件出了問題還是后臺環(huán)境的問題。
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
執(zhí)行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

貌似已經(jīng)online了，另外看看backup server的log有沒有其他的信息。

andkylee

修改backupserver的字符集與服務(wù)器端保持一致。

wfcjz

andkylee 發(fā)表于 2012-03-20 19:06
修改backupserver的字符集與服務(wù)器端保持一致。

一語中的！

andkylee

樓主還沒反饋呢~~

D_D_D_D

andkylee 發(fā)表于 2012-03-20 19:06
修改backupserver的字符集與服務(wù)器端保持一致。

學(xué)習(xí)了。

a774050174

呵呵，后來在backup server啟動文件中加入一行-Lus_english重啟backup server就ok了，這個是sybase15的一個BUG

xiangzl

學(xué)習(xí)了。