LOAD数据库出错

wjhen

数据库原是从AIX版本上DUMP出来的，还原到WINNT平台上。AIX的ASE版本要低于WINNT平台的ASE版本，但是都是12.5.x版本的。

还原的时候出现如下提示，请高手指点，现在重新DUMP数据库已经不可能了，用AIX版本DUMP出来的数据库在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技术专家

你不是在AIX平台可以load吗？先load到aix平台，执行sp_flushstats之后，再dump就行了。