设为首页 加入收藏

TOP

使用bbed将属于前一个incarnation的offline的datafile弄成online状态(一)
2015-11-21 01:49:06 来源: 作者: 【 】 浏览:5
Tags:使用 bbed 属于 一个 incarnation offline datafile 弄成 online 状态

使用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---

首页 上一页 1 2 3 4 5 下一页 尾页 1/5/5
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇withgrantoption与withadminoptio.. 下一篇ConsecutiveNumbers

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: