本帖最后由 saintfl 于 2016-9-6 18:34 编辑
数据库可以正常open,但是log中有ORA-01578: ORACLE data block corrupted (file # 1, block # 572023)
ORA-01110: data file 1: '/data/ora/system01.dbf'
数据无法IMPDP出来,检测的确system01中有这个坏块。
$ dbv file=/data/ora/system01.dbf blocksize=8192
DBVERIFY: Release 10.2.0.5.0 - Production on Mon Sep 5 12:33:37 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = /data/ora/system01.dbf
DBV-00200: Block, DBA 4766327, already marked corrupt
csc(0x0001.fad921f2) higher than block scn(0x0000.00000000)
Page 572023 failed with check code 6054
DBVERIFY - Verification complete
Total Pages Examined : 1745920
Total Pages Processed (Data) : 525746
Total Pages Failing (Data) : 1
Total Pages Processed (Index): 616854
Total Pages Failing (Index): 0
Total Pages Processed (Other): 587850
Total Pages Processed (Seg) : 1
Total Pages Failing (Seg) : 0
Total Pages Empty : 15470
Total Pages Marked Corrupt : 1
Total Pages Influx : 0
Highest block SCN : 664818854 (2.664818854)
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 05-SEP-16
SQL> select * from V$DATABASE_BLOCK_CORRUPTION;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
1 572023 1 0 CORRUPT
但是BBED校验这个块却不是坏块,这是什么原因?为什么?
BBED> verify
DBVERIFY - Verification starting
FILE = /data/ora/system01.dbf
BLOCK = 572023
Block Checking: DBA = 4766327, Block Type = KTB-managed data block
Found block already marked corrupted
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
查看块的对象也是报错
SQL> SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, A.PARTITION_NAME
FROM DBA_EXTENTS A
WHERE FILE_ID = 1
AND 572023 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1; 2 3 4
ERROR:
ORA-01578: ORACLE data block corrupted (file # 1, block # 572023)
ORA-01110: data file 1: '/data/ora/system01.dbf'