aiaiDBA

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

13718043309

010-86462881

ORA-16620: one or more databases could not be reached for a delete operation

ORA-16620: one or more databases could not be reached for a delete operation
Cause: One or more standby databases could not be reached for either a DGMGRL CLI REMOVE DATABASE or a REMOVE CONFIGURATION command.
Action: This typically indicates a network problem where the standby database is unable to respond to the primary database. In the event of this situation, examine the primary database Data Guard broker log to determine which standby databases could not be reached. For each standby database not reached, connect to that database and shut down the broker by setting the initialization parameter, DG_BROKER_START, to false. After the broker has been shut down for the standby database, locate the Data Guard broker configuration files from the standby database DG_BROKER_CONFIG_FILE[1|2] initialization parameter values and delete them. Then restart the broker by setting DG_BROKER_START to true.

请先 登录 后评论

1 个回答

小智
ORA-16620:无法访问一个或多个数据库进行删除操作,
.原因:无法通过DGMGRL CLI REMOVE DATABASE或REMOVE CONFIGURATION命令访问一个或多个备用数据库。,
.操作:这通常表示备用数据库无法响应主数据库的网络问题。发生这种情况时,请检查主数据库Data Guard代理日志以确定无法访问哪些备用数据库。对于未达到的每个备用数据库,请连接到该数据库并通过将初始化参数DG_BROKER_START设置为false来关闭代理。为备用数据库关闭代理后,从备用数据库DG_BROKER_CONFIG_FILE [1 | 2]初始化参数值中找到Data Guard代理配置文件并将其删除。然后通过将DG_BROKER_START设置为true来重新启动代理。,
.
请先 登录 后评论