ORA-16770: Redo Apply not started since physical standby database is opening

文档解释

ORA-16770: Redo Apply not started since physical standby database is opening

Cause: Redo Apply services could not be started on the physical standby database because it was being opened. The Data Guard broker will start Redo Apply services once the physical standby database has been opened.

Action: No action required.

。

ORA-16770 错误是由于物理备库处于打开状态导致redo apply无法开始，或由于redo apply停止状态导致无法打开备库。它表明备库正在从无效状态恢复，无法在物理备库上启动redo apply。

官方解释

This error is raised when a broker log apply or Data Guard logical standby apply is unable to start, or when a broker log apply or Data Guard logical standby apply is in the stopped state and an attempt has been made to open the standby database. It indicates that the standby database is being recovered from an invalid state and cannot start redo apply on the physical standby.

常见案例

1. 当开启物理备份时，错误 16770 将显示：

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Alter database recover managed standby database disconnect from session

*

ERROR at line 1:

ORA-16770:Redo Apply not started since physical standby database is opening

2. 响应更改时，可能会出现错误 16770：

SQL> ALTER DATABASE OPEN READ-ONLY;

Alter database open read-only

*

ERROR at line 1:

ORA-16770: Redo Apply not started since physical standby database is opening

一般处理方法及步骤

1.确保未作任何更改，使物理备份变为无效状态。

2.明确把数据库转换成完全备份模式：

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

3.等待恢复完成，可以重新尝试看看是否能够解决错误 16770。

4.如果上述步骤不起作用，请尝试重建日志数据库，确保重建备份完成，并且redo apply处于正常工作状态。