Oracel bbed安装和配置

  • yewushang

    2014-02-09 20:42:00
  • Oracle
  • 原创
编译和配置BBED

点击(此处)折叠或打开

  1. SQL> select * from v$version;


    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
    PL/SQL Release 10.2.0.5.0 - Production
    CORE    10.2.0.5.0      Production
    TNS for Linux: Version 10.2.0.5.0 - Production
    NLSRTL Version 10.2.0.5.0 - Production
  2. [root@yws ~]# su - oracle
  3. [oracle@yws ~]$ cd $ORACLE_HOME/rdbms/lib
  4. [oracle@yws lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed --编译 bbed tool
  5. Linking BBED utility (bbed)
  6. rm -f /u01/oracle/product/10.2.0/rdbms/lib/bbed
  7. gcc -o /u01/oracle/product/10.2.0/rdbms/lib/bbed -L/u01/oracle/product/10.2.0/rdbms/lib/ -L/u01/oracle/product/10.2.0/lib/ -L/u01/oracle/product/10.2.0/lib/stubs/ -L/usr/lib -lirc /u01/oracle/product/10.2.0/lib/s0main.o /u01/oracle/product/10.2.0/rdbms/lib/ssbbded.o /u01/oracle/product/10.2.0/rdbms/lib/sbbdpt.o `cat /u01/oracle/product/10.2.0/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 /u01/oracle/product/10.2.0/rdbms/lib/defopt.o -ldbtools10 -lclntsh `cat /u01/oracle/product/10.2.0/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/oracle/product/10.2.0/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 /u01/oracle/product/10.2.0/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/oracle/product/10.2.0/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 /u01/oracle/product/10.2.0/lib/sysliblist` -Wl,-rpath,/u01/oracle/product/10.2.0/lib -lm `cat /u01/oracle/product/10.2.0/lib/sysliblist` -ldl -lm -L/u01/oracle/product/10.2.0/lib
  8. [oracle@yws lib]$ ln -s $ORACLE_HOME/rdbms/lib/bbed $ORACLE_HOME/bin/bbed --创建软连接
  9. [oracle@yws lib]$ vi /home/oracle/bbed.par --编译bbed配置文件
  10. [oracle@yws lib]$ cat /home/oracle/bbed.par
  11. blocksize=8192 --标准块大小
  12. listfile=/home/oracle/filelist.txt --文件列表
  13. logfile=log.bbed --log
  14. [oracle@yws lib]$ sqlplus / as sysdba

  16. SQL*Plus: Release 10.2.0.5.0 - Production on Fri Dec 20 18:55:35 2013

  18. Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


  21. Connected to:
  22. Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
  23. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  25. SQL> spool /home/oracle/filelist.txt --创建filelist
  26. SQL> select file_id||' '||file_name||' '||bytes from dba_data_files; --filelist格式

  28. FILE_ID||''||FILE_NAME||''||BYTES
  29. --------------------------------------------------------------------------------
  30. 4 /u01/oracle/oradata/yws/users01.dbf 5242880
  31. 3 /u01/oracle/oradata/yws/sysaux01.dbf 262144000
  32. 2 /u01/oracle/oradata/yws/undotbs01.dbf 534773760
  33. 1 /u01/oracle/oradata/yws/system01.dbf 534773760
  34. 5 /u01/oracle/oradata/yws/example01.dbf 104857600


使用bbed

点击(此处)折叠或打开

  1. [oracle@yws ~]$ bbed parfile=bbed.par --启动
  2. Password: --password：blockedit

  4. BBED: Release 2.0.0.0.0 - Limited Production on Fri Dec 20 18:57:38 2013

  6. Copyright (c) 1982, 2007, Oracle. All rights reserved.

  8. ************* !!! For Oracle Internal Use only !!! ***************

  10. BBED> show all
  11.         FILE# 1
  12.         BLOCK# 1
  13.         OFFSET 0
  14.         DBA 0x00400001 (4194305 1,1)
  15.         FILENAME /u01/oracle/oradata/yws/system01.dbf
  16.         BIFILE bifile.bbd
  17.         LISTFILE /home/oracle/filelist.txt
  18.         BLOCKSIZE 8192
  19.         MODE Browse
  20.         EDIT Unrecoverable
  21.         IBASE Dec
  22.         OBASE Dec
  23.         WIDTH 80
  24.         COUNT 512
  25.         LOGFILE log.bbed
  26.         SPOOL No

  28. BBED> info --成功安装
  29.  File# Name Size(blks)
  30.  ----- ---- ----------
  31.      1 /u01/oracle/oradata/yws/system01.dbf 65280
  32.      2 /u01/oracle/oradata/yws/undotbs01.dbf 65280
  33.      3 /u01/oracle/oradata/yws/sysaux01.dbf 32000
  34.      4 /u01/oracle/oradata/yws/users01.dbf 640
  35.      5 /u01/oracle/oradata/yws/example01.dbf 12800

  37. BBED> exit

请使用浏览器的分享功能分享到微信等