[ORACLE] ORA-16736: unable to find the destination entry of member "dgpri" in V$ARCHIVE_DEST

Switchover 이후 test 테이블에 삽입 후 로그 스위칭 진행

alter system switch logfile;

이후 반응이 없음

---

📌 상태 확인

Primary 상태확인:

DGMGRL> show database dgpri;

Database - dgpri

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      (unknown)
  Apply Lag:          (unknown)
  Average Apply Rate: (unknown)
  Real Time Query:    ON
  Instance(s):
    DGDB

  Database Warning(s):
    ORA-16854: apply lag could not be determined
    ORA-16856: transport lag could not be determined
    ORA-16858: last communication time from redo source could not be determined

Database Status:
WARNING

 

 

Standby 상태확인:

DGMGRL> show database dgstby

Database - dgstby

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    DGDB
      Error: ORA-16736: unable to find the destination entry of member "dgpri" in V$ARCHIVE_DEST
      Warning: ORA-16728: consistency check for property RedoRoutes found ORA-16777 error
      Warning: ORA-16777: unable to find the destination entry of a member in V$ARCHIVE_DEST
      Warning: ORA-16728: consistency check for property LogXptMode found ORA-16777 error
      Warning: ORA-16777: unable to find the destination entry of a member in V$ARCHIVE_DEST
      Warning: ORA-16728: consistency check for property DelayMins found ORA-16777 error
      Warning: ORA-16777: unable to find the destination entry of a member in V$ARCHIVE_DEST
      Warning: ORA-16728: consistency check for property Binding found ORA-16777 error
      Warning: ORA-16777: unable to find the destination entry of a member in V$ARCHIVE_DEST
      Warning: ORA-16728: consistency check for property MaxFailure found ORA-16777 error
      Warning: ORA-16777: unable to find the destination entry of a member in V$ARCHIVE_DEST
      Warning: ORA-16728: consistency check for property ReopenSecs found ORA-16777 error
      Warning: ORA-16777: unable to find the destination entry of a member in V$ARCHIVE_DEST
      Warning: ORA-16728: consistency check for property RedoCompression found ORA-16777 error
      Warning: ORA-16777: unable to find the destination entry of a member in V$ARCHIVE_DEST

Database Status:
ERROR

log_archive_dest의 문제인걸 확인

 

archive log 상태 확인:

SQL> select dest_id, status, destination from v$archive_dest;

   DEST_ID STATUS    DESTINATION
---------- --------- --------------------
         1 BAD PARAM /u01/app/oracle/fast
                     _recovery_area

fast_recovery_area의 문제인걸 확인

 

log 파라미터 확인:

SQL> show parameter recover

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0
db_unrecoverable_scn_tracking        boolean     TRUE
recovery_parallelism                 integer     0
remote_recovery_file_dest            string

recovery_file_dest 파라미터가 등록되있지 않고 현재 standby에 디렉토리도 없는걸 확인했음

 

👉 즉, recovery_file_dest 경로 등록과 디렉토리를 찾지못해 장애 발생한걸로 확인됨

---

🔍 문제 해결

1️⃣ FRA(Fast_Recovery_area) 디렉토리

현재 standby에서 FRA 디렉토리 생성:

mkdir /u01/app/oracle/fast_recovery_area

 

FRA 디렉토리의 권한 설정:

chown -R oracle:oinstall /u01/app/oracle/fast_recovery_area
chmod -R 750 /u01/app/oracle/fast_recovery_area

 

2️⃣ FRA 파라미터 재설정

FRA 크기 설정:

ALTER SYSTEM SET db_recovery_file_dest_size=20G SCOPE=BOTH;

 

FRA 경로 설정:

ALTER SYSTEM SET db_recovery_file_dest='/u01/app/oracle/fast_recovery_area' SCOPE=BOTH;

 

3️⃣ Broker 재기동

ALTER SYSTEM SET dg_broker_start=FALSE SCOPE=BOTH;
ALTER SYSTEM SET dg_broker_start=TRUE  SCOPE=BOTH;

 

✅ 최종 확인

DGMGRL> show configuration;
DGMGRL> show database dgstby;
DGMGRL> show database dgpri;