当前位置：首页 > news >正文

Corrupt block relative dba: 0x02c0b382 (file 11, block 45954)

news 来源：原创 2024/9/20 2:10:05

接前面断电故障处理2：oracle数据库断电无法启动恢复-CSDN博客

DM00 started with pid=145, OS id=16516, job SYS.SYS_IMPORT_TABLE_01
2024-09-13T20:05:22.331302+08:00
ADVISORY: Please collect redo for investigation of ORA-8103. Use command:
ALTER SYSTEM DUMP REDO scn min 1 scn max 126825832 dba min 11 45954 dba max 11 45954;
Hex dump of (file 11, block 45954) in trace file /home/db/oracle/diag/rdbms/jycaps/jycaps/trace/jycaps_ora_16575.trc

Corrupt block relative dba: 0x02c0b382 (file 11, block 45954)
Bad header found during buffer read (logical check)
Data in bad block:
type: 35 format: 2 rdba: 0x02c0b382
last change scn: 0x0000.0000.078d2119 seq: 0x1 flg: 0x04
spare3: 0x0
consistency value in tail: 0x21192301
check value in block header: 0xb50a
computed block checksum: 0x0

2024-09-13T20:05:34.124374+08:00
ADVISORY: Please collect redo for investigation of ORA-8103. Use command:
ALTER SYSTEM DUMP REDO scn min 1 scn max 126825846 dba min 42 234330 dba max 42 234330;
Hex dump of (file 42, block 234330) in trace file /home/db/oracle/diag/rdbms/jycaps/jycaps/trace/jycaps_ora_16575.trc

Corrupt block relative dba: 0x0a83935a (file 42, block 234330)
Bad header found during buffer read (logical check)
Data in bad block:
type: 35 format: 2 rdba: 0x0a83935a
last change scn: 0x0000.0000.0777f48b seq: 0x1 flg: 0x04
spare3: 0x0
consistency value in tail: 0xf48b2301
check value in block header: 0x4c6
computed block checksum: 0x0

参考：
ORA-600 [kcbz_check_objd_typ_3] Error from SMON Process Repeatedly (Doc ID 577579.1)

SQL> SELECT owner,
2 segment_name,
3 partition_name,
4 segment_type,
5 bytes
6 FROM dba_segments
7 WHERE segment_name in('MAIN_JOB_SMS_LIST','FLE_CHANGETIME_BACK');

OWNER
--------------------------------------------------------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
PARTITION_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE BYTES
------------------------------------ ----------
MDM
MAIN_JOB_SMS_LIST

TABLE

TABLE 917504

TABLE 2097152

SQL> select * from v$database_block_corruption;

no rows selected

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@jyc dmp]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Sep 13 20:10:03 2024

connected to target database: jycAPS (DBID=2374181147)

RMAN> backup validate datafile 11;

Starting backup at 2024-09-13 20:10:12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=123 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=/home/db/oracle/oradata/jycaps/flexsche_data_01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11 OK 0 61722 584192 126820454
File Name: /home/db/oracle/oradata/jycaps/flexsche_data_01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 425240
Index 0 90604
Other 0 6626

Finished backup at 2024-09-13 20:10:38

RMAN> select * from v$database_block_corruption;

no rows selected

RMAN> backup validate datafile 42;

Starting backup at 2024-09-13 20:11:11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00042 name=/home/db/oracle/oradata/jycaps/wb_dispatcher_data_02.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
42 OK 0 20260 255232 125301901
File Name: /home/db/oracle/oradata/jycaps/wb_dispatcher_data_02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 227616
Index 0 5153
Other 0 2203

Finished backup at 2024-09-13 20:11:26

RMAN> exit

Recovery Manager complete.
[oracle@jyc dmp]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 13 20:12:00 2024

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select owner, segment_name, segment_type, partition_name,tablespace_name from dba_extents where relative_fno = 11 and 45954 between block_id and (block_id+blocks-1);

no rows selected

SQL> select owner, segment_name, segment_type, partition_name,tablespace_name from dba_extents where relative_fno = 42 and 234330 between block_id and (block_id+blocks-1);

no rows selected

SQL> select * from v$database_block_corruption;

no rows selected

SQL> !
[oracle@jyc dmp]$ grep MISMATCH /home/db/oracle/diag/rdbms/jycaps/jycaps/trace/jycaps_ora_16575.trc|more
OBJD MISMATCH typ=35, seg.obj=0, diskobj=305208, dsflg=0, dsobj=305168, tid=305168, cls=4
OBJD MISMATCH typ=35, seg.obj=0, diskobj=305208, dsflg=0, dsobj=305168, tid=305168, cls=4
OBJD MISMATCH typ=35, seg.obj=0, diskobj=305214, dsflg=0, dsobj=305204, tid=305204, cls=4
OBJD MISMATCH typ=35, seg.obj=0, diskobj=305214, dsflg=0, dsobj=305204, tid=305204, cls=4
[oracle@jyc dmp]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 13 20:24:27 2024

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select * from seg$ where file#=11 and block# = 45954;

FILE# BLOCK# TYPE# TS# BLOCKS EXTENTS INIEXTS
---------- ---------- ---------- ---------- ---------- ---------- ----------
MINEXTS MAXEXTS EXTSIZE EXTPCT USER# LISTS GROUPS
---------- ---------- ---------- ---------- ---------- ---------- ----------
BITMAPRANGES CACHEHINT SCANHINT HWMINCR SPARE1 SPARE2
------------ ---------- ---------- ---------- ---------- ----------
11 45954 5 8 112 14 8
1 2147483645 128 0 120 0 0
2147483645 0 0 305168 4325633

SQL> select * from seg$ where file#=42 and block# = 234330;

FILE# BLOCK# TYPE# TS# BLOCKS EXTENTS INIEXTS
---------- ---------- ---------- ---------- ---------- ---------- ----------
MINEXTS MAXEXTS EXTSIZE EXTPCT USER# LISTS GROUPS
---------- ---------- ---------- ---------- ---------- ---------- ----------
BITMAPRANGES CACHEHINT SCANHINT HWMINCR SPARE1 SPARE2
------------ ---------- ---------- ---------- ---------- ----------
42 234330 5 28 8 1 2
1 2147483645 1 0 118 0 0
2147483645 0 0 305204 4194561

SQL> select object_id, data_object_id, owner, object_name, object_type from dba_objects where data_object_id in(305168, 305208) or object_id in (305168, 305208);

OBJECT_ID DATA_OBJECT_ID
---------- --------------
OWNER
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
----------------------------------------------
79395 305168
FLEXSCHE
FLE_CHANGETIME_BACK
TABLE

SQL> select object_id, data_object_id, owner, object_name, object_type from dba_objects where data_object_id in(305204, 305214) or object_id in (305204, 305214);

SQL> select segment_name, owner, segment_type from sys.dba_extents
2 where file_id = 11 and 45954 between block_id and block_id + blocks -1;

no rows selected

SQL> select segment_name, owner, segment_type from sys.dba_extents
2 where file_id = 42 and 234330 between block_id and block_id + blocks -1;

no rows selected

SQL>