hm....bisa dicoba fix/skip corrupted block dulu dgn dbms_repair baru di reorg dgn move tadi...
-- best regards database specialist http://www.dbs247.com On Tue, Apr 28, 2009 at 3:25 PM, Andes Febrian <[email protected]> wrote: > Hi.. malah muncul error corrupted block, so untuk yg satu ini apa tidak > bisa > di rebuild ? tapi klo saya baca2 di inet, bila index nya yg corrupt, bisa > di > rebuild atau re-create, untuk masalah yg satu ini, apa yg harus di lakukan > bila rebuild dengan alter table ... move tidak bisa di lakukan ? > > SQL> conn sysman/oracle > Connected. > SQL> alter table MGMT_METRICS_RAW move; > alter table MGMT_METRICS_RAW move > * > ERROR at line 1: > ORA-01578: ORACLE data block corrupted (file # 3, block # 69437) > ORA-01110: data file 3: '/u02/oradata/ittdb/sysaux01.dbf' > > Many Thanks, > Andes > > On Tue, Apr 28, 2009 at 2:37 PM, Oracle Engineer <[email protected]> > wrote: > > > > > > > alter table .... move tablespace ....;atau > > alter table .... move; (pada tablespace yg sama) > > > > -- > > best regards > > database specialist > > http://www.dbs247.com > > > > > > On Tue, Apr 28, 2009 at 2:32 PM, Andes Febrian <[email protected] > <pejantan4u%40gmail.com>> > > wrote: > > > > > 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]
