ORA-16424: RECOVER FINISH cannot complete due to a redo gap. ORACLE 报错 故障修复 远程处理

文档解释

ORA-16424: RECOVER FINISH cannot complete due to a redo gap.

Cause: RECOVER FINISH failed because there was a redo gap on the standby database.

Action: Resolve redo gap or issue ALTER DATABASE ACTIVATE STANDBY DATABASE to perform an immediate failover with some data loss.

ORA-16424: RECOVER FINISH不能完成，是由于存在着一个重做的间隙。

官方解释

常见案例

一般处理方法及步骤

1.检查日志序列是否完整，如果发现存在空洞，则重做。

SQL>Recover database until cancel;

2.如果日志序列是完整的，则用包含有软件级故障修复信息的日志文件重做，完成此次恢复操作。

SQL>Recover database until cancel using backup controlfile;