Oracle 10g 裸设备数据文件恢复,ORA-19501、ORA-27063(二)

2014-11-24 17:41:24 · 作者: · 浏览: 2
te(2, " ) d u r i n g ", 9) = 9
598170: kwrite(2, " v e r i f i c a t i o n".., 17) = 17
598170: kwrite(2, " o p e r a t i o n (", 12) = 12
598170: kwrite(2, " -", 1) = 1
598170: kwrite(2, " 2", 1) = 1
598170: kwrite(2, " )", 1) = 1
598170: kwrite(2, "\n", 1) = 1
598170: close(5) = 0
598170: close(4) = 0
598170: kfcntl(1, F_GETFL, 0x00000000101A2087) = 67110914
598170: kfcntl(2, F_GETFL, 0x00000000101A2087) = 67110914
598170: _exit(1)
...skipping...
598170: kread(5, " ( ?0\011 D 5 .., 8192) = 8192
598170: klseek(5, 1461190656, 0, 0x0FFFFFFFFFFF9530) = 0
598170: kread(5, " ( ?0\011 D 5 .., 8192) Err#5 EIO
598170: kwrite(2, "\n D B V - 0 0 1 0 2 : ", 12) = 12
598170: kwrite(2, " F i l e I / O e r r".., 24) = 24
598170: kwrite(2, " / d e v / r d a t a _ c".., 15) = 15
598170: kwrite(2, " ) d u r i n g ", 9) = 9
598170: kwrite(2, " v e r i f i c a t i o n".., 17) = 17
598170: kwrite(2, " o p e r a t i o n (", 12) = 12
598170: kwrite(2, " -", 1) = 1
598170: kwrite(2, " 2", 1) = 1
598170: kwrite(2, " )", 1) = 1
598170: kwrite(2, "\n", 1) = 1
598170: close(5) = 0
598170: close(4) = 0
598170: kfcntl(1, F_GETFL, 0x00000000101A2087) = 67110914
598170: kfcntl(2, F_GETFL, 0x00000000101A2087) = 67110914
598170: _exit(1)
找到开始的坏块
1461190656/8192=178368
说明第一个坏块为178368,验证最后的坏块,最大的数据块是1280000


$ dbv file=/dev/rdata_03 blocksize=8192 start=1461190656


DBVERIFY: Release 10.2.0.1.0 - Production on Thu Nov 7 10:10:58 2013


Copyright (c) 1982, 2005, Oracle. All rights reserved.



DBV-00102: File I/O error on FILE (/dev/rdata_03) during start read operation (-2)


$ dbv file=/dev/rdata_03 blocksize=8192 start=194719


DBVERIFY: Release 10.2.0.1.0 - Production on Thu Nov 7 10:52:56 2013


Copyright (c) 1982, 2005, Oracle. All rights reserved.


DBVERIFY - Verification starting : FILE = /dev/rdata_03



DBVERIFY - Verification complete


Total Pages Examined : 1085282
Total Pages Processed (Data) : 1272
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 127
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1082867
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 1016
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 1845997064 (2919.1845997064)


采用数据拼接的模式重构这个数据文件


$ dd if=/dev/zero of=/backup_dir/rdata_03_02 bs=8192 count=16343
16343+0 records in.
16343+0 records out.
$ dd if=/dev/rdata_03 of=/backup_dir/rdata_03_03 bs=8192 skip=194710
1116010+0 records in.
1116010+0 records out.
$ dd if=/dev/rdata_03 of=/backup_dir/rdata_03_01 bs=8192 count=178367
178367+0 records in.
178367+0 records out.
$ cat /backup_dir/rdata_03_01 /backup_dir/rdata_03_02 /backup_dir/rdata_03_03 > /backup_dir/rdata_03_ct


相关阅读: