LOAD數(shù)據(jù)庫出錯

wjhen

數(shù)據(jù)庫原是從AIX版本上DUMP出來的，還原到WINNT平臺上。AIX的ASE版本要低于WINNT平臺的ASE版本，但是都是12.5.x版本的。

還原的時候出現(xiàn)如下提示，請高手指點，現(xiàn)在重新DUMP數(shù)據(jù)庫已經(jīng)不可能了，用AIX版本DUMP出來的數(shù)據(jù)庫在AIX上可以正常LOAD的。

Server Message:  Number  3216, Severity  10
Server 'DATASTORE', Line 1:
Backup Server session id is:  10.  Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message:  Number  602801, Severity  1
Server 'DATASTORE_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.28.1.1: Dumpfile name 'maindb0400106B76 ' section number 1 mounted on disk file 'E:\Sybase_data\maindb20040101.dat'
Server Message:  Number  405801, Severity  1
Server 'DATASTORE_BS', Procedure 'bs_perform_load', Line 0:
Backup Server: 4.58.1.1: Database maindb20040101: 216800 kilobytes LOADed.
Server Message:  Number  405801, Severity  1
Server 'DATASTORE_BS', Procedure 'bs_perform_load', Line 0:
Backup Server: 4.58.1.1: Database maindb20040101: 418494 kilobytes LOADed.
...
Server Message:  Number  405801, Severity  1
Server 'DATASTORE_BS', Procedure 'bs_end_load', Line 0:
Backup Server: 4.58.1.1: Database maindb20040101: 10826066 kilobytes LOADed.
Server Message:  Number  304201, Severity  1
Server 'DATASTORE_BS', Procedure 'bs_end_load', Line 0:
Backup Server: 3.42.1.1: LOAD is complete (database maindb20040101).
Server Message:  Number  3152, Severity  10
Server 'DATASTORE', Line 1:
Started cross-platform conversion for database maindb20040101.
Server Message:  Number  3153, Severity  10
Server 'DATASTORE', Line 1:
Started cross-platform conversion for system objects.
Server Message:  Number  3160, Severity  10
Server 'DATASTORE', Line 1:
Cross-platform conversion for database maindb20040101: 10000 pages completed.
Server Message:  Number  3160, Severity  10
Server 'DATASTORE', Line 1:
Cross-platform conversion for database maindb20040101: 20000 pages completed.
Server Message:  Number  3160, Severity  10
Server 'DATASTORE', Line 1:
Cross-platform conversion for database maindb20040101: 21815 pages completed.
Server Message:  Number  3154, Severity  10
Server 'DATASTORE', Line 1:
Completed cross-platform conversion for system objects.
Server Message:  Number  3155, Severity  10
Server 'DATASTORE', Line 1:
Started cross-platform conversion for user objects.
Server Message:  Number  3160, Severity  10
Server 'DATASTORE', Line 1:
Cross-platform conversion for database maindb20040101: 53960 pages completed.
Server Message:  Number  3160, Severity  10
...
Server 'DATASTORE', Line 1:
Cross-platform conversion for database maindb20040101: 5354122 pages completed.
Server Message:  Number  3156, Severity  10
Server 'DATASTORE', Line 1:
Completed cross-platform conversion for user objects.
Server Message:  Number  3157, Severity  10
Server 'DATASTORE', Line 1:
Started cross-platform conversion for log records.
Server Message:  Number  3151, Severity  16
Server 'DATASTORE', 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.

Sybase技術(shù)專家

你不是在AIX平臺可以load嗎？先load到aix平臺，執(zhí)行sp_flushstats之后，再dump就行了。