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/o