oracle BBED-数据库文件头恢复

一,场景模拟

  01,场景复现

  

 

 

   大概就是先备份一个文件,然后进行归档切换操作,完成后再把旧的system01文件拷贝回去,这样的话system 就是一个旧的时间段了,启动肯定是会报错的.

  

 

 

   查询数据库的scn号看看

  

 

 

  似乎看起来没什么变化

  查看表头试试?

  

 

 

  发现有些不一样, 数据库open 的时候是会检测这个表头信息的,不一致的话肯定开启不了 。

二,问题处理

  01,文件头说明

    因为我们要修改数据文件头,因此我们需要关注四个偏移量offset点,分别为484、492、140和148
    1、datafile 的file header 存储在第一个block里
    2、Oracle considers four attributes of this data structure when determining if a datafile is sync with the other data files of the database:(不同oracle版本offset可能不同)
      (1)kscnbas (at offset 484) – SCN of last change to the datafile.
                (2)kcvcptim (at offset 492) -Time of the last change to the datafile.
                (3)kcvfhcpc (at offset 140) – Checkpoint count.
                (4)kcvfhccc (at offset 148) – Unknown, but is always 1 less than thecheckpoint point count.
                   Oracle有4个属性来判断datafile 是否和其他的datafile 一致,如果都一致,可以正常操作,如果不一致,那么会报ORA-01113错误

   02, 文件头对比查看

    正常文件头信息:

  1 BBED> set filename '/u01/app/oracle/oradata/oracle01/users01.dbf'
  2     FILENAME           /u01/app/oracle/oradata/oracle01/users01.dbf
  3 
  4 BBED>  set offset 494
  5     OFFSET             494
  6 
  7 BBED> dump
  8  File: /u01/app/oracle/oradata/oracle01/users01.dbf (4)
  9  Block: 1                Offsets:  494 to 1005           Dba:0x01000001
 10 ------------------------------------------------------------------------
 11  ab3e0100 bdc8c301 00000200 00001000 00000200 00000000 00000000 00000000
 12  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 13  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 14  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 15  00000000 00000000 00000000 00000000 00000000 00000d00 0d000d00 01000000
 16  00000000 00000000 00000200 000153b0 fe040000 00000000 00000000 00000000
 17  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 18  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 19  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 20  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 21  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 22  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 23  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 24  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 25  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 26  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 27 
 28  <32 bytes per line>
 29 
 30 BBED>  set offset 492
 31     OFFSET             492
 32 
 33 BBED> dump
 34  File: /u01/app/oracle/oradata/oracle01/users01.dbf (4)
 35  Block: 1                Offsets:  492 to 1003           Dba:0x01000001
 36 ------------------------------------------------------------------------
 37  0bb1ab3e 0100bdc8 c3010000 02000000 10000000 02000000 00000000 00000000
 38  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 39  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 40  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 41  00000000 00000000 00000000 00000000 00000000 00000000 0d000d00 0d000100
 42  00000000 00000000 00000000 02000001 53b0fe04 00000000 00000000 00000000
 43  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 44  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 45  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 46  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 47  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 48  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 49  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 50  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 51  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 52  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 53 
 54  <32 bytes per line>
 55 
 56 BBED> set offset 140
 57     OFFSET             140
 58 
 59 BBED> dump
 60  File: /u01/app/oracle/oradata/oracle01/users01.dbf (4)
 61  Block: 1                Offsets:  140 to  651           Dba:0x01000001
 62 ------------------------------------------------------------------------
 63  d5d39f3e 13d29f3e d4d39f3e 0dbe7900 00000000 f121fa3b 0100eb1f 34050000
 64  02000000 10000000 02000000 00000000 00000000 00000000 00000000 00000000
 65  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 66  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 67  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 68  00000000 00000000 00000000 80020000 00000000 00000000 00000000 00000000
 69  04000000 05005553 45525300 00000000 00000000 00000000 00000000 00000000
 70  00000000 04000000 00000000 00000000 00000000 00000000 00000000 00000000
 71  00000000 00000000 00000000 00000000 00000000 3ef4503e 374f9504 00000000
 72  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 73  00000000 00000000 00000000 00000000 00000000 00000000 c0f41a05 00006909
 74  0bb1ab3e 0100bdc8 c3010000 02000000 10000000 02000000 00000000 00000000
 75  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 76  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 77  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 78  00000000 00000000 00000000 00000000 00000000 00000000 0d000d00 0d000100
 79 
 80  <32 bytes per line>
 81 
 82 BBED> set offset 148
 83     OFFSET             148
 84 
 85 BBED> dump
 86  File: /u01/app/oracle/oradata/oracle01/users01.dbf (4)
 87  Block: 1                Offsets:  148 to  659           Dba:0x01000001
 88 ------------------------------------------------------------------------
 89  d4d39f3e 0dbe7900 00000000 f121fa3b 0100eb1f 34050000 02000000 10000000
 90  02000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 91  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 92  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 93  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 94  00000000 80020000 00000000 00000000 00000000 00000000 04000000 05005553
 95  45525300 00000000 00000000 00000000 00000000 00000000 00000000 04000000
 96  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 97  00000000 00000000 00000000 3ef4503e 374f9504 00000000 00000000 00000000
 98  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 99  00000000 00000000 00000000 00000000 c0f41a05 00006909 0bb1ab3e 0100bdc8
