BBED标记坏块以及修复坏块-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

BBED标记坏块以及修复坏块

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:06 PM

repaircreatemarktest

创建测试表： ZBDBA@orcl11gselect * from zbdba;NAME------------------------------------------------------------zbdbahuihuiZBDBA@orcl11gZBDBA@orcl11gZBDBA@orcl11gZBDBA@orcl11gZBDBA@orcl11gselect rowid,dbms_rowid.rowid_object(rowid) robject,

创建测试表：

ZBDBA@orcl11g>select * from zbdba;
NAME
------------------------------------------------------------
zbdba
huihui

ZBDBA@orcl11g>
ZBDBA@orcl11g>
ZBDBA@orcl11g>
ZBDBA@orcl11g>
ZBDBA@orcl11g>select rowid,dbms_rowid.rowid_object(rowid) robject,
  2  dbms_rowid.rowid_relative_fno(rowid) fno,
  3  dbms_rowid.rowid_block_number(rowid) bno,
  4  dbms_rowid.rowid_row_number(rowid) rno from zbdba where rownum=1;

ROWID                 ROBJECT        FNO        BNO        RNO
------------------ ---------- ---------- ---------- ----------
AAASMNAAGAAAAC/AAA      74509          6        191          0

使用bbed修改块状态：

BBED> set file 6 block 191
        FILE#           6
        BLOCK#          191

BBED> map
File: /opt/oracle/oradata/orcl11g/zbdba01.dbf (6)
Block: 191                                   Dba:0x018000bf
------------------------------------------------------------
KTB Data Block (Table/Cluster)

struct kcbh, 20 bytes                      @0      

struct ktbbh, 72 bytes                     @20     

struct kdbh, 14 bytes                      @100    

struct kdbt[1], 4 bytes                    @114    

sb2 kdbr[2]                                @118    

ub1 freespace[8047]                        @122    

ub1 rowdata[19]                            @8169   

ub4 tailchk                                @8188   


BBED> p kcbh
struct kcbh, 20 bytes                       @0      
   ub1 type_kcbh                            @0        0x06
   ub1 frmt_kcbh                            @1        0xa2
   ub1 spare1_kcbh                          @2        0x00
   ub1 spare2_kcbh                          @3        0x00
   ub4 rdba_kcbh                            @4        0x018000bf
   ub4 bas_kcbh                             @8        0x005036cd
   ub2 wrp_kcbh                             @12       0x0000
   ub1 seq_kcbh                             @14       0x01
   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)
   ub2 chkval_kcbh                          @16       0x426d
   ub2 spare3_kcbh                          @18       0x0000

BBED> modify /x ff offset 14
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /opt/oracle/oradata/orcl11g/zbdba01.dbf (6)
Block: 191              Offsets:   14 to  525           Dba:0x018000bf
------------------------------------------------------------------------
ff066d42 00000100 00000d23 01009636 50000000 00000200 3200b800 80011300
02001800 0000e90b 80021100 38000220 0000cd36 50000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000001 0200ffff 1600851f
6f1f6f1f 00000200 8f1f851f 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> p kcbh
struct kcbh, 20 bytes                       @0      
   ub1 type_kcbh                            @0        0x06
   ub1 frmt_kcbh                            @1        0xa2
   ub1 spare1_kcbh                          @2        0x00
   ub1 spare2_kcbh                          @3        0x00
   ub4 rdba_kcbh                            @4        0x018000bf
   ub4 bas_kcbh                             @8        0x005036cd
   ub2 wrp_kcbh                             @12       0x0000
   ub1 seq_kcbh                             @14       0xff
   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)
   ub2 chkval_kcbh                          @16       0x426d
   ub2 spare3_kcbh                          @18       0x0000

BBED> sum apply
Check value for File 6, Block 191:
current = 0x4293, required = 0x4293

再回数据库查看该表：

ZBDBA@orcl11g>select * from zbdba;
select * from zbdba
              *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 6, block # 191)
ORA-01110: data file 6: &#39;/opt/oracle/oradata/orcl11g/zbdba01.dbf&#39;

