Восстановление битого блока в Oracle : Oracle

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     9624
Next log sequence to archive   9626
Current log sequence           9626

Wed May 22 11:05:47 2013
Hex dump of (file 7, block 333813) in trace file c:\oracle\admin\binch00\udump\binch00_ora_5804.trc
Corrupt block relative dba: 0x01c517f5 (file 7, block 333813)
Fractured block found during backing up datafile
Data in bad block:
 type: 0 format: 2 rdba: 0x01c517f5
 last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0x00000000
 check value in block header: 0xb130
 computed block checksum: 0x1
Reread of blocknum=333813, file=E:\ORACLE\ORADATA\BINCH00\USERS03.DBF. found same corrupt data
Reread of blocknum=333813, file=E:\ORACLE\ORADATA\BINCH00\USERS03.DBF. found same corrupt data
Reread of blocknum=333813, file=E:\ORACLE\ORADATA\BINCH00\USERS03.DBF. found same corrupt data
Reread of blocknum=333813, file=E:\ORACLE\ORADATA\BINCH00\USERS03.DBF. found same corrupt data
Reread of blocknum=333813, file=E:\ORACLE\ORADATA\BINCH00\USERS03.DBF. found same corrupt data
Deleted Oracle managed file G:\ORACLE\RMAN\BINCH00\BACKUPSET\2013_05_22\O1_MF_NNNDF_TAG20130522T105940_8SR63Y3P_.BKP

SQL> SELECT owner, segment_name, segment_type
  2  FROM dba_extents
  3  WHERE file_id = 7
  4  AND 333813 BETWEEN block_id AND block_id + blocks - 1;

OWNER
------------------------------
SEGMENT_NAME
---------------------------------------------------------------------------
SEGMENT_TYPE
------------------
SUPERMAG
SMPRICES
TABLE


SQL>

alter table supermag.smprices move;