100  c3010000 02000000 10000000 02000000 00000000 00000000 00000000 00000000
101  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
102  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
103  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
104  00000000 00000000 00000000 00000000 0d000d00 0d000100 00000000 00000000
105 
106  <32 bytes per line>
View Code

    这个是正确没有问题的一个文件的文件头部信息,你会发现即使你查看其他的数据文件的文件头 进制码依旧一样

    出现故障后的文件头信息:

  1 BBED> d /v dba 1,1 offset 484
  2  File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
  3  Block: 1       Offsets:  484 to  995  Dba:0x00400001
  4 -------------------------------------------------------
  5  e0ed1a05 00000000 0dacab3e 0100bdc8 l 囗.......>..  6  ba010000 02000000 10000000 02000000 l ?..............
  7  00000000 00000000 00000000 00000000 l ................
  8  00000000 00000000 00000000 00000000 l ................
  9  00000000 00000000 00000000 00000000 l ................
 10  00000000 00000000 00000000 00000000 l ................
 11  00000000 00000000 00000000 00000000 l ................
 12  00000000 00000000 00000000 00000000 l ................
 13  00000000 00000000 00000000 00000000 l ................
 14  00000000 00000000 00000000 00000000 l ................
 15  0d000d00 0d000100 00000000 00000000 l ................
 16  00000000 02004000 a4740a05 00000000 l ......@.......
 17  00000000 00000000 00000000 00000000 l ................
 18  00000000 00000000 00000000 00000000 l ................
 19  00000000 00000000 00000000 00000000 l ................
 20  00000000 00000000 00000000 00000000 l ................
 21  00000000 00000000 00000000 00000000 l ................
 22  00000000 00000000 00000000 00000000 l ................
 23  00000000 00000000 00000000 02089b3d l ...............=
 24  9b7de6d3 1a96005b b4f19eb0 ff000000 l .}嬗...[瘩.?...
 25  00000000 00000000 00000000 00000000 l ................
 26  00000000 00300000 00000000 0027f76c l .....0.......' 27  1f748a40 20489c47 0b463176 e0010600 l .t.@ H.G.F1v?..
 28  a4790b05 00000000 00000000 00000000 l ..............
 29  00000000 00000000 00000000 00000000 l ................
 30  00000000 00000000 00000000 00000000 l ................
 31  00000000 00000000 00000000 00000000 l ................
 32  00000000 00000000 00000000 00000000 l ................
 33  00000000 00000000 00000000 00000000 l ................
 34  00000000 00000000 00000000 00000000 l ................
 35  00000000 00000000 00000000 00000000 l ................
 36  00000000 00000000 00000000 00000000 l ................
 37 
 38  <16 bytes per line>
 39 
 40 BBED> map
 41  File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
 42  Block: 1                                     Dba:0x00400001
 43 ------------------------------------------------------------
 44  Data File Header
 45 
 46  struct kcvfh, 860 bytes                    @0
 47 
 48  ub4 tailchk                                @8188
 49 
 50 
 51 BBED> set offset 484
 52     OFFSET             484
 53 
 54 BBED> dump
 55  File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
 56  Block: 1                Offsets:  484 to  995           Dba:0x00400001
 57 ------------------------------------------------------------------------
 58  e0ed1a05 00000000 0dacab3e 0100bdc8 ba010000 02000000 10000000 02000000
 59  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 60  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 61  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 62  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 63  0d000d00 0d000100 00000000 00000000 00000000 02004000 a4740a05 00000000
 64  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 65  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 66  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 67  00000000 00000000 00000000 02089b3d 9b7de6d3 1a96005b b4f19eb0 ff000000
 68  00000000 00000000 00000000 00000000 00000000 00300000 00000000 0027f76c
 69  1f748a40 20489c47 0b463176 e0010600 a4790b05 00000000 00000000 00000000
 70  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 71  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 72  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 73  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 74 
 75  <32 bytes per line>
 76 
 77 BBED> set offset 488
 78     OFFSET             488
 79 
 80 BBED> dump
 81  File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
 82  Block: 1                Offsets:  488 to  999           Dba:0x00400001
 83 ------------------------------------------------------------------------
 84  00000000 0dacab3e 0100bdc8 ba010000 02000000 10000000 02000000 00000000
 85  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 86  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 87  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 88  00000000 00000000 00000000 00000000 00000000 00000000 00000000 0d000d00
 89  0d000100 00000000 00000000 00000000 02004000 a4740a05 00000000 00000000
 90  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 91  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 92  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 93  00000000 00000000 02089b3d 9b7de6d3 1a96005b b4f19eb0 ff000000 00000000
 94  00000000 00000000 00000000 00000000 00300000 00000000 0027f76c 1f748a40
 95  20489c47 0b463176 e0010600 a4790b05 00000000 00000000 00000000 00000000
 96  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 97  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 98  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 99  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
100 
101  <32 bytes per line>
102 
103 BBED> set block 1
104     BLOCK#             1
105 
106 BBED> dump
107  File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
108  Block: 1                Offsets:    0 to  511           Dba:0x00400001
109 ------------------------------------------------------------------------
110  0ba20000 01004000 00000000 00000104 378f0000 00000000 0004200b 8507a39a
111  4f524143 4c453031 c4e3a13e 00620200 00200000 01000300 00000000 00000000
112  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
113  08024000 07000000 00000000 7dc92131 13d29f3e d18c0b05 00000000 00000000
114  00000000 00000000 00000420 ced39f3e 13d29f3e cdd39f3e 00000000 00000000
115  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
116  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
117  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
118  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
119  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
120  00000000 00000000 00000000 00000000 06005359 5354454d 00000000 00000000
121  00000000 00000000 00000000 00000000 01000000 00000000 00000000 00000000
122  00000000 00000000 00000000 00000000 00000000 00000000 00000000 0a000a00
123  3ef4503e 374f9504 00000000 00000000 00000000 00000000 00000000 00000000
124  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
125  00000000 e0ed1a05 00000000 0dacab3e 0100bdc8 ba010000 02000000 10000000
126 
127  <32 bytes per line>
128 
129 BBED> set mode edit
130     MODE               Edit
131 
132 BBED> set offset 484
133     OFFSET             484
134 
135 BBED> dump
136  File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
137  Block: 1                Offsets:  484 to  995           Dba:0x00400001
138 ------------------------------------------------------------------------
139  e0ed1a05 00000000 0dacab3e 0100bdc8 ba010000 02000000 10000000 02000000
140  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
141  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
142  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
143  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
144  0d000d00 0d000100 00000000 00000000 00000000 02004000 a4740a05 00000000
145  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
146  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
147  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
148  00000000 00000000 00000000 02089b3d 9b7de6d3 1a96005b b4f19eb0 ff000000
149  00000000 00000000 00000000 00000000 00000000 00300000 00000000 0027f76c
150  1f748a40 20489c47 0b463176 e0010600 a4790b05 00000000 00000000 00000000
151  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
152  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
153  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
154  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
155 
156  <32 bytes per line>
View Code

    会发现这两个文件头对比不一致,数据库启动的话会校对所有文件的文件头,所以我们现在要做的是修改数据库的文件头信息

  03, BBED配置

  •     配置数据文件
SQL>  select file#||' '||name||' '||bytes from v$datafile ;

FILE#||''||NAME||''||BYTES
--------------------------------------------------------------------------------
1 /u01/app/oracle/oradata/oracle01/system01.dbf 1279262720
2 /u01/app/oracle/oradata/oracle01/sysaux01.dbf 4760535040
3 /u01/app/oracle/oradata/oracle01/undotbs01.dbf 304087040
4 /u01/app/oracle/oradata/oracle01/users01.dbf 6553600
5 /u01/app/oracle/oradata/oracle01/example01.dbf 363069440
6 /data/oradata/example01.dbf## 10485760
7 /u01/app/oracle/oradata/oracle01/example01.dbf## 10485760
8 /data/oradata/undo2.dbf 1073741824
9 /u01/app/oracle/oradata/oracle01/test101.dbf 10485760
10 /u01/app/oracle/oradata/oracle01/demo01.dbf 10485760
11 /u01/app/oracle/oradata/oracle01/test102.dbf 104857600

FILE#||''||NAME||''||BYTES
--------------------------------------------------------------------------------
12 /u01/app/oracle/oradata/oracle01/waterboss2.dbf 10485760
13 /data/oradata/demo01.dbf 10485760
14 /data/oradata/test102.dbf 10485760
15 /data/oradata/test101.dbf 10485760
16 /data/oradata/users01.dbf 10485760
17 /data/oradata/example01.dbf 10485760
18 /data/oradata/waterboss2.dbf 10485760

18 rows selected.


[oracle@oracle01 BBED]$ cat db.txt
1 /u01/app/oracle/oradata/oracle01/system01.dbf 1279262720
2 /u01/app/oracle/oradata/oracle01/sysaux01.dbf 4760535040
3 /u01/app/oracle/oradata/oracle01/undotbs01.dbf 304087040
4 /u01/app/oracle/oradata/oracle01/users01.dbf 6553600
5 /u01/app/oracle/oradata/oracle01/example01.dbf 363069440
6 /data/oradata/example01.dbf## 10485760
7 /u01/app/oracle/oradata/oracle01/example01.dbf## 10485760
8 /data/oradata/undo2.dbf 1073741824
9 /u01/app/oracle/oradata/oracle01/test101.dbf 10485760
10 /u01/app/oracle/oradata/oracle01/demo01.dbf 10485760
11 /u01/app/oracle/oradata/oracle01/test102.dbf 104857600
12 /u01/app/oracle/oradata/oracle01/waterboss2.dbf 10485760
13 /data/oradata/demo01.dbf 10485760
14 /data/oradata/test102.dbf 10485760
15 /data/oradata/test101.dbf 10485760
16 /data/oradata/users01.dbf 10485760
17 /data/oradata/example01.dbf 10485760
18 /data/oradata/waterboss2.dbf 10485760

[oracle@oracle01 BBED]$ cat par.bbd
blocksize=8192
listfile=db.txt
mode=edit
  •   启动bbed
[oracle@oracle01 BBED]$ bbed parfile=par.bbd
Password:

BBED: Release 2.0.0.0.0 - Limited Production on Fri Sep 18 12:39:27 2020

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

************* !!! For Oracle Internal Use only !!! ***************

BBED>
  •   修改表头信息,表头信息修改成 正确的表头即可,即上面查询的信息
BBED> set filename '/u01/app/oracle/oradata/oracle01/system01.dbf'
    FILENAME           /u01/app/oracle/oradata/oracle01/system01.dbf

BBED> set offset 484
    OFFSET             484

BBED> m /x c0f41a05 484  
BBED-00209: invalid number (c0f41a05)   ---由于这个信息表头高位,输入前4为字符就行了


BBED> m /x d4d39f3e 148
BBED-00209: invalid number (d4d39f3e)  


BBED> m /x c0f4 484
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
 File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
 Block: 1                Offsets:  484 to  995           Dba:0x00400001
------------------------------------------------------------------------
 c0f41a05 00000000 0dacab3e 0100bdc8 ba010000 02000000 10000000 02000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 0d000d00 0d000100 00000000 00000000 00000000 02004000 a4740a05 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 02089b3d 9b7de6d3 1a96005b b4f19eb0 ff000000
 00000000 00000000 00000000 00000000 00000000 00300000 00000000 0027f76c
 1f748a40 20489c47 0b463176 e0010600 a4790b05 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

 <32 bytes per line>

BBED> m /x d4d3 148
 File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
 Block: 1                Offsets:  148 to  659           Dba:0x00400001
------------------------------------------------------------------------
 d4d39f3e 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 06005359
 5354454d 00000000 00000000 00000000 00000000 00000000 00000000 01000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 0a000a00 3ef4503e 374f9504 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 c0f41a05 00000000 0dacab3e 0100bdc8
 ba010000 02000000 10000000 02000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 0d000d00 0d000100 00000000 00000000

 <32 bytes per line>

BBED> m /x d5d3 140
 File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
 Block: 1                Offsets:  140 to  651           Dba:0x00400001
------------------------------------------------------------------------
 d5d39f3e 13d29f3e d4d39f3e 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 06005359 5354454d 00000000 00000000 00000000 00000000 00000000
 00000000 01000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 0a000a00 3ef4503e 374f9504 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 c0f41a05 00000000
 0dacab3e 0100bdc8 ba010000 02000000 10000000 02000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 0d000d00 0d000100

 <32 bytes per line>

BBED> m /x 0bb1 492
 File: /u01/app/oracle/oradata/oracle01/system01.dbf (1)
 Block: 1                Offsets:  492 to 1003           Dba:0x00400001
------------------------------------------------------------------------
 0bb1ab3e 0100bdc8 ba010000 02000000 10000000 02000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 0d000d00 0d000100
 00000000 00000000 00000000 02004000 a4740a05 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 02089b3d 9b7de6d3 1a96005b b4f19eb0 ff000000 00000000 00000000
 00000000 00000000 00000000 00300000 00000000 0027f76c 1f748a40 20489c47
 0b463176 e0010600 a4790b05 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

 <32 bytes per line>

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

BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/oracle01/system01.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
  •   sql查看数据表头信息看是否一致

 

  可以看到头部信息已经一致了

 我们重新启动数据库看看

 

 

   我直接启动成功了

  如果还是失败的话  recover database 一下再启动

 

-到这里恢复完成~有什么错误欢迎指正

posted on 2020-09-18 12:47  kingle-l  阅读(576)  评论(0编辑  收藏  举报

levels of contents