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
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
Members:
PROD1 - Primary database
SBDB11 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 2 seconds ago)
SUCCESS (status updated 2 seconds ago)