逻辑备库日志应用报错ORA-00600 [2619] 处理办法 - 重庆思庄Oracle、Redhat认证学习论坛

211345fa3aa02a4527.png (498.22 KB, 下载次数: 277)

2020-11-5 15:30 上传

看到600错误头晕了一阵，登录MOS去找答案先。

运气不错，很快找到了有关该异常的文档：(Doc ID 1422085.1）
文档中解决方案如下：
Solution
1. Resolve the disk space problem where archive log stored on Standby/Downstream site to make sure that there is no space issue.

2. Copy the problem archive log from the primary site and replace the one on the standby, before and after sequence# where got ORA-600 from source database, then restart recovery.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

3. Start the capture process.

原因是备库接收的日志有问题，需要重新去主库手动将归档文件复制过来。

赶紧去验证是否是这个问题：

SELECT SEQUENCE#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss'),to_char(NEXT_TIME,'yyyy-mm-dd hh24:mi:ss'),applied

FROM DBA_LOGSTDBY_LOG

WHERE applied=’NO’

ORDER BY SEQUENCE# desc;