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

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)