Unable to add physical standby database

💡 Recently I tried to setup some new physical standby databases and got the following strange message:

DGMGRL> ADD DATABASE "XXXX" as connect identifier is "XXXX" maintained as physical;
Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

🚚 Solution

Solution is following command on standby database to be added:

alter system set log_archive_dest_2 = '';

Nếu k được thì chạy cả trên máy primary

Related posts

Error: ORA-16765: Redo Apply is running

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB