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