##########################
## Error
##########################
ORA-16033: parameter LOG_ARCHIVE_DEST_1 destination cannot be the same as
### Full Error
Alter system set log_archive_dest_1="location=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stdby";
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16033: parameter LOG_ARCHIVE_DEST_1 destination cannot be the same as
parameter LOG_ARCHIVE_DEST_4 destination
##########################
# Error Occurred
##########################
Error occured while trying to modify log_archive_dest_1 parameter to resolve archive gaps issue in our standby database
##########################
## Command Executed
##########################
In Sqlplus,
Alter system set log_archive_dest_1="location=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stdby";
##########################
## Issue Description.
##########################
###
Error occurred because, there is already a destination defined with the same physical location. so we need to define a new value.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_4 string LOCATION=USE_DB_RECOVERY_FILE_
DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=stdby
##########################
## Solution
##########################
Either change the value for LOG_ARCHIVE_DEST_4 to a different path or reset LOG_ARCHIVE_DEST_1 to a different value.
Alter system set log_archive_dest_4="location=/u01/app/oracle/11upgrade/stdby/rman_standby VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stdby";
