Phone:18180207355 提供专业Oracle&MySQL数据恢复、性能优化、迁移升级、紧急救援等服务

前不久恢复了一个10201 for windows的库,由于坏块导致数据库异常。
我们知道,对于windows来说,相比unix或linux 操作起来更麻烦,其实windows也是可以使用dd的,
运用dd和UE基本上可以起到和使用bbed一样的效果。大家可以在这里下载dd for win版本dd-0.6beta3

说明一下的是,我这里直接修改了块头中的flg,将其修改为0xff,oracle将直接标记为物理坏块。

修复坏块的方式大家都知道有很多,我就不多说了,我这里需要说的是,windows下我用dd将该block取出来。
然后使用bbed进行修改(当然,既然我们能用UE制造坏块,那么也就可以完全用UE来修复坏块,只是非常难)

由于我这里是10204的,所以就不用9iR2的bbed for win版本了,我将dd出来的file 5.13.dd文件传到linux中,进行修复

如上是通过bbed来修改的,当然,我们还可以用dbms_repair包来操作,它实质是对坏块进行标记,
然后oracle在做扫描block的时候,会跳过该坏块,类似event 10231.

可以发现,完全跳过了坏块file 5 block 13,现在正常数据是300条(其中坏块13中包含数据199条).

补充一点的是,我们还可以使用基于rowid扫描,将test1表中的其他数据给提取出来。

如下是利用基于rowid扫描的方式保存除坏块以外的正常数据:

最后再补充一点的是,如果表有索引,那么记得操作完以后记得rebuild index。

    分享到:
  • I’m sorry to annoy you like this but I just discovered your website and have to admit it’s outstanding. The one thing that I think would help you however is the SEOpressor wordpress plugin. It is frankly the greatest SEO plugin for wordpress blogs that exists today. In exactly Five days my site went from obscurity to the very first page of google after utilizing the SEOpressor plugin. If you’re serious about SEO you can get it here

  • thank you

  • Good blog with some exciting information. I will be back.

  • I appreciate your work , appreciate it for all the great articles .

  • Wow! Thank you! I continuously needed to write on my blog something like that. Can I implement a part of your post to my site?

  • You are a very intelligent person!

  • hi. i love your blog love wife & love life ——Roger » Blog Archive » 如何在windows下运用dd来下修复坏块? and will certainly do a link to http://www.killdb.com/?p=169 on my site.

  • Very interesting subject , thanks for posting .

  • Some truly interesting information, well written and loosely user friendly .

18180207355
加Q咨询