SYBASE ASE 系统库sybsystemprocs重建探究

1.模拟设备文件损坏

[root@sybaseHost sybase]# mv sysproc.dat sysproc1.dat

 重启数据库,sybsystemprocs为可疑状态

2.删除数据库

1> drop database sybsystemprocs
2> go
Msg 840, Level 17, State 2:
Server 'ASE12_5_4', Line 1:
Device 'sysprocdev' (with physical name '/opt/sybase/sysproc.dat', and virtual device number 1) has not been correctly activated
 at startup time.  Please contact a user with System Administrator (SA) role.

失败，则通过手动删除sysdatabase和sysusages记录，并重启数据库(需要sp_configure 'allow update',1)

1> delete from sysusages where dbid=db_id('sybsystemprocs')
2> go
(1 row affected)
1> delete