ITPub博客

首页 > Linux操作系统 > Linux操作系统 > BBED修改数据块里面字符

BBED修改数据块里面字符

原创 Linux操作系统 作者:deitylee 时间:2013-09-26 09:56:40 0 删除 编辑

SSH Secure Shell 3.2.9 (Build 283)
Copyright (c) 2000-2003 SSH Communications Security Corp - http://www.ssh.com/

This copy of SSH Secure Shell is a non-commercial version.
This version does not include PKI and PKCS #11 functionality.


Last login: Wed Sep 25 17:06:45 2013 from 192.168.0.122
[root@OS4 ~]# su - oracle
[oracle@OS4 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 26 09:18:43 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

09:18:43 SQL> conn scott/tiger
Connected.
09:18:48 SQL> select * from emp;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
      7788 SCOTT      ANALYST         7566 19-APR-87       3000                    20
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
      7876 ADAMS      CLERK           7788 23-MAY-87       1100                    20
      7900 JAMES      CLERK           7698 03-DEC-81        950                    30
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-82       1300                    10

14 rows selected.


09:24:45 SQL> select dbms_rowid.rowid_relative_fno(rowid) rel_fno,dbms_rowid.rowid_block_number(rowid) blockno,dbms_rowid.rowid_row_number(rowid) rowno from emp;

   REL_FNO    BLOCKNO      ROWNO
---------- ---------- ----------
         4        151          0
         4        151          1
         4        151          2
         4        151          3
         4        151          4
         4        151          5
         4        151          6
         4        151          7
         4        151          8
         4        151          9
         4        151         10
         4        151         11
         4        151         12
         4        151         13

14 rows selected.

Elapsed: 00:00:00.01


09:31:58 SQL> conn / as sysdba

09:32:30 SQL> select file#,name from v$datafile;

     FILE# NAME
---------- ------------------------------------------------------------
         1 /opt/oracle/oradata/ninvoice/system01.dbf
         2 /opt/oracle/oradata/ninvoice/sysaux01.dbf
         3 /opt/oracle/oradata/ninvoice/undotbs01.dbf
         4 /opt/oracle/oradata/ninvoice/users01.dbf
         5 /opt/oracle/oradata/ninvoice/ninvoice.dbf
         6 /opt/oracle/oradata/ninvoice/NETINVOICE01.dbf
         7 /opt/oracle/oradata/ninvoice/NETINVOICE_IDX01.dbf
         8 /opt/oracle/oradata/ninvoice/MTCLUSTER.dbf
         9 /opt/oracle/oradata/ninvoice/MAIN_MAXVLUES.dbf
        10 /opt/oracle/oradata/ninvoice/MAIN_2010_02.dbf
        11 /opt/oracle/oradata/ninvoice/MAIN_2011_01.dbf
        12 /opt/oracle/oradata/ninvoice/MAIN_2011_02.dbf
        13 /opt/oracle/oradata/ninvoice/MAIN_2012_02.dbf
        14 /opt/oracle/oradata/ninvoice/MAIN_2012_01.dbf
        15 /opt/oracle/oradata/ninvoice/MAIN_2013_01.dbf
        16 /opt/oracle/oradata/ninvoice/MTCLUSTER_IDX.dbf
        17 /opt/oracle/oradata/ninvoice/ggate01.dbf

17 rows selected.

Elapsed: 00:00:00.00
09:32:31 SQL> exit

09:32:37 SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@OS4 ~]$ vi /tmp/f.lst
         1 /opt/oracle/oradata/ninvoice/system01.dbf
         2 /opt/oracle/oradata/ninvoice/sysaux01.dbf
         3 /opt/oracle/oradata/ninvoice/undotbs01.dbf
         4 /opt/oracle/oradata/ninvoice/users01.dbf
         5 /opt/oracle/oradata/ninvoice/ninvoice.dbf
         6 /opt/oracle/oradata/ninvoice/NETINVOICE01.dbf
         7 /opt/oracle/oradata/ninvoice/NETINVOICE_IDX01.dbf
         8 /opt/oracle/oradata/ninvoice/MTCLUSTER.dbf
         9 /opt/oracle/oradata/ninvoice/MAIN_MAXVLUES.dbf
        10 /opt/oracle/oradata/ninvoice/MAIN_2010_02.dbf
        11 /opt/oracle/oradata/ninvoice/MAIN_2011_01.dbf
        12 /opt/oracle/oradata/ninvoice/MAIN_2011_02.dbf
        13 /opt/oracle/oradata/ninvoice/MAIN_2012_02.dbf
        14 /opt/oracle/oradata/ninvoice/MAIN_2012_01.dbf
        15 /opt/oracle/oradata/ninvoice/MAIN_2013_01.dbf
        16 /opt/oracle/oradata/ninvoice/MTCLUSTER_IDX.dbf
        17 /opt/oracle/oradata/ninvoice/ggate01.dbf

