这篇博客记录了一次在数据泵使用parfile大量导入数据时遇到的问题，具体表现为ORA-00235和ORA-00448错误，这与并发更新导致的控制文件不一致有关。MOS（My Oracle Support）提供的解决方案是应用特定的补丁或者在单实例下启动重做应用。内容还涉及了standby redolog file和redo apply进程。
Mon Jan 13 23:38:22 2020
Archived Log entry 154072 added for thread 2 sequence 24013 ID 0x908b15a5 dest 1:
Mon Jan 13 23:39:09 2020
Thread 2 advanced to log sequence 24015 (LGWR switch)
Current log# 7 seq# 24015 mem# 0: +SSDDATA/test/onlinelog/group_7.276.946914269
Current log# 7 seq# 24015 mem# 1: +SSDDATA/test/onlinelog/group_7.277.946914273
Mon Jan 13 23:39:11 2020
Errors in file /home/app/oracle/diag/rdbms/test/test2/trace/test2_nsa2_164836.trc:
ORA-00235: control file read without a lock inconsistent due to concurrent update
LNS: Standby redo logfile selected for thread 2 sequence 24015 for destination LOG_ARCHIVE_DEST_2
问题发生在数据泵使用parfile导入大量数据的时候，MOS指示的解决方案如下：
CAUSE
This issue is caused due to
Bug 31047740 - INTERMITTENT ORA-00448 TERMINATING THE RECOVERY
SOLUTION
Apply
if available for your version and platform.
OR
Start Redo Apply on a single instance.
扫一扫
3611
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
