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
Sun May 05 23:48:09 2013 Hex dump of (file 7, block 333813) in trace file c:\oracle\admin\binch00\udump\binch00_ora_2188.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_05\O1_MF_NNNDF_TAG20130505T234510_8RDRM75N_.BKP Sun May 05 23:49:52 2013
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>
SQL> SELECT distinct d.SEGMENT_TYPE||':'||d.OWNER||'.'||d.SEGMENT_NAME 2 FROM DBA_EXTENTS d, v$database_block_corruption b 3 where b.file#=d.file_id and b.block# between d.block_id and d.block_id+d.bl ocks-1 4 / no rows selected SQL>
alter table supermag.smprices move;