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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s