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

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

ORA-16086: Redo data cannot be written to the standby redo log