------------------------------------------------------------------------
?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> /
TABLE_NAME ? ? ? ? ?