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]
>
>
>
--
Cheers,
^_^ Andes ^_^
[Non-text portions of this message have been removed]
