ORA-16053: DB_UNIQUE_NAME orcldgp is not in the Data Guard Configuration

Cause:

In physical standby dataguard, i was trying to add log_archive_dest_n parameter but face the below error for db unique name

SQL> alter system set log_archive_dest_3='service=orcldgp async valid_for=(online_logfiles,primary_role) db_unique_name=orcldgp';
alter system set log_archive_dest_3='service=orcldgp async valid_for=(online_logfiles,primary_role) db_unique_name=orcldgp'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16053: DB_UNIQUE_NAME orcldgp is not in the Data Guard Configuration

Workaround:

Set log_archive_config parameter before adding log_archive_dest_n parameter

SQL> alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(ORCL,ORCLDG,ORCLDGP)';

System altered.

Now it work like a charm!

SQL> alter system set log_archive_dest_3='service=orcldgp async valid_for=(online_logfiles,primary_role) db_unique_name=orcldgp';

System altered.

Leave a Reply