------------------------------------------------------------------------

?ce000000 00000000 00000000 00000000 00000000 00000000 00000000 0000?

?<32 bytes per line>

BBED> dump /v dba 1,1 offset 492 count 30

?File: /u01/app/oracle/oradata/satdb/system01.dbf (1)

?Block: 1 ? ? ? Offsets: ?492 to ?521 ?Dba:0x00400001

-------------------------------------------------------

?23122a35 01000000 01000000 02000000 l #.*5............

?10000000 02000000 00000000 0000 ? ? l ..............

?<16 bytes per line>

BBED> dump /v dba 5,1 offset 492 count 30

?File: /u01/app/oracle/oradata/satdb/data01.dbf (5)

?Block: 1 ? ? ? Offsets: ?492 to ?521 ?Dba:0x01400001

-------------------------------------------------------

?d70f2a35 01000000 01000000 2b020000 l ..*5........+...

?100085a6 02000000 00000000 0000 ? ? l ..............

?<16 bytes per line>

BBED> modify /x 2312

?File: /u01/app/oracle/oradata/satdb/data01.dbf (5)

?Block: 1 ? ? ? ? ? ? ? ?Offsets: ?492 to ?521 ? ? ? ? ? Dba:0x01400001

------------------------------------------------------------------------

?23122a35 01000000 01000000 2b020000 100085a6 02000000 00000000 0000?

?<32 bytes per line>

BBED> dump /v dba 1,1 offset 484 count 30

?File: /u01/app/oracle/oradata/satdb/system01.dbf (1)

?Block: 1 ? ? ? Offsets: ?484 to ?513 ?Dba:0x00400001

-------------------------------------------------------

?9a5b1300 00000000 23122a35 01000000 l .[......#.*5....

?01000000 02000000 10000000 0200 ? ? l ..............

?<16 bytes per line>

BBED> dump /v dba 5,1 offset 484 count 30

?File: /u01/app/oracle/oradata/satdb/data01.dbf (5)

?Block: 1 ? ? ? Offsets: ?484 to ?513 ?Dba:0x01400001

-------------------------------------------------------

?975b1300 00000000 23122a35 01000000 l .[......#.*5....

?01000000 2b020000 100085a6 0200 ? ? l ....+.........

?<16 bytes per line>

BBED> modify /x 9a5b

?File: /u01/app/oracle/oradata/satdb/data01.dbf (5)

?Block: 1 ? ? ? ? ? ? ? ?Offsets: ?484 to ?513 ? ? ? ? ? Dba:0x01400001

------------------------------------------------------------------------

?9a5b1300 00000000 23122a35 01000000 01000000 2b020000 100085a6 0200?

?<32 bytes per line>

BBED> dump /v dba 1,1 offset 488 count 30

?File: /u01/app/oracle/oradata/satdb/system01.dbf (1)

?Block: 1 ? ? ? Offsets: ?488 to ?517 ?Dba:0x00400001

-------------------------------------------------------

?00000000 23122a35 01000000 01000000 l ....#.*5........

?02000000 10000000 02000000 0000 ? ? l ..............

?<16 bytes per line>

BBED> dump /v dba 5,1 offset 488 count 30

?File: /u01/app/oracle/oradata/satdb/data01.dbf (5)

?Block: 1 ? ? ? Offsets: ?488 to ?517 ?Dba:0x01400001

-------------------------------------------------------

?00000000 23122a35 01000000 01000000 l ....#.*5........

?2b020000 100085a6 02000000 0000 ? ? l +.............

?<16 bytes per line>

BBED> sum apply

Check value for File 5, Block 1:

current = 0xf246, required = 0xf246

BBED> exit

SQL> alter database datafile 5 online;

alter database datafile 5 online

*

ERROR at line 1:

ORA-01113: file 5 needs media recovery

ORA-01110: data file 5: '/u01/app/oracle/oradata/satdb/data01.dbf'

SQL> recover datafile 5;

Media recovery complete.

SQL> ?alter database datafile 5 online;

Database altered.

5、检查数据及状态

SQL> select file#,status from v$datafile;

? ? ?FILE# STATUS

---------- --------------

? ? ? ? ?1 SYSTEM

? ? ? ? ?2 ONLINE

? ? ? ? ?3 ONLINE

? ? ? ? ?4 ONLINE

? ? ? ? ?5 ONLINE

? ? ? ? ?6 ONLINE

6 rows selected.

SQL> conn lineqi/lineqi

Connected.

SQL> select table_name,tablespace_name from user_tables;

SQL> col tablespace_name for 50

SQL> set linesize 400?

SQL> /