Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 23:48:58 | 查看: 1507| 回复: 0
[prodora@erpdb prodora]$  /u1/PROD/prodora/proddata/a_media01.dbf
blocksize=8192
DBVERIFY: Release 9.2.0.6.0 - Production onFri Jan 13 17:31:53 2012
Copyright (c) 1982, 2002, OracleCorporation.  All rights reserved.
DBVERIFY - Verification starting : FILE = /u1/PROD/prodora/proddata/a_media01.dbf
Page 325025 is influx - most likely mediacorrupt
***
Corrupt block relative dba: 0x6404f5a1(file 400, block 325025)
Fractured block found during dbv:
Data in bad block -
type:40 format: 2 rdba: 0x6404f5a1
lastchange scn: 0x056d.5bb85d70 seq: 0x2 flg: 0x04
consistency value in tail: 0xef690801
check value in block header: 0xc226, computedblock checksum: 0x6f07
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
DBVERIFY - Verification complete
Total Pages Examined         : 384000
Total Pages Processed (Data) : 15870
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 889
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 273653
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg) : 0
Total Pages Empty            : 93587
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 1
Highest block SCN            : 5967269596707 (1389.1560022563)
====================================================================
[prodora@erpdb prodora]$  /u1/PROD/prodora/proddata/a_txn_ind03.dbf
blocksize=8192
DBVERIFY: Release 9.2.0.6.0 - Production onFri Jan 13 18:23:29 2012
Copyright (c) 1982, 2002, OracleCorporation.  All rights reserved.
DBVERIFY - Verification starting : FILE =/u1/PROD/prodora/proddata/a_txn_ind03.dbf
Page 281442 is influx - most likely mediacorrupt
***
Corrupt block relative dba: 0x65044b62(file 404, block 281442)
Fractured block found during dbv:
Data in bad block -
type: 6 format: 2 rdba: 0x65044b62
lastchange scn: 0x056e.1d68a7b7 seq: 0x4 flg: 0x04
consistency value in tail: 0x70710601
check value in block header: 0x1a24, computedblock checksum: 0xd5c2
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
DBVERIFY - Verification complete
Total Pages Examined         : 384000
Total Pages Processed (Data) : 2189
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 290692
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 23126
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg) : 0
Total Pages Empty            : 67992
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 1
Highest block SCN            : 5975216684949 (1391.917176213)
坏块中的数据己不需要的,磁带机通过bakbone中的oracle rman apm备份时无法效验成功。rman apm又无法跳过坏块,服务器端rman脚本又无法启动磁带机。请高手指点。急啊,这快过年的。备份都无法完成。


沒有rman備份


應該是邏輯的,壞塊所在的數據文件可以被復制。

唉,還是不知道怎么修復。

BBED> verify
DBVERIFY - Verification starting
FILE = /u1/PROD/prodora/proddata/a_media01.dbf
BLOCK = 325025

Block 325025 is corrupt
***
Corrupt block relative dba: 0x6404f5a1 (file 0, block 325025)
Fractured block found during verification
Data in bad block -
type: 40 format: 2 rdba: 0x6404f5a1
last change scn: 0x056d.5bb85d70 seq: 0x2 flg: 0x04
consistency value in tail: 0xef690801
check value in block header: 0xc226, computed block checksum: 0x6f07
spare1: 0x0, spare2: 0x0, spare3: 0x0
***


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
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-18 19:17 , Processed in 0.046204 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569