~
"/tmp/f.lst" 18L, 948C written

[oracle@OS4 ~]$ bbed listfile= '/tmp/f.lst'
Password:

BBED: Release 2.0.0.0.0 - Limited Production on Thu Sep 26 09:33:30 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED> show all
        FILE#           1
        BLOCK#          1
        OFFSET          0
        DBA             0x00400001 (4194305 1,1)
        FILENAME        /opt/oracle/oradata/ninvoice/system01.dbf
        BIFILE          bifile.bbd
        LISTFILE        /tmp/f.lst
        BLOCKSIZE       8192
        MODE            Browse
        EDIT            Unrecoverable
        IBASE           Dec
        OBASE           Dec
        WIDTH           80
        COUNT           512
        LOGFILE         log.bbd
        SPOOL           No

BBED> set dba 4,151
        DBA             0x01000097 (16777367 4,151)

BBED> d /v
 File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
 Block: 151     Offsets:    0 to  511  Dba:0x01000097
-------------------------------------------------------
 06a20000 97000001 3b590e00 00000106 l .?.....;Y......
 1bf10000 01000000 f11d0100 3a590e00 l .?.....?..:Y..
 00000000 02003200 90000001 0a001b00 l ......2.........
 32020000 cc58c100 5c004500 0e200000 l 2...蘕?\.E.. ..
 3b590e00 00000000 00000000 00000000 l ;Y..............
 00000000 00000000 00000000 00000000 l ................
 00000000 00010e00 ffff2e00 611d331d l ............a.3.
 331d0000 0e00721f 471f1c1f f31ec61e l 3.....r.G...??
 9d1e741e 4c1e261e fb1dd51d af1d881d l ..t.L.&.???..
 611d0000 00000000 00000000 00000000 l a...............
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................

 <16 bytes per line>

BBED> find /c SMITH
 File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
 Block: 151              Offsets: 8158 to 8191           Dba:0x01000097
------------------------------------------------------------------------
 534d4954 4805434c 45524b03 c2500307 77b40c11 01010102 c209ff02 c1150106
 3b59

 <32 bytes per line>

BBED> d /v dba 4,151 offset 8158
 File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
 Block: 151     Offsets: 8158 to 8191  Dba:0x01000097
-------------------------------------------------------
 534d4954 4805434c 45524b03 c2500307 l SMITH.CLERK.翽..
 77b40c11 01010102 c209ff02 c1150106 l w?.....?..?..
 3b59                                l ;Y

 <16 bytes per line>


BBED> m /c DEITY dba 4,151 offset 8158
BBED-00215: editing not allowed in BROWSE mode


BBED> set mode edit
        MODE            Edit

BBED> m /c Deity dba 4,151 offset 8158
 File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
 Block: 151              Offsets: 8158 to 8191           Dba:0x01000097
------------------------------------------------------------------------
 44656974 7905434c 45524b03 c2500307 77b40c11 01010102 c209ff02 c1150106
 3b59

 <32 bytes per line>

BBED> d /v
 File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
 Block: 151     Offsets: 8158 to 8191  Dba:0x01000097
-------------------------------------------------------
 44656974 7905434c 45524b03 c2500307 l Deity.CLERK.翽..
 77b40c11 01010102 c209ff02 c1150106 l w?.....?..?..
 3b59                                l ;Y

 <16 bytes per line>

BBED> sum
Check value for File 4, Block 151:
current = 0xf11b, required = 0xf91d

BBED> sum apply;
Check value for File 4, Block 151:
current = 0xf91d, required = 0xf91d

BBED> exit

[oracle@OS4 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 26 09:39:03 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

09:39:03 SQL> conn scott/tiger
Connected.
09:39:08 SQL> select * from emp;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
      7788 SCOTT      ANALYST         7566 19-APR-87       3000                    20
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
      7876 ADAMS      CLERK           7788 23-MAY-87       1100                    20
      7900 JAMES      CLERK           7698 03-DEC-81        950                    30
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-82       1300                    10

14 rows selected.

Elapsed: 00:00:00.00
09:39:13 SQL> conn / as sysdba
Connected.
09:39:18 SQL> alter system flush buffer_cache;

System altered.

Elapsed: 00:00:00.17
09:39:26 SQL> conn scott/tiger
Connected.
09:39:29 SQL> select * from emp;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 Deity      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
      7788 SCOTT      ANALYST         7566 19-APR-87       3000                    20
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
      7876 ADAMS      CLERK           7788 23-MAY-87       1100                    20
      7900 JAMES      CLERK           7698 03-DEC-81        950                    30
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-82       1300                    10

14 rows selected.

Elapsed: 00:00:00.00
09:39:32 SQL>

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

请登录后发表评论 登录
全部评论

注册时间:2011-10-27

  • 博文量
    74
  • 访问量
    364323