跳过归档日志的完全非常规恢复(五)

跳过归档日志的完全非常规恢复(一) http://blog.chinaunix.net/uid-22948773-id-3294762.html
跳过归档日志的完全非常规恢复(二) http://blog.chinaunix.net/uid-22948773-id-3294763.html
跳过归档日志的完全非常规恢复(三) http://blog.chinaunix.net/uid-22948773-id-3294767.html
跳过归档日志的完全非常规恢复(四) http://blog.chinaunix.net/uid-22948773-id-3294770.html
跳过归档日志的完全非常规恢复(五) http://blog.chinaunix.net/uid-22948773-id-3294773.html

 

 

 

下面我们进行修改上面提到的3个地方，由于我的是LINUX平台属于LITTLE的字节序，因此修改的时候要注意顺序。

修改的时候 0000cf792 需要写成92f70c00的形式。

 

 

BBED> set offset 484
        OFFSET 484

BBED> dump /v count 16
 File: /u01/app/oracle/oradata/huateng/htyansp01.dbf (0)
 Block: 1 Offsets: 484 to 499 Dba:0x00000000
-------------------------------------------------------

 86f70c00 00000000 7317172f 01000000 l ........s../....

 <16 bytes per line>

BBED> set mode edit
        MODE Edit

BBED> modify /x 92
 File: /u01/app/oracle/oradata/huateng/htyansp01.dbf (0)
 Block: 1 Offsets: 484 to 499 Dba:0x00000000
------------------------------------------------------------------------

 92f70c00 00000000 7317172f 01000000

 <32 bytes per line>

BBED> set offset 492
        OFFSET 492

BBED> dump /v count 16
 File: /u01/app/oracle/oradata/huateng/htyansp01.dbf (0)
 Block: 1 Offsets: 492 to 507 Dba:0x00000000
-------------------------------------------------------

 7317172f 01000000 09000000 02000000 l s../............

 <16 bytes per line>

BBED> modify /x 82
 File: /u01/app/oracle/oradata/huateng/htyansp01.dbf (0)
 Block: 1 Offsets: 492 to 507 Dba:0x00000000
------------------------------------------------------------------------

 8217172f 01000000 09000000 02000000

 <32 bytes per line>

BBED> set offset 500
        OFFSET 500

BBED> dump /v count 16
 File: /u01/app/oracle/oradata/huateng/htyansp01.dbf (0)
 Block: 1 Offsets: 500 to 515 Dba:0x00000000
-------------------------------------------------------

 09000000 02000000 00006c10 02000000 l ..........l.....

 <16 bytes per line>

BBED> modify /x 0a
 File: /u01/app/oracle/oradata/huateng/htyansp01.dbf (0)
 Block: 1 Offsets: 500 to 515 Dba:0x00000000
------------------------------------------------------------------------

 0a000000 02000000 00006c10 02000000

 <32 bytes per line>

 BBED> sum apply
Check value for File 0, Block 1:
current = 0xc4e2, required = 0xc4e2

重新进行RECOVER

 

 

[oracle@db2server ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 31 01:22:14 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> recover datafile 6
Media recovery complete.
SQL> alter database datafile 6 online;

Database altered.

SQL> alter database open;

Database altered.

SQL> select * from htyansp.test;

SEQ
--------------------

sequence 7
sequence 8
sequence 10
sequence 11

SQL>

 

由于记录"sequence 9" 没有应用归档日志文件9，导致丢失。