新手LOAD数据库故障inASE 15
<span style="FONT-SIZE: 13px;">在建库FOXHIS(2G)后,恢复数据时报空间小了,NEED 3000MB。。但是data.dat文件才280M,这是为什么哦?不得已,扩库到4G后,再load database 结果又报这个错,大家看看,帮忙一起解决这个问题。。谢<br/>___________________________________________________________<br/>Backup Server: 3.42.1.1: LOAD is complete (database foxhis).<br/>Caution: You have set up this database to include space on disk 58 for both<br/>data and the transaction log. This can make recovery impossible if that disk<br/>fails.<br/>All dumped pages have been loaded. ASE is now clearing pages above page 1536000,<br/>which were not present in the database just loaded.<br/>ASE has finished clearing database pages.<br/>Msg 3484, Level 16, State 1:<br/>Server 'SYBASE', Line 1:<br/>Recovery encountered an error in acquiring locks for reinstantiated<br/>transactions. Please consult the Adaptive Server errorlog for further<br/>information as to the cause.<br/>))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))以上是Load完成时的样子,然后我想打开数据库,结果又出现了以下的Error!!<br/>1> use foxhis<br/>2> go<br/>Msg 930, Level 14, State 1:<br/>Server 'SYBASE', Line 1:<br/>Database 'foxhis' cannot be opened because either an earlier system termination<br/>left LOAD DATABASE incomplete or the database is created with 'for load' option.<br/>Load the database or contact a user with System Administrator (SA) role.<br/>???<br/>不明白了。。。</span><p>DATABASE For RH AS 4</p> 增加锁数,重新LOAD.LOAD完成后online database<br/>
页:
[1]