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='*' |
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 |
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