1. 首页
  2. IT资讯

[20180604]在内存修改数据(bbed).txt

[20180604]在内存修改数据(bbed).txt

–//以前曾经做过在内存修改数据,通过oradebug poke命令修改内存信息,相关链接:
–//http://blog.itpub.net/267265/viewspace-2124466/=>[20160904]在内存修改数据.txt

–//今天测试看看是否通过bbed修改数据信息的情况.使用asmm,这样/dev/shm可以看到一个一个文件。

1.环境:
SCOTT@book> @ ver1
PORT_STRING                    VERSION        BANNER
—————————— ————– ——————————————————————————–
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

2.建立测试:

create table t1 (id number,name varchar2(20));
insert into t1 values (1,’AAAAAAAAAAB’);
commit ;

SCOTT@book> select rowid,t1.* from t1;
ROWID                      ID NAME
—————— ———- ——————–
AAAWQKAAEAAAAJcAAA          1 AAAAAAAAAAB

SCOTT@book> @ &r/rowid AAAWQKAAEAAAAJcAAA
    OBJECT       FILE      BLOCK        ROW ROWID_DBA            DBA                  TEXT
———- ———- ———- ———- ——————– ——————– —————————————-
     91146          4        604          0  0x100025C           4,604                alter system dump datafile 4 block 604 ;

SYS@book> create pfile=’/tmp/@.ora’ from spfile;
File created.

–//修改/tmp/book.ora参数,加入
*.memory_target=5120M
*.memory_max_target=5120M
–//注:注意检查use_large_pages参数,我的设置*.use_large_pages=’ONLY’,无法启动,报
SYS@book> startup pfile=/tmp/book.ora
ORA-27125: unable to create shared memory segment

–//使用参数/tmp/book.ora参数启动数据库,这样采用asmm方式.
SYS@book> startup pfile=/tmp/book.ora
ORACLE instance started.
Total System Global Area 1068994560 bytes
Fixed Size                  2259960 bytes
Variable Size             423625736 bytes
Database Buffers          637534208 bytes
Redo Buffers                5574656 bytes
Database mounted.
Database opened.

# ls -l /dev/shm/ora_book_*|wc

–//加载对应数据块到内存:
SCOTT@book> select rowid,t1.* from t1;
ROWID                      ID NAME
—————— ———- ——————–
AAAWQKAAEAAAAJcAAA          1 AAAAAAAAAAB

SYS@book> @ &r/bh 4 604
HLADDR              DBARFIL     DBABLK      CLASS CLASS_TYPE         STATE             TCH CR_SCN_BAS CR_SCN_WRP CR_UBA_FIL CR_UBA_BLK CR_UBA_SEQ BA               OBJECT_NAME
—————- ———- ———- ———- —————— ———- ———- ———- ———- ———- ———- ———- —————- ——————–
000000009DFCB238          4        604          1 data block         xcur                1          0          0          0          0          0 0000000081C14000 T1

3.在内存修改数据:
# strings -f -t d /dev/shm/ora_book_* | grep AAAAAAAAAAB
/dev/shm/ora_book_265158658_132:   90097 AAAAAAAAAAB
/dev/shm/ora_book_265158658_132: 3055545        3*AC60AAABAAAAAAAAAAAAAAAAAAAAAAB6UEsFBgAAAAABAAEALwAAABEXAAAAAA==

–//90097/8192 = 10.99816894531250000000
–//确定字符串AAAAAAAAAAB在那个文件.可以确定/dev/shm/ora_book_265158658_132.因为仅仅插入1条,应该在块的底部.

4.使用bbed修改:
BBED> set filename ‘/dev/shm/ora_book_265158658_132’
        FILENAME        /dev/shm/ora_book_265158658_132

BBED> set blocksize 8192
        BLOCKSIZE       8192

–//注意一定要设置这个参数.不然看到的块大小是512
BBED> show
        FILE#           0
        BLOCK#          1
        OFFSET          0
        DBA             0x00000000 (0 0,1)
        FILENAME        /dev/shm/ora_book_265158658_132
        BIFILE          bifile.bbd
        LISTFILE        /home/oracle/bbed/filelist.txt
        BLOCKSIZE       512
        MODE            Edit
        EDIT            Unrecoverable
        IBASE           Dec
        OBASE           Dec
        WIDTH           160
        COUNT           64
        LOGFILE         log.bbd
        SPOOL           Yes

BBED> set block 11
        BLOCK#          11
–//因为这个内存文件的第一块非文件头.所以block=11.

BBED> x /rnc *kdbr[0]
rowdata[0]                                  @8170
———-
flag@8170: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8171: 0x01
cols@8172:    2

col    0[2] @8173: 1
col   1[11] @8176: AAAAAAAAAAB

–//确定偏移量:
BBED> dump offset 8176
File: /dev/shm/ora_book_265158658_132 (0)
Block: 11                                                   Offsets: 8176 to 8191 Dba:0x00000000
————————————————————————————————–
0b414141 41414141 41414142 0106a09c
<64 bytes per line>

BBED> modify /c ‘ABCD’ offset 8177
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /dev/shm/ora_book_265158658_132 (0)
Block: 11                                                   Offsets: 8177 to 8191 Dba:0x00000000
————————————————————————————————–
41424344 41414141 41414201 06a09c

–//再次查询看看.
SYS@book> select rowid,t1.* from scott.t1;
ROWID                      ID NAME
—————— ———- ——————–
AAAWQKAAEAAAAJcAAA          1 ABCDAAAAAAB

–//注:我并没有做检查和,sum apply.
–//我已经通过内存篡改了信息.

SYS@book> alter system flush BUFFER_CACHE;
System altered.

SYS@book> select rowid,t1.* from scott.t1;
ROWID                      ID NAME
—————— ———- ——————–
AAAWQKAAEAAAAJcAAA          1 AAAAAAAAAAB

–//现在有正常显示回来.

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

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/182820.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code