oracle bbed安装(五)
are2: 0x0 spare3: 0x0
consistency value in tail: 0x7dc50601
check value in block header: 0x127f
computed block checksum: 0x138
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 1
Total Blocks Influx : 0
BBED> sum apply www.2cto.com
Check value for File 1, Block 378:
current = 0x1347, required = 0x1347
BBED> verify
DBVERIFY - Verification starting
FILE = /opt/app/oracle/oradata/wolf/system01.dbf
BLOCK = 378
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
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 104859216 bytes
Database Buffers 176160768 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> select * from bootstrap$ where rownum
2 <2;
LINE# OBJ#
---------- ----------
SQL_TEXT
--------------------------------------------------------------------------------
-1 -1
8.0.0.0.0
SQL>
www.2cto.com
实验二
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/opt/app/oracle/oradata/wolf/system01.dbf
/opt/app/oracle/oradata/wolf/undotbs01.dbf
/opt/app/oracle/oradata/wolf/sysaux01.dbf
/opt/app/oracle/oradata/wolf/users01.dbf
/opt/app/oracle/oradata/wolf/wolfblock01.dbf
SQL> select file#,name from v$datafile;
FILE#
----------
NAME
--------------------------------------------------------------------------------
1
/opt/app/oracle/oradata/wolf/system01.dbf
2
/opt/app/oracle/oradata/wolf/undotbs01.dbf
3
/opt/app/oracle/oradata/wolf/sysaux01.dbf
FILE#
----------
NAME
--------------------------------------------------------------------------------
4
/opt/app/oracle/oradata/wolf/users01.dbf
5
/opt/app/oracle/oradata/wolf/wolfblock01.dbf
SQL> drop table wolfblock;
Table dropped.
SQL> create table wolfblock(id number) tablespace wolfblock;
Table created.
SQL> insert into wolfblock values(1);
1 row created.
SQL> /
1 row created.
SQL> /
1 row created.
SQL> /
1 row created.
SQL> select * from wolfblock;
ID
----------
1
1
1
1
www.2cto.com
SQL> select rowid,dbms_rowid.rowid_relative_fno(rowid)
rel_fno,dbms_rowid.rowid_block_number(rowid) blockno from wolfblock;
ROWID REL_FNO BLOCKNO
------------------ ---------- ----------
AAAMj+AAFAAAAAXAAA 5 23
AAAMj+AAFAAAAAXAAB 5 23
AAAMj+AAFAAAAAXAAC 5 23
AAAMj+AAFAAAAAXAAD 5 23
SQL> alter system dump datafile 5 block 23;
System altered.
dump 和 bbed
后面的结果研究中