- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 23:48:58
|
查看: 1780 |
回复: 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
|
|