ORA-16047: DGID mismatch between destination setting and target database

by

Issue : ORA-16047: DGID mismatch between destination setting and target database

1
2
3
4
5
6
7
8
9
10
11
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
1
2
3
4
5
6
7
8
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.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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
1
2
3
4
5
6
7
8
9
10
11
12
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 !! 🙂