ORA-16047: DGID mismatch between destination setting and target database
2 min readIssue : ORA-16047: DGID mismatch between destination setting and target database
alert.log
alter database register logfile '/opt/data/oracle3/prod101/FRA/prod101/archivelog/2019_12_01/o1_mf_1_190698_gy5z61jw_.arc'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: alter database register logfile '/opt/data/oracle3/prod101/FRA/prod101/archivelog/2019_12_01/o1_mf_1_190698_gy5z61jw_.arc'
Sun Dec 01 12:19:35 2019
Media Recovery Log /opt/data/oracle3/prod101/FRA/prod101/archivelog/2019_12_01/o1_mf_1_190698_gy5z61jw_.arc
Sun Dec 01 12:20:03 2019
Media Recovery Waiting for thread 1 sequence 190699
manually register archivelog
select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE';
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 VALID OPTIONAL
3 LOG_ARCHIVE_DEST_3 DISABLED OPTIONAL ORA-16047: DGID mismatch between destination setting and target
database
Since LOG_ARCHIVE_DEST_3 is getting error, we will defer it and enable it back, which will resolve the issue.
SQL> sho parameter log_archive_dest_state_3
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
log_archive_dest_state_3 string ENABLE
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
SQL>
SQL>
SQL> alter system set log_archive_dest_state_3=defer;
System altered.
SQL> sho parameter log_archive_dest_state_3
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
log_archive_dest_state_3 string DEFER
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE';
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 VALID OPTIONAL
3 LOG_ARCHIVE_DEST_3 DISABLED OPTIONAL ORA-16047: DGID mismatch between destination setting and target
database
SQL> alter system set log_archive_dest_state_3=ENABLE;
System altered.
SQL>
SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE';
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 VALID OPTIONAL
3 LOG_ARCHIVE_DEST_3 VALID OPTIONAL
Error is now resolved.
Hope it worked !! 🙂
