使用bbed将属于前一个incarnation 的 offline的 datafile弄成online状态:
背景:
'/u01/app/oracle/oradata/test/ten01.dbf' 是属于前一个incarnation 的 offline的 datafile。操作系统为RHEL6.3 x86-64bit
首先:
找到system01.dbf,确认其resetlogs 相关信息:
kcvfhrlc表示 reset logs count
kcvfhrls表示 resetlogs scn
===============================下面是system01.dbf的信息=======================================
BBED> set filename '/u01/app/oracle/oradata/test/system01.dbf'
FILENAME /u01/app/oracle/oradata/test/system01.dbf
BBED> p kcvfhrlc
ub4 kcvfhrlc @112 0x344ba60f ---->
BBED> p kcvfhrls
struct kcvfhrls, 8 bytes @116
ub4 kscnbas @116 0x0036a289 ---->
ub2 kscnwrp @120 0x0000
BBED> p kcvcpscn
BBED-00207: invalid offset specifier (kcvcpscn)
BBED> p kscnbas
BBED-00207: invalid offset specifier (kscnbas)
BBED> p kcvfhckp
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0x0036bbd9
ub2 kscnwrp @488 0x0000
ub4 kcvcptim @492 0x344c30df
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x00000001
ub4 kcrbabno @504 0x00002dbe
ub2 kcrbabof @508 0x0010
ub1 kcvcpetb[0] @512 0x02
ub1 kcvcpetb[1] @513 0x00
ub1 kcvcpetb[2] @514 0x00
ub1 kcvcpetb[3] @515 0x00
ub1 kcvcpetb[4] @516 0x00
ub1 kcvcpetb[5] @517 0x00
ub1 kcvcpetb[6] @518 0x00
ub1 kcvcpetb[7] @519 0x00
BBED> p kcvfhcpc
ub4 kcvfhcpc @140 0x0000016a ---->
BBED> p kcvfhccc
ub4 kcvfhccc @148 0x00000169 ---->
?
=================================下面是ten01.dbf的信息========================================
?
BBED> set filename '/u01/app/oracle/oradata/test/ten01.dbf'
FILENAME /u01/app/oracle/oradata/test/ten01.dbf
------------------------如下是改kcvfhrlc------------------------------
BBED> p kcvfhrlc
ub4 kcvfhrlc @112 0x30274f37
BBED> m /x 0fa64b34
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) Y
File: /u01/app/oracle/oradata/test/ten01.dbf (5)
Block: 1 Offsets: 112 to 623 Dba:0x01400001
------------------------------------------------------------------------
0fa64b34 dc300f00 00000000 00000000 00000000 00000000 00000400 68010000
91a24b34 c8b53600 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 06000000
06005445 4e544253 00000000 00000000 00000000 00000000 00000000 00000000
05000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 5c776c2d 01000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 c8b53600 00000000 5dc94b34
01000000 98000000 2cb60000 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
<32 bytes per line>
?
?
--------------------------------------------------------如下是改kcvfhrls---