Shulou(Shulou.com)06/01 Report--

1. Bbed installation:

1. To install BBED under ORACLE 11G, you need to copy three packages sbbdpt.o and ssbbded.o from ORACLE 10G.

And move the two files to the $ORACLE_HOME/rdbms/lib/ directory and bbedus.msb to the $ORACLE_HOME/mesg/ directory

[oracle] $pwd

/ u01/app/oracle/product/11.2.0/db_1/rdbms/lib

Node1- > ll bbedus.msb

-rw-r--r--. 1 oracle oinstall 8704 Mar 5 17:39 bbedus.msb

Node1- > ll sbbdpt.o

-rw-r--r--. 1 oracle oinstall 1863 Mar 5 17:39 sbbdpt.o

Node1- > ll ssbbded.o

-rw-r--r--. 1 oracle oinstall 1191 Mar 5 17:39 ssbbded.o

2. Compilation

[oracle] $make-f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed

Linking BBED utility (bbed)

3. The successful login of installation is as follows:

[oracle] $bbed

Password: the default password is: blockedit

BBED >

4. Configure bbed

BBED > set file 1 block 1

BBED-00312: no LISTFILE specified > reason is not configured

-- write the sql query results to the bbedfile.txt file, and configure the par.bbd of bbed

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

[oracle@12c01 bbed] $cat bbedfile.txt

1 / home/oracle/app/oracle/oradata/andycdb/system01.dbf 859832320

3 / home/oracle/app/oracle/oradata/andycdb/sysaux01.dbf 576716800

4 / home/oracle/app/oracle/oradata/andycdb/undotbs01.dbf 62914560

5 / home/oracle/app/oracle/oradata/andycdb/pdbseed/system01.dbf 262144000

6 / home/oracle/app/oracle/oradata/andycdb/pdbseed/sysaux01.dbf 367001600

7 / home/oracle/app/oracle/oradata/andycdb/users01.dbf 5242880

8 / home/oracle/app/oracle/oradata/andycdb/pdbseed/undotbs01.dbf 104857600

9 / home/oracle/app/oracle/oradata/andycdb/pdb01/system01.dbf 272629760

10 / home/oracle/app/oracle/oradata/andycdb/pdb01/sysaux01.dbf 398458880

11 / home/oracle/app/oracle/oradata/andycdb/pdb01/undotbs01.dbf 104857600

12 / home/oracle/app/oracle/oradata/andycdb/pdb01/users01.dbf 17039360

13 / home/oracle/app/oracle/oradata/andycdb/pdb01/clone01.dbf 1048576

26 / home/oracle/app/oracle/oradata/andycdb/cdb_users01.dbf 5242880

27 / home/oracle/app/oracle/oradata/andycdb/pdb01/pdb01_users01.dbf 5242880

28 / home/oracle/app/oracle/oradata/andycdb/undotbs02 5242880

29 / home/oracle/app/oracle/oradata/andycdb/pdb01/undotbs02 5242880

30 / home/oracle/app/oracle/oradata/andycdb/pdb01/undotbs03 5242880

[oracle bbed] $cat par.bbd

Blocksize=8192

Listfile=bbedfile.txt

Mode=edit

5. Official landing and use

[oracle bbed] $bbed parfile=par.bbd

BBED > info

File# Name Size (blks)

-

1 / home/oracle/app/oracle/oradata/andycdb/system01.dbf 104960

3 / home/oracle/app/oracle/oradata/andycdb/sysaux01.dbf 70400

. Omit

BBED > set file 31 block 1

FILE# 31

BLOCK# 1 > success

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.