Oracel bbed安裝和配置

yewushang發表於2014-02-09
編譯和配置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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29477587/viewspace-1078554/，如需轉載，請註明出處，否則將追究法律責任。

相關文章