oracle10g bbed的安装

BBED全称oracle block brower and editor tool，可以用来更改数据block。

安装过程如下：

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Linking BBED utility (bbed)
rm -f /oracle/CATY12/home/products/10203/rdbms/lib/bbed
/usr/ccs/bin/ld -o /oracle/CATY12/home/products/10203/rdbms/lib/bbed
-L/oracle/CATY12/home/products/10203/rdbms/lib/
-L/oracle/CATY12/home/products/10203/lib/ -dy
/oracle/CATY12/home/products/10203/lib/prod/lib/v9/crti.o
/oracle/CATY12/home/products/10203/lib/prod/lib/v9/crt1.o
/oracle/CATY12/home/products/10203/lib/s0main.o
/oracle/CATY12/home/products/10203/rdbms/lib/ssbbded.o
/oracle/CATY12/home/products/10203/rdbms/lib/sbbdpt.o `cat
/oracle/CATY12/home/products/10203/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10
-lnzjs10 -ln10 -lnnz10 -lnl10
/oracle/CATY12/home/products/10203/rdbms/lib/defopt.o  -ldbtools10 -lclntsh
`cat /oracle/CATY12/home/products/10203/lib/ldflags`    -lnsslb10 -lncrypt10
-lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat
/oracle/CATY12/home/products/10203/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10
-lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10  -lvsn10  -lcommon10
-lgeneric10 -lmm -lsnls10 -lnls10  -lcore10 -lsnls10  -lnls10 -lcore10 -lsnls10
-lnls10 -lxml10  -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat
/oracle/CATY12/home/products/10203/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10
-lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat
/oracle/CATY12/home/products/10203/lib/ldflags`    -lnsslb10 -lncrypt10 -lnsgr10
-lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10  -lvsn10  -lcommon10
-lgeneric10   -lsnls10 -lnls10  -lcore10 -lsnls10  -lnls10 -lcore10 -lsnls10
-lnls10 -lxml10  -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10  -lclient10
-lnnetd10  -lvsn10  -lcommon10 -lgeneric10 -lsnls10 -lnls10  -lcore10 -lsnls10
-lnls10 -lcore10 -lsnls10 -lnls10 -lxml10  -lcore10 -lunls10 -lsnls10 -lnls10
-lcore10 -lnls10   `cat /oracle/CATY12/home/products/10203/lib/sysliblist` -R
/opt/SUNWcluster/lib/sparcv9:/oracle/CATY12/home/products/10203/lib:/opt/ORCLclu
ster/lib/  -Y
P,:/opt/SUNWcluster/lib/sparcv9:/opt/ORCLcluster/lib/:/usr/ccs/lib/sparcv9:/usr/
lib/sparcv9 -Qy -lc -laio -lposix4 -lkstat -lm
/oracle/CATY12/home/products/10203/lib/prod/lib/v9/crtn.o

cp $ORACLE_HOME/rdbms/lib/bbed $ORACLE_HOME/bin

bbed
Password:  <blockedit>     ( bbed 的默认密码都为：blockedit)

BBED: Release 2.0.0.0.0 – Limited Production on Wed Sep 16 23:14:39 2009

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

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

