ITPub博客

首页 > 数据库 > Oracle > [20161129]BBED-00209 invalid number.txt

[20161129]BBED-00209 invalid number.txt

原创 Oracle 作者:lfree 时间:2016-11-29 10:44:47 0 删除 编辑

[20161129]BBED-00209 invalid number (9524782f).txt

--以前遇到的问题,现在补充测试看看。
BBED> modify /x 9524782f  offset 492
BBED-00209: invalid number (9524782f)

BBED> info
File#  Name                              Size(blks)
-----  ----                              ----------
     1  /mnt/ramdisk/book/system01.dbf             0
     2  /mnt/ramdisk/book/sysaux01.dbf             0
     3  /mnt/ramdisk/book/undotbs01.dbf            0
     4  /mnt/ramdisk/book/users01.dbf              0
     5  /mnt/ramdisk/book/example01.dbf            0
     6  /mnt/ramdisk/book/sugar01.dbf              0

BBED> p kcvfh.kcvfhckp.kcvcptim
ub4 kcvcptim                                @492      0x37622b08

BBED> dump /v offset 492 count 4
File: /mnt/ramdisk/book/sugar01.dbf (6)
Block: 1                                 Offsets:  492 to  495                            Dba:0x01800001
-----------------------------------------------------------------------------------------------------------
082b6237                                                                l .+b7
<32 bytes per line>

BBED> modify /x 082b6237  offset 492
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /mnt/ramdisk/book/sugar01.dbf (6)
Block: 1                                                    Offsets:  492 to  495                                               Dba:0x01800001
------------------------------------------------------------------------------------------------------------------------------------------------
082b6237

<64 bytes per line>

--修改第1个字符是大于8问题就出现,感觉就是高位是1问题出现。

BBED> modify /x 882b6237  offset 492
BBED-00209: invalid number (882b6237)

BBED> modify /x 782b6237  offset 492
File: /mnt/ramdisk/book/sugar01.dbf (6)
Block: 1                                                    Offsets:  492 to  495                                               Dba:0x01800001
------------------------------------------------------------------------------------------------------------------------------------------------
782b6237
<64 bytes per line>

--现在才明白为什么有时候ok,有时候失败。

BBED> assign kcvfh.kcvfhckp.kcvcptim=0x37622b08
ub4 kcvcptim                                @492      0x37622b08

BBED> assign kcvfh.kcvfhckp.kcvcptim=0x37622b88
ub4 kcvcptim                                @492      0x37622b88

BBED> dump /v offset 492 count 4
File: /mnt/ramdisk/book/sugar01.dbf (6)
Block: 1                                 Offsets:  492 to  495                            Dba:0x01800001
-----------------------------------------------------------------------------------------------------------
882b6237                                                                l .+b7

<32 bytes per line>

--建议以后使用assign命令。这样没有太小头问题,终于找到答案。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/267265/viewspace-2129278/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    4006
  • 访问量
    7969347