In My primary alert log,
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_3
******************************************************************
LGWR: Error 16047 creating archivelog file 'STREAMS'
Mon Oct 15 23:58:24 IST 2012
Errors in file /u02/app/oracle/admin/PROD/bdump/prod2_lns2_16765.trc:
ORA-16047: DGID mismatch between destination setting and standby
LNS: Failed to archive log 5 thread 2 sequence 2759 (16047)
Mon Oct 15 23:58:30 IST 2012
Errors in file /u02/app/oracle/admin/PROD/bdump/prod2_arc1_11140.trc:
ORA-16047: DGID mismatch between destination setting and standby
Mon Oct 15 23:58:30 IST 2012
FAL[server, ARC1]: Error 16047 creating remote archivelog file 'STREAMS'
FAL[server, ARC1]: FAL archive failed, see trace file.
Mon Oct 15 23:58:30 IST 2012
Errors in file /u02/app/oracle/admin/PROD/bdump/prod2_arc1_11140.trc:
ORA-16055: FAL request rejected
NAME TYPE VALUE
--------------------- --------- ------------------------------
log_archive_dest_3 string SERVICE=STREAMS LGWR ASYNC NOREG
ISTER VALID_FOR=(ONLINE_LOGFIL
ES,PRIMARY_ROLE) DB_UNIQUE_NAM
E=STREAMS
Well, my bad, I have changed the database name from TEST to STREAMS using NID, but forgot to changed the db_unique_name.
Settings in my standby
SQL> show parameter db_unique_name
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_unique_name string TEST1SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_name string STREAMSSQL> show parameter Instance_name
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
instance_name string STREAMSSQL>
🙁
Change the db_unique_name and bounced the instance , resolve the issue.
SQL> show parameter db_unique_name
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_unique_name string STREAMS
-Geek DBA
Follow Me!!!