ORA-38788: More standby database recovery is needed ORACLE 报错 故障修复 远程处理

文档解释

ORA-38788: More standby database recovery is needed

Cause: An attempt was made to create a restore point or a guaranteed while a physical standby database is not cleanly checkpointed.

Action: Perform more standby database recovery via managed standby database recovery. Cancel managed recovery and retry the command.

官方解释

常见案例

一般处理方法及步骤

1.收集错误日志,了解更多字段以及数据库当前的恢复状态。

2.确定需要的日志文件的类型、大小、存放位置,并将其拷贝回standby服务器。

3.使用recover standby database命令,将日志文件继续恢复回standby服务器。

4.最后使用alternate的recover managed standby database命令,来开启standby恢复。


数据运维技术 » ORA-38788: More standby database recovery is needed ORACLE 报错 故障修复 远程处理