今天启动一个extract时,出现以下错误:2011-10-16 22:41:02 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, e430rks2.prm: Could not find archived log for sequence 10770 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = "YES" AND deleted = "NO>, error retrieving redo file name for sequence 10770, archived = 1, use_alternate = 0Not able to establish initial position for sequence 10770, rba 78960656.
2011-10-16 22:41:02 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, e430rks2.prm: PROCESS ABENDING.原因是extract 所需的archived log已经被清走,不在log_archive_dest指定的目录下,解决方法很简单,只要把sequence 从10770开始到当前的archived log重新拷贝回log_archive_dest目录下即可。Oracle数据库bug,表或试图不存在,表名中包含空格Hibernate Oracle ID 自动增长 1相关资讯 Oracle错误代码
- Oracle错误代码大全 (02/16/2015 21:31:57)
- Oracle中登陆时报ORA-28000: the (03/06/2013 20:06:23)
- Oracle 11g startup时报ORA-03113 (02/21/2013 17:25:55)
| - Oracle Grid Control OUI-25031错 (03/09/2013 09:01:36)
- ORA-04091:触发器/函数不能读 (02/25/2013 08:28:13)
- Oracle错误 ORA-12514 解决方法 (02/18/2013 08:50:10)
|
本文评论 查看全部评论 (0)