- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-16 14:36:18
|
查看: 1674 |
回复: 0
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>
|
|