BBED> help all
SET DBA [ dba | file#, block# ]
SET FILENAME ‘filename’
SET FILE file#
SET BLOCK [+/-]block#
SET OFFSET [ [+/-]byte offset | symbol | *symbol ]
SET BLOCKSIZE bytes
SET LIST[FILE] ‘filename’
SET WIDTH character_count
SET COUNT bytes_to_display
SET IBASE [ HEX | OCT | DEC ]
SET OBASE [ HEX | OCT | DEC ]
SET MODE  [ BROWSE | EDIT ]
SET SPOOL [ Y | N ]
SHOW [ | ALL ]
INFO
MAP[/v] [ DBA | FILENAME | FILE | BLOCK ]
DUMP[/v] [ DBA | FILENAME | FILE | BLOCK | OFFSET | COUNT ]
PRINT[/x|d|u|o|c] [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]
EXAMINE[/Nuf] [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]
:
N – a number which specifies a repeat count.
u – a letter which specifies a unit size:
  b – b1, ub1 (byte)
  h – b2, ub2 (half-word)
  w – b4, ub4(word)
  r – Oracle table/index row
f – a letter which specifies a display format:
  x – hexadecimal
  d – decimal
  u – unsigned decimal
  o – octal
  c – character (native)
  n – Oracle number
  t – Oracle date
  i – Oracle rowid
FIND[/x|d|u|o|c] numeric/character string [ TOP | CURR ]
COPY [ DBA | FILE | FILENAME | BLOCK ] TO [ DBA | FILE | FILENAME | BLOCK ]
MODIFY[/x|d|u|o|c] numeric/character string
      [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]
ASSIGN[/x|d|u|o] =
: [ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]
: [ value | ]
SUM [ DBA | FILE | FILENAME | BLOCK ] [ APPLY ]
PUSH [ DBA | FILE | FILENAME | BLOCK | OFFSET ]
POP [ALL]
REVERT [ DBA | FILE | FILENAME | BLOCK ]
UNDO
HELP [ | ALL ]
VERIFY [ DBA | FILE | FILENAME | BLOCK ]
CORRUPT [ DBA | FILE | FILENAME | BLOCK ]

BBED>

 

 

 

SQL>  select file# || ' '|| name||' '||bytes from v$datafile;

FILE#||''||NAME||''||BYTES
--------------------------------------------------------------------------------
1 /u01/oracle/oradata/ora10g/system01.dbf 503316480
2 /u01/oracle/oradata/ora10g/undotbs1.dbf 104857600
3 /u01/oracle/oradata/ora10g/sysaux01.dbf 272629760
4 /u01/oracle/oradata/ora10g/users01.dbf 876871680
7 /u01/oracle/oradata/ora10g/test01.dbf 10485760

 

 

 

 [oracle@dba ~]$ vi filelist.txt

1 /u01/oracle/oradata/ora10g/system01.dbf 503316480
2 /u01/oracle/oradata/ora10g/undotbs1.dbf 104857600
3 /u01/oracle/oradata/ora10g/sysaux01.dbf 272629760
4 /u01/oracle/oradata/ora10g/users01.dbf 876871680
7 /u01/oracle/oradata/ora10g/test01.dbf 10485760

[oracle@localhost ~]$ vi bbed.par
blocksize=8192
listfile=/home/oracle/filelist.txt
mode=edit

 

[oracle@dba ~]$ bbed parfile=bbed.par
Password:

BBED: Release 2.0.0.0.0 - Limited Production on Tue Aug 28 17:06:06 2012

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

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

BBED>

 

BBED> show
 FILE#           1
 BLOCK#          1
 OFFSET          0
 DBA             0x00400001 (4194305 1,1)
 FILENAME        /u01/oracle/oradata/ora10g/system01.dbf
 BIFILE          bifile.bbd
 LISTFILE        /home/oracle/filelist.txt
 BLOCKSIZE       8192
 MODE            Edit
 EDIT            Unrecoverable
 IBASE           Dec
 OBASE           Dec
 WIDTH           80
 COUNT           512
 LOGFILE         log.bbd
 SPOOL           No

 

SQL> conn scott/tiger
SQL> drop table t1 purge;
SQL> create table t1 as select * From emp;

Table created.

SQL> select file_id,block_id,bytes from dba_extents where owner='SCOTT' and segment_name='T1';

   FILE_ID   BLOCK_ID    BYTES
---------- ---------- ----------
  4    65    65536

bbed 下查看数据库的信息

BBED> info all
 File#  Name                                                        Size(blks)
 -----  ----                                                        ----------
     1  /u01/oracle/oradata/ora10g/system01.dbf                          61440
     2  /u01/oracle/oradata/ora10g/undotbs1.dbf                          12800
     3  /u01/oracle/oradata/ora10g/sysaux01.dbf                          33280
     4  /u01/oracle/oradata/ora10g/users01.dbf                          107040
     7  /u01/oracle/oradata/ora10g/test01.dbf                             1280

 

 

BBED> set  file 4 block 65
 FILE#           4
 BLOCK#          65

BBED> d
 File: /u01/oracle/oradata/ora10g/users01.dbf (4)
 Block: 65               Offsets:    0 to  511           Dba:0x01000041
------------------------------------------------------------------------
 20a20000 41000001 860b6f00 00000204 665c0000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 04000000 ffffffff 04000000 03000000 08000000
 01000100 00000000 00000000 00000000 00000000 04000000 00000000 00000000
 00000000 00000000 00000000 00000000 42000001 00000000 00000000 04000000
 08000000 45000001 00000000 00000000 00000000 04000000 00000000 01000000
 31cb0000 00000000 00000000 41000001 08000000 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 00000000 11110000 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

 <32 bytes per line>

 

 

BBED> m /x 7ccc
 File: /u01/oracle/oradata/ora10g/users01.dbf (4)
 Block: 65               Offsets:    0 to  511           Dba:0x01000041
------------------------------------------------------------------------
 7ccc0000 41000001 860b6f00 00000204 665c0000 00000000 00000000 00000000
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 00000000 00000000 00000000 04000000 ffffffff 04000000 03000000 08000000
 01000100 00000000 00000000 00000000 00000000 04000000 00000000 00000000
 00000000 00000000 00000000 00000000 42000001 00000000 00000000 04000000
 08000000 45000001 00000000 00000000 00000000 04000000 00000000 01000000
 31cb0000 00000000 00000000 41000001 08000000 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 00000000 11110000 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

 <32 bytes per line>

 

BBED> sum apply
Check value for File 4, Block 65:
current = 0x323a, required = 0x323a