system表空间出现坏块如何解决？
OS：LINUX AS 4
Oracle数据库版本：9.2.0.6.0
系统表空间出现坏块信息:
ORA-01578: ORACLE data block corrupted (file # 2, block # 114684)
ORA-01110: data file 2: '/datafile/system02.dbf'
没有任何备份，可以修复么？谢谢！
另外，奇怪的是dbv检测不到：
$ dbv file=/datafile/system02.dbf blocksize=8192
DBVERIFY: Release 9.2.0.6.0 - Production on Fri Jun 6 08:26:10 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /datafile/system02.dbf
DBV-00200: Block, dba 8503292, already marked corrupted
DBVERIFY - Verification complete
Total Pages Examined : 128000
Total Pages Processed (Data) : 86004
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 30806
Total Pages Failing (Index): 0
Total Pages Processed (Other): 4949
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 6241
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 5965783041855 (1389.73467711)
系统表空间坏了这样检查不到吧：
SQL> select segment_type,owner||'.'||segment_name
from dba_extents
where 2 = file_id and 114684 between block_id and block_id+blocks -1
2 3 4 /
ERROR:
ORA-01578: ORACLE data block corrupted (file # 2, block # 114684)
ORA-01110: data file 2: '/datafile/system02.dbf'
no rows selected
SQL>
dump出来了，咋看呢？
Object id on Block? Y
seg/obj: 0x12 csc: 0x56d.454148c itc: 2 flg: - typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0009.017.0004c500 0x5ec00624.27a3.20 --U- 2 fsc 0x004e.0454148d
0x02 0x0007.00f.0003f073 0x5ec008a5.6511.1a C--- 0 scn 0x056c.fdd16b2e
SQL> select name from obj$ where obj$.obj#=18;
NAME
------------------------------
OBJ$
SQL>
页:
[1]