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

embedded/2024/9/25 4:27:39/

 接前面断电故障处理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


OWNER
--------------------------------------------------------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
PARTITION_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE                              BYTES
------------------------------------ ----------
FLEXSCHE
FLE_CHANGETIME_BACK

TABLE                                    917504


OWNER
--------------------------------------------------------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
PARTITION_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE                              BYTES
------------------------------------ ----------
FLEXSCHE_MONTH
FLE_CHANGETIME_BACK

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

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

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

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


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

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


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);

 OBJECT_ID DATA_OBJECT_ID
---------- --------------
OWNER
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
----------------------------------------------
     78431         305204
MDM
MAIN_JOB_SMS_LIST
TABLE


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> 


http://www.ppmy.cn/embedded/112719.html

相关文章

浅谈Linux中的环回设备

什么是环回设备 环回设备(loop device) 是 Linux 系统中一种特殊的虚拟设备,它允许你将一个普通的文件当作块设备来操作。这意味着,借助环回设备,文件可以模拟为一个磁盘或分区,供系统读写。这种机制非常有…

校园管理新篇章:Spring Boot系统实现策略

第3章 系统分析 3.1 需求分析 校园管理系统主要是为了提高用户的工作效率和更方便快捷的满足用户,更好存储所有数据信息及快速方便的检索功能,对系统的各个模块是通过许多今天的发达系统做出合理的分析来确定考虑用户的可操作性,遵循开发的系…

Java许可政策再变,Oracle JDK 17 免费期将结束!

原文地址:https://www.infoworld.com/article/3478122/get-ready-for-more-java-licensing-changes.html Oracle JDK 17的许可协议将于9月变更回Oracle Technology Network License Agreement,这将迫使用户重新评估他们的使用策略。 有句老话说&#xf…

跟李沐学AI:长短期记忆网络LSTM

输入们、遗忘门和输出门 LSTM引入输入门、忘记门和输出门 输入门计算公式为:。 遗忘门计算公式为:。 输出门计算公式为:。 它们由三个具有sigmoid激活函数的全连接层处理, 以计算输入门、遗忘门和输出门的值。 因此&#xff0c…

mysql的zip解压缩版安装

文章目录 一、MySQL下载二、mysql解压缩版安装1、解压缩2、设置环境变量3、mysql初始化4、安装mysql服务5、启动mysql服务6、连接mysql7、修改初始密码8、安装完成 一、MySQL下载 下载网址:MySQL下载 本文以mysql8.4.2版本为例下载解压缩版。 二、mysql解压缩版安…

vue3使用provide和inject传递异步请求数据子组件接收不到

前言 一般接口返回的格式是数组或对象,使用reactive定义共享变量 父组件传递 const data reactive([])// 使用settimout模拟接口返回 setTimeout(() > {// 将接口返回的数据赋值给变量Object.assign(data, [{ id: 10000 }]) }, 3000);provide(shareData, dat…

算力服务器和GPU服务器的区别是什么?

随着互联网科技的快速发展,服务器的类型也变得多种多样了,今天小编就来为大家介绍一下算力服务器和GPU服务器还有他们之间的区别是什么? 算力服务器通常是指具有着较高计算能力的服务器,算力服务器一般都是用于处理大量的计算任务…

PXE服务

一.PXE服务的功能介绍 1.无盘启动:PXE允许计算机在没有本地存储设备的情况下启动操作系统。这对于构建无盘工作站非常有用,因为计算机可以直接从网络加载操作系统和其他应用程序1。 2.远程安装操作系统:PXE技术可以用于远程安装操作系统&…