Dear gurus,
mohon pencerahannya, di alert log database saya muncul error :
Corrupt block relative dba: 0x00c10f3d (file 3, block 69437)
Fractured block found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x00c10f3d
last change scn: 0x0000.04defeb0 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xf9ea0601
check value in block header: 0xb2ad
computed block checksum: 0x655
Reread of rdba: 0x00c10f3d (file 3, block 69437) found same corrupted data
Tue Apr 28 13:45:47 2009
Corrupt Block Found
TSN = 2, TSNAME = SYSAUX
RFN = 3, BLK = 69437, RDBA = 12652349
OBJN = 49871, OBJD = 49871, OBJECT = MGMT_METRICS_RAW_PK, SUBOBJECT
=
SEGMENT OWNER = SYSMAN, SEGMENT TYPE = Index Segment
saya coba rebuild, tapi ternyata object ini adalah IOT objek,
SQL> ALTER INDEX MGMT_METRICS_RAW_PK REBUILD;
ALTER INDEX MGMT_METRICS_RAW_PK REBUILD
*
ERROR at line 1:
ORA-28650: Primary index on an IOT cannot be rebuilt
so bagaimana cara saya untuk mengatasi corrupted block / index ini ? apakah
dengan re-create IOT ini ? bila memang iya, bagaimana cara nya ?
Many Thanks,
Andes
[Non-text portions of this message have been removed]
