- 论坛徽章:
- 0
|
本帖最后由 redwaves 于 2010-07-14 18:42 编辑
先要将数据库置于suspects状态
#isql -U sa -P 123456 -SAS5XHB
1.打开更新状态
1>sp_configure “allow updates”,1
2>go
2.设置数据库状态为256
1> use master
2>go
1> update sysdatabases set status=256 where name='xhb'
2> go
(1 row affected)
设置完后数据库由offline变为not recovered, offline:
xhb 4096.0 MB sa 4
Jul 14, 2010
not recovered, offline
3.关闭更新
1>sp_configure “allow updates”,0
2>go
4.重起数据库
1>shutdown with nowait
2>go
5.删除数据库
1>dbcc dbrepair(xhb.dropdb)
2>go
完成如下:
1> sp_helpdb
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
------------------
------------------------------------------------------------------------------------------------------
master 6.0 MB sa 1
Jul 13, 2010
mixed log and data
model 2.0 MB sa 3
Jul 13, 2010
mixed log and data
sybsystemdb 3.0 MB sa 31513
Jul 13, 2010
mixed log and data
sybsystemprocs 132.0 MB sa 31514
Jul 13, 2010
trunc log on chkpt, mixed log and data
tempdb 3.0 MB sa 2
Jul 14, 2010
select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
xhb 4096.0 MB sa 4
Jul 14, 2010
not recovered, offline
(1 row affected)
(return status = 0)
1> dbcc dbrepair(xhb,dropdb)
2> go
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1> sp_helpdb
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
------------------
------------------------------------------------------------------------------------------------------
master 6.0 MB sa 1
Jul 13, 2010
mixed log and data
model 2.0 MB sa 3
Jul 13, 2010
mixed log and data
sybsystemdb 3.0 MB sa 31513
Jul 13, 2010
mixed log and data
sybsystemprocs 132.0 MB sa 31514
Jul 13, 2010
trunc log on chkpt, mixed log and data
tempdb 3.0 MB sa 2
Jul 14, 2010
select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
(1 row affected)
(return status = 0)
删除日志设备
1> sp_dropdevice xhb_log_dev
2> go
00:00000:00012:2010/07/14 18:26:22.95 kernel uddeactivate: device for vdn 4 already inactive.
Device dropped.
(return status = 0)
1> sp_helpdevice
2> go
device_name physical_name
description
status cntrltype device_number
low
high
------------------------------ ----------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------ --------- -------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
master /opt/sybase1254/data/master.dat
special, dsync on, default disk, physical disk, 30.00 MB
3 0 0
0
15359
sysprocsdev /opt/sybase1254/data/sysprocs.dat
special, dsync on, physical disk, 132.00 MB
16386 0 1
16777216
16844799
systemdbdev /opt/sybase1254/data/sybsysdb.dat
special, dsync on, physical disk, 1.00 MB
16386 0 2
33554432
33554943
tapedump1 /dev/nst0
disk, dump device
16 2 0
0
20000
tapedump2 /dev/nst1
tape, 625 MB, dump device
16 3 0
0
20000
xhb_dev /opt/sybase1254/data/xhb_dev.dat
special, dsync on, physical disk, 2048.00 MB
16386 0 3
50331648
51380223
(6 rows affected)
(return status = 0)
1>
删除数据设备
1> sp_dropdevice xhb_dev
2> go
00:00000:00012:2010/07/14 18:28:34.13 kernel uddeactivate: device for vdn 3 already inactive.
Device dropped.
(return status = 0)
1> sp_helpdevice
2> go
device_name physical_name
description
status cntrltype device_number
low
high
------------------------------ ----------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------ --------- -------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
master /opt/sybase1254/data/master.dat
special, dsync on, default disk, physical disk, 30.00 MB
3 0 0
0
15359
sysprocsdev /opt/sybase1254/data/sysprocs.dat
special, dsync on, physical disk, 132.00 MB
16386 0 1
16777216
16844799
systemdbdev /opt/sybase1254/data/sybsysdb.dat
special, dsync on, physical disk, 1.00 MB
16386 0 2
33554432
33554943
tapedump1 /dev/nst0
disk, dump device
16 2 0
0
20000
tapedump2 /dev/nst1
tape, 625 MB, dump device
16 3 0
0
20000
(5 rows affected)
(return status = 0)
1>
终于搞定,感谢大家支持 |
|