.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