网站 › 『 Sybase ASE 』 › 请教：load完数据库后报错？？？

mumu8800 发表于 2006-6-16 10:54:14

请教：load完数据库后报错？？？

<span style="FONT-SIZE: 13px;">本人对刚装的数据库进行load完数据后报错，一下是显示的信息：<br/>Line 1:<br/>Caution:&nbsp;&nbsp;You have set up this database to include space on disk 2 for both data<br/>and the transaction log.&nbsp;&nbsp;This can make recovery impossible if that disk fails.<br/>Msg 5018, Level 17, State 1:<br/>Line 1:<br/>Caution:&nbsp;&nbsp;You have set up this database to include space on disk 4 for both data<br/>and the transaction log.&nbsp;&nbsp;This can make recovery impossible if that disk fails.<br/>Msg 5018, Level 17, State 1:<br/>Line 1:<br/>Caution:&nbsp;&nbsp;You have set up this database to include space on disk 5 for both data<br/>and the transaction log.&nbsp;&nbsp;This can make recovery impossible if that disk fails.<br/>Msg 5018, Level 17, State 1:<br/>Line 1:<br/>Caution:&nbsp;&nbsp;You have set up this database to include space on disk 6 for both data<br/>and the transaction log.&nbsp;&nbsp;This can make recovery impossible if that disk fails.<br/>All dumped pages have been loaded.&nbsp;&nbsp;SQL Server is now clearing pages above page<br/>4608000, which were not present in the database just loaded.<br/>SQL Server has finished clearing database pages.<br/>Use the ONLINE DATABASE command to bring this database online; SQL Server will<br/>not bring it online automatically.<br/>Database 'aa' is now online.<br/><br/>请问各位大侠，以上是什么意思？为什么会出现这种提示信息？该怎样解决才能在以后进行load数据库时不再出现以上提示信息?还有就是我发现在load数据前后数据库显示信息不同,如下：<br/>刚建好数据库没有进行load数据的时候<br/>credits&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 9500.0 MB credits&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;5<br/>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;Jun 14, 2006<br/>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;no options set&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<br/><br/>device_fragments&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;size&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; usage&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; free kbytes<br/>------------------------------ ------------- -------------------- -----------<br/>credits_dev&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1900.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1945600<br/>credits_dev1&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;1900.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1945600<br/>credits_dev2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;1900.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1945600<br/>credits_dev3&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;1900.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1945600<br/>credits_log_dev&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1900.0 MB&nbsp; &nbsp;&nbsp; &nbsp;log only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1945600<br/><br/>(return status = 0)<br/><br/>做load数据库后变成：<br/>credits&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 9500.0 MB credits&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;5<br/>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;Jun 14, 2006<br/>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;no options set&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<br/><br/>device_fragments&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;size&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; usage&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; free kbytes<br/>------------------------------ ------------- -------------------- -----------<br/>credits_dev&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;600.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;688<br/>credits_dev&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;940.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;192<br/>credits_dev&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;360.0 MB&nbsp; &nbsp;&nbsp; &nbsp;log only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;216608<br/>credits_dev1&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 1900.0 MB&nbsp; &nbsp;&nbsp;&nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;656<br/>credits_dev2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 602.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;128768<br/>credits_dev2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 700.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;716800<br/>credits_dev2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 598.0 MB&nbsp; &nbsp;&nbsp; &nbsp;log only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;612352<br/>credits_dev3&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 100.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data and log&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;25712<br/>credits_dev3&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 100.0 MB&nbsp; &nbsp;&nbsp; &nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;102400<br/>credits_dev3&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 1200.0 MB&nbsp; &nbsp;&nbsp;&nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 1228800<br/>credits_dev3&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 500.0 MB&nbsp; &nbsp;&nbsp; &nbsp;log only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;512000<br/>credits_log_dev&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 1400.0 MB&nbsp; &nbsp;&nbsp;&nbsp;data only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 1433600<br/>credits_log_dev&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 500.0 MB&nbsp; &nbsp;&nbsp; &nbsp;log only&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;512000<br/><br/>(return status = 0)<br/><br/>该怎样解决才能在以后进行load数据库后，数据库的显示信息相同？<br/><br/></span>

ehxz 发表于 2006-6-16 17:03:15

好象没什么好办法，偶原来公司的数据库也这样情况，关注一下。

delstat 发表于 2006-6-16 18:02:37

这个应该不算个错误。<br/>Sybase ASE 在load dump的时候会去除掉一些无法提交的数据或者日志。load dump之后，ASE会重新检查日志和数据页。因为你的磁盘不可能是干净的空盘，所以它会重新分配你的数据页，但，会保证你的数据的完整性。<br/><br/>我想，你的数据库(load 完后)应该是可用的

flybean 发表于 2006-6-17 00:05:51

LOAD时应尽可能保证设备与原设备一样的分布（大小和顺序）<br/>

查看完整版本: 请教：load完数据库后报错？？？