浪潮ERP软件数据库无法恢复的一个解决方案

浪潮ERP软件数据库无法恢复的一个解决方案

数 据 库： Syb 11.9网
软件版本： PS未知 软件模块： 错误专题
问题描述：
   问题描述：sybase数据库恢复数据，快要恢复完成的时候出现下列提示
Backup Server: 4.58.1.1: Database cwbase3: 1228910 kilobytes LOADed.
Server Message:  Number  304201, Severity  1
Backup Server: 3.42.1.1: LOAD is complete (database cwbase3).
Server Message:  Number  5018, Severity  10
Caution:  You have set up this database to include space on disk 4 for both data and the transaction log.  This can make recovery impossible if that disk fails.
Server Message:  Number  5018, Severity  10
Caution:  You have set up this database to include space on disk 11 for both data and the transaction log.  This can make recovery impossible if that disk fails.
Server Message:  Number  3127, Severity  10
All dumped pages have been loaded.  SQL Server is now clearing pages above page 614400, which were not present in the database just loaded.
Server Message:  Number  3128, Severity  10
SQL Server has finished clearing database pages.
Server Message:  Number  3137, Severity  10
Use the ONLINE DATABASE command to bring this database online; SQL Server will not bring it online automatically.
Server Message:  Number  5702, Severity  10
The SQL Server is terminating this process.
Server Message:  Number  695, Severity  21
An attempt was made to read logical page ’4536′ for object ’5′ in database ’6′ from disk. Wrong logical page ’4539′ was brought into cache ‘default data cache’.
Client Message:  Layer  1, Origin  1, Severity  1, Number  60
ct_cmd_drop(): user api layer: external error: There is a usage error.  This routine has been called at an illegal time.
Failure has occurred in CT-Library call. Connection is no longer usable and will be automatically dropped.

执行到最后结尾的时候，数据库会跳出错误提示：THE connection has droped.

只能点确定或关闭，然后数据库就断开连接。
产生原因： 数据库有问题
解决方法：
   以上面提示的cwbase3为例
以sa连接数据库执行下面的语句：
update sysdatabases set status=-32768 where name=’cwbase3′
go
dump tran master with no_log
然后重起服务
执行下面的语句：截断日志
dump tran cwbase3 with no_log
go
然后设置自动截断日志
sp_dboption cwbase3,’trunc.log chekpt’,true
然后修改状态为正常状态
update sysdatabases set status=12 where name=’cwbase3′
go
重起服务
然后再以sa连接服务器，选择cwbase3
系统提示数据库offline
然后把数据库online database cwbase3
这时候数据库就可以正常使用了，修改id软件就可以正常使用了。

文章的脚注信息由WordPress的wp-posturl插件自动生成