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>
这个是正确没有问题的一个文件的文件头部信息,你会发现即使你查看其他的数据文件的文件头 进制码依旧一样
出现故障后的文件头信息:
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>
会发现这两个文件头对比不一致,数据库启动的话会校对所有文件的文件头,所以我们现在要做的是修改数据库的文件头信息
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 一下再启动
-到这里恢复完成~有什么错误欢迎指正