首页 > 其他分享 >bbed处理ORA-01578---惜分飞

bbed处理ORA-01578---惜分飞

时间：2023-09-15 10:01:03浏览次数：40  
标签：01578 BBED Blocks 分飞 --- 3136663 Total Pages block

联系：手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题：bbed解决ORA-01578

作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

业务报ORA-01578坏块,无法正常使用,alert日志报错如下

Reading datafile '/data/u01/ZLDOCXML01.DBF' for corruption at rdba: 0x02efdc97 (file 11, block 3136663) Reread (file 11, block 3136663) found same corrupt data Wed Sep 13 19:02:04 2023 Corrupt Block Found          TSN = 10, TSNAME = ZLDOCXML          RFN = 11, BLK = 3136663, RDBA = 49274007          OBJN = 73646, OBJD = 73646, OBJECT = SYS_LOB0000073645C00029$$, SUBOBJECT =          SEGMENT OWNER = ZLDOC, SEGMENT TYPE = Lob Segment DDE: Problem Key 'ORA 1578' was completely flood controlled (0x6) Further messages for this problem key will be suppressed for up to 10 minutes

通过dbv检查数据文件,发现只有这一个坏块

[oracle@zlemr ~]$ dbv file=/data/u01/ZLDOCXML01.DBF   DBVERIFY: Release 11.2.0.1.0 - Production on Wed Sep 13 17:51:03 2023   Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.     DBVERIFY - Verification starting : FILE = /data/u01/ZLDOCXML01.DBF Page 3136663 is influx - most likely media corrupt Corrupt block relative dba: 0x02efdc97 (file 11, block 3136663) Fractured block found during dbv: Data in bad block:  type: 40 format: 2 rdba: 0x02efdc97  last change scn: 0x0002.1065d622 seq: 0x2 flg: 0x04  spare1: 0x0 spare2: 0x0 spare3: 0x0  consistency value in tail: 0x00000001  check value in block header: 0x48cf  computed block checksum: 0xfe21     DBVERIFY - Verification complete   Total Pages Examined         : 3289600 Total Pages Processed (Data) : 0 Total Pages Failing   (Data) : 0 Total Pages Processed (Index): 21037 Total Pages Failing   (Index): 0 Total Pages Processed (Lob)  : 2051270 Total Pages Failing   (Lob)  : 0 Total Pages Processed (Other): 1068900 Total Pages Processed (Seg)  : 0 Total Pages Failing   (Seg)  : 0 Total Pages Empty            : 148392 Total Pages Marked Corrupt   : 1 Total Pages Influx           : 1 Total Pages Encrypted        : 0 Highest block SCN            : 278716397 (2.278716397)

通过bbed进入进行修复

