Error: ORA-16664: unable to receive the result from a database

千家信息网最后更新 2025年02月01日Error: ORA-16664: unable to receive the result from a database

DGMGRL> show configuration;

报错：

Configuration - DG12C

Protection Mode: MaxPerformance
Members:
PROD1 - Primary database
SBDB1 - Physical standby database
Error: ORA-16664: unable to receive the result from a database Fast-Start Failover: DISABLED

Configuration Status:
ERROR (status updated 68 seconds ago)

原因： LOG_ARCHIVE_CONFIG 参数没有设置。

解决办法：

SYS@SBDB1>alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(SBDB1,PROD1)';

DGMGRL> remover configuration;

重新配置：

DGMGRL> show configuration; Configuration - dg Protection Mode: MaxPerformance
Members:
PROD1 - Primary database
SBDB11 - Physical standby database Fast-Start Failover: DISABLED Configuration Status:
SUCCESS (status updated 2 seconds ago)