ORA-16626: failed to enable specified database

ORA-16626: failed to enable specified database
Cause: This status was returned when attempting to enable a standby database that:
- Could not locate itself in the broker configuration file.

- Failed to distinguish itself from two or more databases in the configuration file.

- Determined it missed a role change within the configuration.

Action: To correct the problem, try one of these actions:
- Confirm that the host and SID names for the database exactly match the values in the HOST_NAME and INSTANCE_NAME columns of V$INSTANCE.

- Confirm that there are not two or more databases with the same connect identifier. That is, multiple databases in the broker configuration should not reach the same database.

- If a failover had been performed and the old primary database has been re-created (or a standby database has been re-created), make sure the Data Guard broker configuration files have been removed for that database. Do NOT remove the configuration files that are in use by the new primary database.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:43

ORA-16626：无法启用指定的数据库,
.原因：尝试启用备用数据库时，返回以下状态：,
.- 无法在代理配置文件中找到自己。,
.,
.- 无法将其自身与配置文件中的两个或多个数据库区分开。,
.,
.- 确定它错过了配置中的角色更改。,
.,
.操作：要更正此问题，请尝试以下操作之一：,
.- 确认数据库的主机和SID名称与V $ INSTANCE的HOST_NAME和INSTANCE_NAME列中的值完全匹配。,
.,
.- 确认没有两个或更多具有相同连接标识符的数据库。也就是说，代理配置中的多个数据库不应到达同一数据库。,
.,
.- 如果已执行故障转移，并且已重新创建旧的主数据库（或已重新创建备用数据库），请确保已为该数据库删除Data Guard代理配置文件。不要删除新主数据库正在使用的配置文件。,
.,
.

aiaiDBA

13718043309

010-86462881

ORA-16626: failed to enable specified database

1 个回答

相似问题