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.