[oracle@zlemr ~]$ bbed Password:   BBED: Release 2.0.0.0.0 - Limited Production on Wed Sep 13 19:05:53 2023   Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.   ************* !!! For Oracle Internal Use only !!! ***************   BBED> set filename '/data/u01/ZLDOCXML01.DBF'         FILENAME        /data/u01/ZLDOCXML01.DBF   BBED> set block 3136663         BLOCK#          3136663   BBED> verify DBVERIFY - Verification starting FILE = /data/u01/ZLDOCXML01.DBF BLOCK = 3136663   Block 3136663 is corrupt Corrupt block relative dba: 0x02efdc97 (file 0, block 3136663) Fractured block found during verification Data in bad block:  type: 40 format: 2 rdba: 0x02efdc97  last change scn: 0x0002.1065d622 seq: 0x2 flg: 0x04  spare1: 0x0 spare2: 0x0 spare3: 0x0  consistency value in tail: 0x00000001  check value in block header: 0x48cf  computed block checksum: 0xfe21     DBVERIFY - Verification complete   Total Blocks Examined         : 1 Total Blocks Processed (Data) : 0 Total Blocks Failing   (Data) : 0 Total Blocks Processed (Index): 0 Total Blocks Failing   (Index): 0 Total Blocks Empty            : 0 Total Blocks Marked Corrupt   : 1 Total Blocks Influx           : 2 Message 531 not found;  product=RDBMS; facility=BBED     BBED> map  File: /data/u01/ZLDOCXML01.DBF (0)  Block: 3136663                                Dba:0x00000000 ------------------------------------------------------------ BBED-00400: invalid blocktype (40)     BBED> d  File: /data/u01/ZLDOCXML01.DBF (0)  Block: 3136663           Offsets:    0 to  511           Dba:0x00000000 ------------------------------------------------------------------------  28a20000 97dcef02 22d66510 02000204 cf480000 ae1f0100 00000001 00000280  93840000 00000000 00000000 00000000 80dcef02 00000000 000d000a 005b4e3b  6cbb533b 5e0867e5 623f8bb0 5f55005d 000d000a 4e3b6cbb 533b5e08 67e5623f  8bb05f55 00320030 00320033 002d0030 0039002d 00310033 00200030 0039003a  00310036 000d000a 4eca65e5 968f9ec4 4e1d51e4 4e3b6cbb 533b5e08 67e5623f  002c60a3 80058bc9 65e08179 75dbff0c 65e053d1 70ed3001 754f5bd2 ff0c65e0  59346655 30015934 75db3001 773c82b1 ff0c65e0 9f3b585e 30016d41 6d953001  54bd75db 300154b3 55fd3001 54b375f0 ff0c65e0 60765fc3 30015455 5410ff0c  65e080f8 95f73001 5fc360b8 3001547c 543856f0 96beff0c 65e05c3f 98913001  5c3f6025 30015c3f 75dbff0c 65e08179 6cfb7b49 4e0d9002 ff0c7cbe 795e3001  98df6b32 30017761 772053ef ff0c5927 5c0f4fbf 6b635e38 300267e5 4f53ff1a  751f547d 5f816b63 5e38ff0c 54bd65e0 51458840 ff0c6241 68434f53 65e080bf  5927ff0c 53cc4fa7 4e73623f 4e0d80c0 ff0c4e73 6c415206 6ccc591a ff0c672a  89e653ca 786c7ed3 ff0c5fc3 80ba672a 89c1660e 663e5f02 5e38ff0c 81798f6f  ff0c8179 90e8538b 75dbff0c 65e053cd 8df375db ff0c80a0 9e2397f3 6b635e38  30028f85 52a968c0 67e5ff1a 767d5e26 5e3889c4 ff1a767d 7ec680de 0020002b    <32 bytes per line>     BBED> set offset 8188         OFFSET          8188   BBED> d  File: /data/u01/ZLDOCXML01.DBF (0)  Block: 3136663           Offsets: 8188 to 8191           Dba:0x00000000 ------------------------------------------------------------------------  01000000    <32 bytes per line>   BBED> set count 32         COUNT           32   BBED> set mode edit         MODE            Edit   BBED> d  File: /data/u01/ZLDOCXML01.DBF (0)  Block: 3136663           Offsets:   14 to   45           Dba:0x00000000 ------------------------------------------------------------------------  0204cf48 0000ae1f 01000000 00010000 02809384 00000000 00000000 00000000    <32 bytes per line>   BBED> set offset 8188         OFFSET          8188   BBED> m /x 022822d6  File: /data/u01/ZLDOCXML01.DBF (0)  Block: 3136663           Offsets: 8188 to 8191           Dba:0x00000000 ------------------------------------------------------------------------  022822d6    <32 bytes per line>   BBED> sum apply Check value for File 0, Block 3136663: current = 0x48cf, required = 0x48cf   BBED> verify DBVERIFY - Verification starting FILE = /data/u01/ZLDOCXML01.DBF BLOCK = 3136663     DBVERIFY - Verification complete   Total Blocks Examined         : 1 Total Blocks Processed (Data) : 0 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 Message 531 not found;  product=RDBMS; facility=BBED

dbv检测文件正常

[oracle@zlemr ~]$ dbv file=/data/u01/ZLDOCXML01.DBF   DBVERIFY: Release 11.2.0.1.0 - Production on Wed Sep 13 19:17:21 2023   Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.   DBVERIFY - Verification starting : FILE = /data/u01/ZLDOCXML01.DBF     DBVERIFY - Verification complete   Total Pages Examined         : 3289600 Total Pages Processed (Data) : 0 Total Pages Failing   (Data) : 0 Total Pages Processed (Index): 21037 Total Pages Failing   (Index): 0 Total Pages Processed (Lob)  : 2051586 Total Pages Failing   (Lob)  : 0 Total Pages Processed (Other): 1069031 Total Pages Processed (Seg)  : 0 Total Pages Failing   (Seg)  : 0 Total Pages Empty            : 147946 Total Pages Marked Corrupt   : 0 Total Pages Influx           : 0 Total Pages Encrypted        : 0 Highest block SCN            : 278849105 (2.278849105)

