<<Back to Oracle DataGuard Main Page
How to Resolve : ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
DGMGRL> ADD DATABASE "ORCL3PS" AS CONNECT IDENTIFIER IS "ORCL3PS";
Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
Cause:
One of log_archive_dest_n parameter is set for service ORCL3PS in either primary or standby or both databases
Solution:
Identify the log_archive_dest_n parameter which is set to value ORCL3PS and rest it.
SQL> show parameter dest_4
log_archive_dest_4 string SERVICE=ORCL3PS.EU.MERCKGROUP.C
OM DB_UNIQUE_NAME=ORCL3PS
OM DB_UNIQUE_NAME=ORCL3PS
SQL> alter system set log_archive_dest_4 ='';
DGMGRL> ADD DATABASE "ORCL3PS" AS CONNECT IDENTIFIER IS "ORCL3PS.EU.MERCKGROUP.COM";
Database "ORCL3PS" added
Comments
Post a Comment