ITPub博客

首页 > 数据库 > Oracle > Oracel bbed安装和配置

Oracel bbed安装和配置

Oracle 作者:wzhalal 时间:2015-11-13 15:57:37 0 删除 编辑
编译和配置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

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

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


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

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

  22. FILE_ID||''||FILE_NAME||''||BYTES
  23. --------------------------------------------------------------------------------
  24. 4 /u01/oracle/oradata/yws/users01.dbf 5242880
  25. 3 /u01/oracle/oradata/yws/sysaux01.dbf 262144000
  26. 2 /u01/oracle/oradata/yws/undotbs01.dbf 534773760
  27. 1 /u01/oracle/oradata/yws/system01.dbf 534773760
  28. 5 /u01/oracle/oradata/yws/example01.dbf 104857600


使用bbed

点击(此处)折叠或打开

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

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

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

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

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

  23. BBED> info --成功安装
  24.  File# Name Size(blks)
  25.  ----- ---- ----------
  26.      1 /u01/oracle/oradata/yws/system01.dbf 65280
  27.      2 /u01/oracle/oradata/yws/undotbs01.dbf 65280
  28.      3 /u01/oracle/oradata/yws/sysaux01.dbf 32000
  29.      4 /u01/oracle/oradata/yws/users01.dbf 640
  30.      5 /u01/oracle/oradata/yws/example01.dbf 12800

  31. BBED> exit

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

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

注册时间:2013-06-06

  • 博文量
    60
  • 访问量
    249721