建议不要直接用原来归档，最好能拷贝一份归档来抽取数据
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.