LOGMINER工具分析報錯誤解決方法 ORA-00333

建議不要直接用原來歸檔，最好能複製一份歸檔來抽取資料
SQL> create table archive10 as select sql_redo,TIMESTAMP,COMMIT_TIMESTAMP from v$logmnr_contents;
create table archive10 as select sql_redo,TIMESTAMP,COMMIT_TIMESTAMP from v$logmnr_contents
                                                                          *
ERROR at line 1:
ORA-00333: redo log read error block 65538 count 8192

LOGMINER: Begin mining logfile for session -2147482879 thread 2 sequence 1290, /home/oracle/2_1290_845139535.arc
LOGMINER: End   mining logfile for session -2147482879 thread 2 sequence 1290, /home/oracle/2_1290_845139535.arc
LOGMINER: Begin mining logfile for session -2147482879 thread 2 sequence 1291, /home/oracle/2_1291_845139535.arc
Errors in file /app/oracle/diag/rdbms/crds3db/crds3db1/trace/crds3db1_ora_26410.trc:
ORA-00333: redo log read error block 47106 count 2048
ORA-00334: archived log: '/home/oracle/2_1291_845139535.arc'
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 47106
Additional information: 2048
Additional information: 47552
Errors in file /app/oracle/diag/rdbms/crds3db/crds3db1/trace/crds3db1_ora_26410.trc:
ORA-00333: redo log read error block 40962 count 8192
ORA-00334: archived log: '/home/oracle/2_1291_845139535.arc'這個發現這個歸檔損壞了，重新複製一個新的歸檔
ORA-27069: attempt to do I/O beyond the range of the file
上面
insert into archive10 select sql_redo,TIMESTAMP,COMMIT_TIMESTAMP from v$logmnr_contents;
insert into archive10 select sql_redo,TIMESTAMP,COMMIT_TIMESTAMP from v$logmnr_contents
            *
ERROR at line 1:
ORA-00913: too many values

SQL> insert into archive10 select sql_redo,TIMESTAMP  from v$logmnr_contents;
insert into archive10 select sql_redo,TIMESTAMP  from v$logmnr_contents
                             *
ERROR at line 1:
ORA-12899: value too large for column "SYS"."ARCHIVE10"."SQL_REDO" (actual:
2155, maximum: 2000)

SQL> dro table archive10;
SP2-0734: unknown command beginning "dro table ..." - rest of line ignored.
SQL> drop table archive10;

Table dropped.
嘗試手動建立表然後在插入問題還是一樣

SQL> create table archive10 (sql_redo long,TIMESTAMP date);

Table created.

SQL> insert into archive10 select sql_redo,TIMESTAMP  from v$logmnr_contents;
insert into archive10 select sql_redo,TIMESTAMP  from v$logmnr_contents
            *
ERROR at line 1:
ORA-00333: redo log read error block 65538 count 8192

ORA-00334: archived log: '/home/oracle/2_1291_845139535.arc'這個發現這個歸檔損壞了，重新複製一個新的歸檔

SQL>  create table archive10 as select sql_redo,TIMESTAMP from  v$logmnr_contents;

Table created.