ORA-16815: incorrect redo transport setting for AlternateLocation for standby database “string” ORACLE 报错 故障修复 远程处理

文档解释

ORA-16815: incorrect redo transport setting for AlternateLocation for standby database “string”

Cause: The Data Guard broker detected an incorrect redo transport setting for a standby database AlternateLocation property. The incorrect setting could be one of the following:
– The AlternateLocation property was empty, but the redo transport to the standby database had an ALTERNATE setting.
– The AlternateLocation property was not empty and the redo transport to the standby database had no ALTERNATE setting.
– The AlternateLocation property did not match the ALTERNATE setting in the redo transport. The mismatch may include service string, directory specification of the alternate location, or the DB_UNIQUE_NAME attribute.
– The LOG_ARCHIVE_DEST_STATE_n parameter corresponding to the alternate location was not set to ALTERNATE.
– The flash recovery area was being used by the standby database for archived logs, but the redo transport to the standby database still had an ALTERNATE setting for the AlternateLocation property. Data Guard broker logs provide more details on which of the above cases caused the error.

Action: Reenable the primary database to clear the error.

ORA-16815：对于Standby数据库”string”的AlternateLocation的重做传输设置不正确

官方解释

这是一个警告性的错误，说明在使用Data Guard环境设置AlternateLocation时，没有适当设置redo传输设置。

常见案例

当通过Data Guard的DG Broker实现跨站点的镜像数据库时，可能会出现这个错误。 因为在镜像配置过程中，可能会忘记设置主库和备库之间的redo传输设置。

一般处理方法及步骤

1.从备库终端打开SQL * Plus。

2.连接到“ SYSDG ”（数据库管理员）帐户上。

3.单击SQL>。

4.运行以下命令以设置重做传输：

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

5.重新启动你的备份数据库。