- 论坛徽章:
- 1
|
环境:119.2/10490 +AIX
问题:数据库重新启动的时候报7411错,该应用数据库不能online,无法访问该数据库上的应用数据。
解决办法:查手册7411的表述入下
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 4 data rows.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
最后的解决办法是:
update sysdatabases set status = -32768 where dbid = <x>;(后来请教高手,这行也许可以没有)
update sysdatabases set status2 = -32768 where dbid = <x>;
go
shutdown
go
use <dbname>;
go
select first from sysindexes where id = object_id("systhresholds"
go
select count(*) from systhresholds
go
dbcc traceon(3604)
go
dbcc delete_row(<dbid>;,<first>;, row, 0)
go
dbcc delete_row(<dbid>;,<first>;, row, 1)
go
dbcc delete_row(<dbid>;,<first>;, row, 2)
go
dbcc delete_row(<dbid>;,<first>;, row, 3)
go
select count(*) from systhresholds
go
use master
go
update sysdatabases set status = 0 where dbid = x
go
shutdown with nowait
go
此时启动正常了。。做dbcc检查,没有报错! |
|