Friday, October 29, 2021

ORA-16053: DB_UNIQUE_NAME my_dr, is not in the Data Guard

SQL> alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST DB_UNIQUE_NAME=my_d, valid_for=(ALL_LOGFILES, ALL_ROLES)' sid='*';

alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST DB_UNIQUE_NAME=my_dr valid_for=(ALL_LOGFILES, ALL_ROLES)' sid='*'
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16053: DB_UNIQUE_NAME my_dr, is not in the Data Guard

If you face ORA-16053, make sure the parameter log_archive_config contains the unique_db_name for the database you are trying to set log_archive_dest_n parameter for.

SQL> show parameter log_archive_config
NAME                           TYPE          VALUE
------------------------------ ----------- ------------------------------
log_archive_config        string      dg_config=(my_dr1,my_prod)

 As you can see above, the unique database name is mentioned my_dr1, whereas I used my_dr while setting log_archive_dest_1 parameter above.

You may also receive this error falsely because of some syntax error while setting log_archive_des_n parameter. See this article

No comments:

Post a Comment

Popular Posts - All Times