常规坏块的处理方式：
1、event 10231
2、rowid抽取
3、DBMS_REPAIR

这里我用bbed修复该块：

BBED> p kcbh
struct kcbh, 20 bytes                       @0      
   ub1 type_kcbh                            @0        0x06
   ub1 frmt_kcbh                            @1        0xa2
   ub1 spare1_kcbh                          @2        0x00
   ub1 spare2_kcbh                          @3        0x00
   ub4 rdba_kcbh                            @4        0x018000bf
   ub4 bas_kcbh                             @8        0x005036cd
   ub2 wrp_kcbh                             @12       0x0000
   ub1 seq_kcbh                             @14       0xff
   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)
   ub2 chkval_kcbh                          @16       0x4293
   ub2 spare3_kcbh                          @18       0x0000

BBED> p tailchk
ub4 tailchk                                 @8188     0x36cd0601

这里tailchk信息正确，无需修改

BBED> modify /x 01 offset 14
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /opt/oracle/oradata/orcl11g/zbdba01.dbf (6)
Block: 191              Offsets:   14 to  525           Dba:0x018000bf
------------------------------------------------------------------------
01069342 00000100 00000d23 01009636 50000000 00000200 3200b800 80011300
02001800 0000e90b 80021100 38000220 0000cd36 50000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000001 0200ffff 1600851f
6f1f6f1f 00000200 8f1f851f 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> p kcbh
struct kcbh, 20 bytes                       @0      
   ub1 type_kcbh                            @0        0x06
   ub1 frmt_kcbh                            @1        0xa2
   ub1 spare1_kcbh                          @2        0x00
   ub1 spare2_kcbh                          @3        0x00
   ub4 rdba_kcbh                            @4        0x018000bf
   ub4 bas_kcbh                             @8        0x005036cd
   ub2 wrp_kcbh                             @12       0x0000
   ub1 seq_kcbh                             @14       0x01
   ub1 flg_kcbh                             @15       0x06 (KCBHFDLC, KCBHFCKV)
   ub2 chkval_kcbh                          @16       0x4293
   ub2 spare3_kcbh                          @18       0x0000

BBED> sum apply
Check value for File 6, Block 191:
current = 0x426d, required = 0x426d

BBED> verify
DBVERIFY - Verification starting
FILE = /opt/oracle/oradata/orcl11g/zbdba01.dbf
BLOCK = 191


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
Message 531 not found;  product=RDBMS; facility=BBED

再次去数据库查询：

ZBDBA@orcl11g>select * from zbdba;
NAME
------------------------------------------------------------
zbdba
huihui

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

修复：Windows 中的 Discord 游戏检测不工作问题Apr 13, 2023 pm 03:34 PM

Discord 是游戏玩家与其他用户交流时首选的最受欢迎的 VOIP 应用程序。它具有内置的游戏检测功能，允许用户将他/她正在玩的当前游戏的名称广播给其他人。但是，许多用户报告说 Discord 无法检测到他们正在玩的当前游戏。您是否正在为discord中的游戏检测功能停止工作而烦恼？那么你已经到达了正确的帖子。在这里，我们列出了一些故障排除策略，可以帮助您在 Windows PC 上解决此问题。修复 1 – 启用 Discord 游戏检测1. 单击任务栏上的Windows开始按钮。在 Wind

如何修复 Windows 11 / 10 中的坏图像错误 0xc0000020Apr 16, 2023 pm 06:07 PM

许多用户报告在尝试打开WindowsPC上的任何应用程序时看到错误图像错误，错误状态0xc0000020。根据引发错误的应用程序，错误消息表明与应用程序相关的特定DLL文件可能未设计为在Windows上运行或可能遇到任何问题。基本上，此错误是应用程序运行所必需的系统文件损坏的结果。此错误状态0xc0000

如何修复 Windows 11 中的 BackgroundTaskHost.exe 错误Apr 15, 2023 pm 09:13 PM

