2,596
社区成员
发帖
与我相关
我的任务
分享数据库不能打开的解决办法（状态装载或可疑）
平台资料：
操作系统平台：Windows 2000 5.00.2195 Service Pack 4
数据库平台：Sysbase 12.5
server:db_jc,database:db_text,db_jd,db_jh,db_app
现象：
整个服务器正常运行，此服务器上的db_jd,db_jh运行正常，只有db_text不能打开（提示状态为装载或可疑状态）。
用Powerbuilder 6.0连接时报
Database 'db_jc' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog
for information as to the cause.
查看错误日志errorlog，发现有这么一段：
Keys of index id 1 for table 'systhresholds' in data page not in correct order. Drop and re-create the index. (index
page 337)
The total number of data pages in this table is 1.
Table has 2 data rows.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
分析：
数据库重新启动的时候报错，该应用数据库不能online，无法访问该数据库上的应用数据。
解决办法：
查手册的表述入下
Table 'systhresholds' in database '%.*s' is not in its
correct sort order. Either the clustered index is
missing or there is data corruption in the table.
和日志中表述一样，按照提示，执行dbcc
错误信息如下：
Keys of index id 1 for table 'systhresholds' in data page not in correct order. Drop and re-create the index. (index page
337)
The total number of data pages in this table is 1.
Table has 2 data rows.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
最后的解决办法是：
isql -Usa -P************ -Sdb_jc 进入isql环境 (后面带备注)
use master
go
dump database master to "/usr/sybase/master.dup" --备份master数据库
go
sp_configure "allow updates", 1 --允许sysdatabases可以被修改
go
update sysdatabases set status = -32768 where name = 'db_text' --状态标志修改
go
update sysdatabases set status2 = -32768 where name = 'db_text'
go
shutdown --服务器关闭
go
use db_text
go
select first from sysindexes where id = object_id("systhresholds") --获取索引页
go
select count(*) from systhresholds --获取数据行
go
dbcc traceon(3604)
go
dbcc delete_row('db_text',337;, row, 0) --删除坏行
go
dbcc delete_row('db_text',337, row, 1)
go
select count(*) from systhresholds --检查
go
use master
go
update sysdatabases set status = 0 where name = 'db_text' --标志复位
go
update sysdatabases set status2 = 0 where name = 'db_text'
go
sp_configure "allow updates", 0 --不允许sysdatabases可以被修改
go
shutdown with nowait
go
此时启动正常了。。做dbcc检查，没有报错！
...全文
请发表友善的回复…
发表回复
