全部博文（101）
分类： Oracle
2013-01-15 09:25:47
>conn / as sysdba
Connected.
SYS>create table siyang(job varchar2(100));
Table created.
SYS>insert into siyang values('SIYANG is DBA!');
1 row created.
SYS>commit;
Commit complete.
SYS>insert into siyang values('SIYANG like Oracle!');
1 row created.
SYS>commit;
Commit complete.
SYS> select
2 rowid,
3 dbms_rowid.rowid_relative_fno(rowid) rel_fno,
4 dbms_rowid.rowid_block_number(rowid) blockno,
5 dbms_rowid.rowid_row_number(rowid) rowno
6 from siyang;
ROWID REL_FNO BLOCKNO ROWNO
------------------ ---------- ---------- ----------
AAAPiCAABAAAQWiAAA 1 66978 0
AAAPiCAABAAAQWiAAB 1 66978 1
SYS>select * from siyang;
JOB
----------------------------------------------------------------------------------------------------
SIYANG is DBA!
SIYANG like Oracle!
[oracle@CENTERDB lib]$ export ORACLE_SID=centerdb
[oracle@CENTERDB lib]$ bbed listfile=listfile.txt blocksize=8192
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Mon Jan 14 14:21:43 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> set file 1
FILE# 1
BBED> set block 66978
BLOCK# 66978
BBED> set offset 0
OFFSET 0
BBED> find /c SIYANG top
File: /oracle1/u01/app/oracle/oradata/centerdb/system01.dbf (1)
Block: 66978 Offsets: 8174 to 8191 Dba:0x004105a2
------------------------------------------------------------------------
53495941 4e472069 73204442 41210406 b9cd
<32 bytes per line>
BBED> d /v dba 1,66978 offset 8174 count 128
File: /oracle1/u01/app/oracle/oradata/centerdb/system01.dbf (1)
Block: 66978 Offsets: 8174 to 8191 Dba:0x004105a2
-------------------------------------------------------
53495941 4e472069 73204442 41210406 l SIYANG is DBA!..
b9cd l ..
<16 bytes per line>
BBED> f
BBED-00212: search string not found
BBED> f
BBED-00212: search string not found
BBED> find /c SIYANG top
File: /oracle1/u01/app/oracle/oradata/centerdb/system01.dbf (1)
Block: 66978 Offsets: 8174 to 8191 Dba:0x004105a2
------------------------------------------------------------------------
53495941 4e472069 73204442 41210406 b9cd
<32 bytes per line>
BBED> d /v dba 1,66978 offset 8174 count 128
File: /oracle1/u01/app/oracle/oradata/centerdb/system01.dbf (1)
Block: 66978 Offsets: 8174 to 8191 Dba:0x004105a2
-------------------------------------------------------
53495941 4e472069 73204442 41210106 l SIYANG is DBA!..
cacd l ..
<16 bytes per line>
BBED> modify /c sy dba 1,66978 offset 8174
BBED-00215: editing not allowed in BROWSE mode
BBED> set mode edit
MODE Edit
BBED> modify /c sy dba 1,66978 offset 8174
File: /oracle1/u01/app/oracle/oradata/centerdb/system01.dbf (1)
Block: 66978 Offsets: 8174 to 8191 Dba:0x004105a2
------------------------------------------------------------------------
73795941 4e472069 73204442 41210106 cacd
<32 bytes per line>
BBED> sum dba 1,66978
Check value for File 1, Block 66978:
current = 0x370b, required = 0x072b
BBED> sum dba 1,166978 apply
BBED-00309: out of range block number (166978)
BBED> sum dba 1,66978 apply
Check value for File 1, Block 66978:
current = 0x072b, required = 0x072b
BBED> verfy dba 1,66978
BBED-00200: invalid keyword (verfy)
BBED> verify dba 1,66978
DBVERIFY - Verification starting
FILE = /oracle1/u01/app/oracle/oradata/centerdb/system01.dbf
BLOCK = 66978
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
SYS>startup force
ORACLE instance started.
Total System Global Area 2097152000 bytes
Fixed Size 2085224 bytes
Variable Size 335548056 bytes
Database Buffers 1744830464 bytes
Redo Buffers 14688256 bytes
Database mounted.
Database opened.
SYS>select * from siyang;
JOB
----------------------------------------------------------------------------------------------------
syYANG is DBA!
SIYANG like Oracle!
