Wir hatten es mal mit korrupten Blöcken zu tun. Diese kann man so finden: — Welche Art von Corruption: col CORRUPTION_CHANGE# format 999999999999 select CORRUPTION_TYPE , min(CORRUPTION_CHANGE#) CORRUPTION_CHANGE# , count(*) Anz from V$DATABASE_BLOCK_CORRUPTION group by CORRUPTION_TYPE order by 1 ; CORRUPTIO CORRUPTION_CHANGE# ANZ ——— —————— ———- NOLOGGING 31880926200 1632 — […]
Monat: April 2014
Alert-File über External Table auswerten
Mapping the Oracle alert log is easy and once defined, all you have to do is query it with standard SQL syntax: create directory BDUMP as ‚/software/oracle/oracleBase/diag/rdbms/alkisrep/alkisrep/trace‘; create table alert_log ( msg varchar2(80) ) organization external ( type oracle_loader default directory BDUMP access parameters ( records delimited by newline […]