LOGMINER工具分析报错误解决方法 ORA-00333

最新推荐文章于 2025-10-09 12:03:33 发布

转载最新推荐文章于 2025-10-09 12:03:33 发布 · 700 阅读

这篇博客介绍了在使用LOGMINER工具分析Oracle数据库时遇到ORA-00333错误的解决方案。作者建议不要直接使用原始归档，而是复制一份归档进行数据抽取。在尝试创建并插入数据到archive10表的过程中，遇到了多个错误，包括值过大、redo log读取错误等。通过手动创建表和调整数据类型，作者试图解决问题，但仍然遇到了redo log错误，提示归档可能已损坏，需要重新拷贝新的归档。

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

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29065182/viewspace-1162567/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29065182/viewspace-1162567/