Pular para o conteúdo

Fóruns Banco de dados Oracle Coleta de Estatisticas Gerando erro ORA-03113 Coleta de Estatisticas Gerando erro ORA-03113

#94761
armandoveloso
Participante

    Passei o DBV, por enquanto, apenas no datafile que ta a tabela com bloco ruim, tem mais datafiles na TS, mas ainda nao passei…
    Outra coisa, rodei o DBV com a TS online.

    Resultado:

    DBVERIFY – Verification starting : FILE = M:xxyyyyDatafile02.DBF
    Block Checking: DBA = 29378501, Block Type = KTB-managed data block
    data header at 0x10a827c
    [b]kdbchk: the amount of space used is not equal to block size
    used=7378 fsc=0 avsp=1177 dtl=8064[/b]
    Page 18373 failed with check code 6110
    ……….

    DBVERIFY – Verification complete

    Total Pages Examined : 384000
    Total Pages Processed (Data) : 237784
    Total Pages Failing (Data) : 1
    Total Pages Processed (Index): 143372
    Total Pages Failing (Index): 0
    Total Pages Processed (Other): 1804
    Total Pages Processed (Seg) : 0
    Total Pages Failing (Seg) : 0
    Total Pages Empty : 1040
    Total Pages Marked Corrupt : 0
    Total Pages Influx : 0
    Highest block SCN : 2089558116 (0.2089558116)