在您的系统上运行新应用程序时，您是否在屏幕上看到此错误消息-“backgroundTaskHost.exe–ApplicationError”？backgroundTaskHost.exe是与MicrosoftCortana的虚拟助手相关联的关键系统进程。它很少因应用程序崩溃并显示此错误消息。这可能是导致此问题的恶意软件感染的情况。只需遵循这些说明并制定这些修复程序即可快速

无法在 Windows 11 中删除键盘布局？以 3 种简单方法修复Apr 18, 2023 am 09:53 AM

键盘布局是将多种语言输入计算机的好方法，无需专门的硬件。但是，一些用户报告说他们无法在Windows11中删除键盘布局。虽然这不会造成重大问题，但总是有可能错误地选择错误的键盘布局。此外，许多用户更喜欢整洁的PC，没有可能妨碍进度的不必要设置或应用程序，因此需要删除额外的键盘布局。因此，如果您一直在尝试但无法删除Windows11中的键盘布局，这里是解决问题的最有效方法。如果我无法在Windows11中删除键盘布局怎么办？1.使用设置按Windows+I启动设置应用程序，然后从左侧导航

如何在 Windows 11/10 上修复 FFMPEG.DLL Not Found 错误Apr 14, 2023 pm 07:10 PM

最近，Windows用户报告遇到ffmpeg.dll文件丢失或未找到错误。基本上，此错误可能会在应用程序安装时、系统启动时或访问某些网站时引发。当系统文件损坏时，可能会出现ffmpeg.dll错误，从而使系统目录无法发现DLL文件。此错误还与MicrosoftTeams、Skype、Discord、适用于Windows的WhatsApp、Deezer等应用程序相关联。向用户显示的错误消息是：程序无法启动，因为您的计算机缺少ffmpeg.dll。尝试重新安装程序以解决此问题。如果

修复：Microsoft Teams 错误代码 80090016 您的计算机的受信任平台模块出现故障Apr 19, 2023 pm 09:28 PM

MSTeams是与队友和同事交流、聊天或通话的值得信赖的平台。MSTeams上的错误代码为80090016以及您的计算机的受信任的平台模块出现故障的消息可能会导致登录困难。在错误代码得到解决之前，该应用将不允许您登录。如果您在打开MS团队或任何其他Microsoft应用程序时遇到此类消息，那么本文可以指导您解决问题。<h2&

如何修复 Microsoft Office 365 卡在准备就绪上Apr 13, 2023 pm 06:28 PM

许多用户在他们的 Windows PC 上安装Microsoft Office 365时报告了一个问题。问题是安装程序卡在“我们正在准备就绪” 消息上。看到此消息后，用户将无法再次安装 Office 365。当以前的 Office 365 文件未正确安装或损坏时，可能会发生这种情况。有时兼容性问题或安装过程中缺少某些权限可能会导致此错误。在 Office 365 安装过程中，您是否还停留在“准备就绪”错误？然后，继续阅读这篇文章。在这里，我们讨论了一些故障排除策略，可以帮助您解决计算机上的此错误

修复：Windows 11 中的黑色桌面背景显示问题Apr 14, 2023 am 10:49 AM

Windows 11 用户面临的问题之一是从 Windows 10 升级后随机显示黑色桌面背景。根据大多数用户的说法，他们在更改主题或使用新壁纸时在显示器上看到黑色壁纸. 还有一些人在尝试打开“开始”菜单时遇到了显示背景变黑的情况。Windows 11 上出现此问题的原因尚不清楚，但遇到此问题的其他用户已成功尝试了一些修复程序。在本文中，列出了一些可以帮助您在 Windows 11 PC 上解决此问题的解决方案。在继续尝试下面提到的修复之前，请执行系统重新启动并检查是否可以解决问题。修复 1 –

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

Repo: How To Revive Teammates

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hello Kitty Island Adventure: How To Get Giant Seeds

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

How Long Does It Take To Beat Split Fiction?

4 weeks agoByDDD

R.E.P.O. Save File Location: Where Is It & How to Protect It?

4 weeks agoByDDD

Hot Tools

Atom editor mac version download

The most popular open source editor

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),