I. CentOS on-Build installation Bbed tool
[Email protected] ~]$ CD $ORACLE _home/rdbms/Lib[[email protected]~]$ make-f ins_rdbms.mk $ORACLE _home/rdbms/lib/bbed can also generate bbed to $oracle_home with the following command/bin directory [[email protected]~]$ make-f ins_rdbms.mk bbed= $ORACLE _home/bin/bbed $ORACLE _home/bin/bbed In addition, the Bbed library file is not provided by default in 11g, but we can copy the 10g related library files to 11g corresponding paths and then compile the bbed execution files, which need to be copied including the following library files: Copy oracle 10g file copy $ORA 10g_ HOME/RDBMS/LIB/SSBBDED.O to $ORA 11g_home/rdbms/libcopy $ORA 10g_home/RDBMS/LIB/SBBDPT.O to $ORA 11g_home/rdbms/libcopy $ORA 10g_home/RDBMS/MESG/BBEDUS.MSB to $ORA 11g_home/rdbms/mesgcopy $ORA 10g_home/rdbms/mesg/bbedus.msg to $ORA 11g_home/rdbms/mesgcopy $ORA 10g_home/RDBMS/MESG/BBEDAR.MSB to $ORA 11g_home/rdbms/MESG compiling make-F $ORA 11g_home/rdbms/lib/ins_rdbms.mkbbed= $ORACLE _home/bin/bbed $ORACLE _home/bin/bbed
Two. Using bbed
In general, you need to create two parameter files before using bbed filelist.txt and Bbed.par
2.1. Create a parameter file filelist.txt
--get datafile Info: File Number file name file size sql> Select File#| | ' ' | | name| | ' ' | | bytes from V$datafile; file#| | ' | | name| | ' | | BYTES--------------------------------------------------------------------------------1/u01/app/oracle/oradata/ ORCL/DATAFILE/O1_MF_SYSTEM_BC7LD3SF_.DBF 5033164802/u01/app/oracle/oradata/orcl/datafile/o1_mf_undotbs1_ BC7LDQL4_.DBF 3303014403/u01/app/oracle/oradata/orcl/datafile/o1_mf_sysaux_bc7lf4bd_.dbf 2516582404/u01/app/ ORACLE/ORADATA/ORCL/DATAFILE/O1_MF_USERS_BC7LFLNO_.DBF 5242880sql>-- The datafile information from the above query is saved to the file filelist.txt, the file directory can be specified by itself [[email protected] bbed]$ vi/u01/app/oracle/bbed/ Filelist.txt 1/u01/app/oracle/oradata/orcl/datafile/o1_mf_system_bc7ld3sf_.dbf 5033164802/u01/app/oracle/oradata /ORCL/DATAFILE/O1_MF_UNDOTBS1_BC7LDQL4_.DBF 3303014403/u01/app/oracle/oradata/orcl/datafile/o1_mf_sysaux_ BC7LF4BD_.DBF 2516582404/u01/app/oracle/oradata/orcl/datafile/o1_mf_users_bc7lflno_.dbf 5242880[[email Protected] bbed]$
2.2. Create a parameter file Bbed.par
--The directory of the file is best with [[email protected] bbed]$ vi/u01/app/oracle/bbed/bbed.parblocksize=8192listfile=/u01/app/oracle/bbed/ Filelist.txtmode=edit
2.3. Connect bbed using parameter file
[[email protected] bbed]$ bbed Parfile=/u01/app/oracle/bbed/bbed.parpassword: ---default password is blockeditbbed:release 2.0.0.0.0-limited Production on Mon Jan 09:49:46 2015Copyright (c) 1982, 2005, Oracle. All Rights reserved.*************!!! For Oracle Internal with only!!! Bbed>
--The following article describes the common commands of bbed
Oracle bbed Instructions for use 1