[Data Guard] ORA-16789: standby redo logs configured incorrectly

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 11.2.0.4

에러 : ORA-16789: standby redo logs configured incorrectly

데이터가드 DGMMGRL에서 

show configuration 시 아래 에러 발생

DGMGRL> connect system/oracle@adg1

Connected to "adg1"

Connected as SYSDBA.

DGMGRL> show configuration

Configuration - guard

  Protection Mode: MaxPerformance

  Members:

  adg1 - Primary database

    Warning: ORA-16789: standby redo logs configured incorrectly

    adg2 - Physical standby database 

Fast-Start Failover: DISABLED

Configuration Status:

WARNING   (status updated 5 seconds ago)

해결 방법 : acvite 서버에도 standby log를 추가해준다.(사이즈, 갯수 동일하게)

기존 용량이 209715200 bytes 일 경우

SQL> alter database add standby logfile '/app/oracle/oradata/adg1/standbylog01.log' size 209715200;

SQL> alter database add standby logfile '/app/oracle/oradata/adg1/standbylog05.log' size 209715200;

SQL> alter database add standby logfile '/app/oracle/oradata/adg1/standbylog03.log' size 209715200;

명령어로 추가 후 

enable configuration  입력 후 다시 확인

DGMGRL> connect system/oracle@adg1

Connected to "adg1"

Connected as SYSDBA.

DGMGRL> enable configuration

Enabled.

DGMGRL> show configuration

Configuration - guard

  Protection Mode: MaxPerformance

  Members:

  adg1 - Primary database

    adg2 - Physical standby database 

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS   (status updated 37 seconds ago)

원인 : active 서버에 standby log 가 없어서 발생한 오류

참조 :