aiaiDBA

加微信获取免费职业规划+学习资料，了解年薪50万的DBA是如何练成的

13718043309

010-86462881

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

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.

请先 登录 后评论
默认排序 时间排序

1 个回答

小智
ORA-16815：备用数据库的AlternateLocation的重做传输设置不正确“ string ”,
.原因： Data Guard代理检测到备用数据库AlternateLocation属性的重做传输设置不正确。不正确的设置可能是以下之一：,
.- AlternateLocation属性为空，但是到备用数据库的重做传输具有ALTERNATE设置。,
.,
.- AlternateLocation属性不为空，并且重做传输到备用数据库没有ALTERNATE设置。,
.,
.- AlternateLocation属性与重做传输中的ALTERNATE设置不匹配。不匹配可以包括服务字符串，备用位置的目录规范或DB_UNIQUE_NAME属性。,
.,
.- 对应于备用位置的LOG_ARCHIVE_DEST_STATE_n参数未设置为ALTERNATE。,
.,
.- 备用数据库正在使用闪存恢复区域存档归档日志，但是对备用数据库的重做传输仍然具有AlternateLocation属性的ALTERNATE设置。Data Guard代理日志提供了有关上述哪些情况导致错误的更多详细信息。,
.,
.操作：重新启用主数据库以清除错误。,
.
请先 登录 后评论
  • 1 关注
  • 0 收藏，841 浏览
  • 慧慧 提出于 2018-08-30 16:43

相似问题