业务测试正常,数据完美恢复

标签：01578,BBED,Blocks,分飞,---,3136663,Total,Pages,block
From： https://www.cnblogs.com/xifenfei/p/17704188.html

相关文章

  • 25届实习秋招-Java面试-JUC多线程面试题整理-牛客网
    JUC介绍一下JUC下的锁（如何使用及应用场景）线程什么是进程：特征什么是线程：资源为什么多线程，什么使用用单线程，什么时候多线程，什么条件下多线程快。进程和线程的对比：进程如何通信，每种通信存放的介质。||线程的通信，几种方式。join进程和线程的区别，在JVM层面的体现一......
  • [代码随想录]Day45-动态规划part13
    题目：300.最长递增子序列思路：dp[i]状态取决于dp[0]-dp[i-1]中小于dp[i]的元素中最大的值+1，即:forj:=0;j<i;j++{ifnums[i]>nums[j]{dp[i]=max(dp[i],dp[j]+1)}}代码：动态规划funclengthOfLIS(nums[]int)int{lens:=len(nums)......
  • 25届实习/秋招-java面试-JavaSe面试题整理-牛客网
    JavaSe变量和运算符：基本数据类型介绍java中浮点数精度怎么解决，有了解过实现吗，为什么有精度问题BigDecimal，如何判断BigDecimal是否相等。如何进行计算、怎么四舍五入基本类型几种，分别占用空间int和Integer区别--包装类，int有几个字节。包装类常量池怎么判断相等的......
  • CSP-S 提高第一轮 积累本
    绷。随便应付应付得了。点击查看目录目录CSP-S2022CSP-S2022记录54pts。你同时用time命令和秒表为某个程序在单核CPU的运行计时。假如time命令的输出如下：real0m30.721suser0m24.579ssys0m6.123s以下最接近秒表计时的时长为（）。A.30sB.24s......
  • 界面组件DevExpress WinForms v23.1亮点 - 全新升级HTML & CSS模板
    DevExpressWinForms拥有180+组件和UI库，能为WindowsForms平台创建具有影响力的业务解决方案。DevExpressWinForms能完美构建流畅、美观且易于使用的应用程序，无论是Office风格的界面，还是分析处理大批量的业务数据，它都能轻松胜任！DevExpressWinForm 控件已正式发布v23.1版本，此版......
  • ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, p_lion.prm: Address al
    我的ogg版本OracleGoldenGateCommandInterpreterforOracleVersion12.3.0.1.4OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBOLinux,x64,64bit(optimized),Oracle11gonApr15201821:16:09OperatingsystemcharactersetidentifiedasUTF-8.报错信息2023......
  • 618京东到家APP-门详页反爬实战
    一、背景与系统安全需求分析1.系统的重要性上图所示是接口所属位置、对电商平台或在线商店而言，分类查商品都是很重要的，通过为用户提供清晰的商品分类，帮助他们快速找到所需产品，节省浏览时间，提升购物效率，是购物结算产生GMV的核心环节。那么电商平台为什么都很看重商品信息的爬......
  • idb单副本时-TiKV节点损坏后有损数据恢复的方法
    Tidb单副本时-TiKV节点损坏后有损数据恢复的方法背景UAT环境下,为了减少存储.搭建了一套单副本的TiDB集群但是随着数据量的增多,UAT上面的数据可以丢失,但是表结构等信息是无法接受丢失和损坏的.因为很多不太均衡的问题,导致.部分TiKV节点不稳定.甚至会出现TiKV宕机的......
  • 宏景HCM SQL注入漏洞复现（CNVD-2023-08743）
    漏洞概述宏景HCM存在SQL注入漏洞，未经过身份认证的远程攻击者可利用此漏洞执行任意SQL指令，从而窃取数据库敏感信息。影响范围宏景HCM<8.2漏洞复现fofa语法：FOFA：body='<divclass="hj-hy-all-one-logo"'鹰图语法：app.name="宏景HCM"POC：（注入点是categories字段）/servlet/codes......
  • 关于element-plus框架一些样式的修改
    一、关于使用element框架一些测试建议覆盖的样式1.取消按钮的focus效果(1)css样式覆盖//element按钮部分伪类样式覆盖//用于覆盖element按钮focus的样式.el-button:not(.is-link):not(.is-text):not(.is-disabled):not(.is-has-bg):focus{color:var(--el-button-text-......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99