利用BBED恢复数据文件头 - 数据库编程

.dbf (5) Block: 1 Offsets: 484 to 503 Dba:0x01400001 ------------------------------------------------------------------------ 1bb31900 00000000 2199a532 01000000 02000000 BBED> d /v offset 492 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5) Block: 1 Offsets: 492 to 511 Dba:0x01400001 ------------------------------------------------------- 2199a532 01000000 02000000 e0020000 l !.￥2........à... 10007261 BBED> m /x f99a offset 492 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5) Block: 1 Offsets: 492 to 511 Dba:0x01400001 ------------------------------------------------------------------------ f99aa532 01000000 02000000 e0020000 10007261
##################校验块

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

BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/PROD/tp01.dbf
BLOCK = 1


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   : 0
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED

######################检查物理坏块

[oracle@jfdb PROD]$ dbv file=tp01.dbf start=1 end=2

DBVERIFY: Release 11.2.0.3.0 - Production on Sun Jun 8 21:48:37 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/PROD/tp01.dbf


DBVERIFY - Verification complete

Total Pages Examined         : 2
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 2
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 0
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 1687542 (0.1687542)

############打开数据库报错

sys@PROD> shutdown abort;
ORACLE instance shut down.
sys@PROD> startup
ORACLE instance started.

Total System Global Area  939495424 bytes
Fixed Size                  2233960 bytes
Variable Size             251660696 bytes
Database Buffers          679477248 bytes
Redo Buffers                6123520 bytes
Database mounted.
ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: '/u01/app/oracle/oradata/PROD/tp01.dbf'
ORA-01207: file is more recent than control file - old control file

###########怀疑检查点计数器，这里我先用BBED（方法1重建控制文件，方法2利用BBED修改计算器）

ub4 kcvfhcpc @140 0x00000102

idle> alter session set events 'immediate trace name controlf level 8';

Session altered.

DATA FILE #5: 
  name #4: /u01/app/oracle/oradata/PROD/tp01.dbf
creation size=0 block size=8192 status=0xe head=4 tail=4 dup=1
 tablespace 5, index=5 krfil=5 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:226 scn: 0x0000.0019b31b 06/08/2014 15:38:33
 Stop scn: 0xffff.ffffffff 06/08/2014 07:44:07
 Creation Checkpointed at scn:  0x0000.00058d91 03/29/2014 10:32:22
 thread:0 rba:(0x0.0.0)

sys@PROD> select to_char('226','xxxxxxxxxxxxx') from dual;

TO_CHAR('226',
--------------
            e2

sys@PROD> select to_char('225','xxxxxxxxxxxxx') from dual;

TO_CHAR('225',
--------------
            e1

BBED> d /v offset 140
 File: /u0

利用BBED恢复数据文件头(六)