Dbvisit CSD task fails with ORA-16026: parameter LOG_ARCHIVE_DEST_1 contains an invalid attribute value

Read our docs Dbvisit CSD task fails with the below error. This is a known issue that Dbvisit cannot distinguish between a comma as a value separate and a comma as a part of value, in database parameters value

Problem Details

Problem Statement

Applicable Error Code

Error executing RMAN command. 
RMAN-03002: failure of startup command at 04/15/2024 09:06:55 
RMAN-04014: startup failed: ORA-16026: parameter LOG_ARCHIVE_DEST_1 contains an invalid 
attribute value

Affected Versions

All versions

Affected Platforms

Workaround

1. Edit the standby database parameter

2. Escape the comma character in both parameters using \, i.e. set the following:
Also don't use single quotes to enclose this value

*              listener_networks                       ((NAME=net1)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.100.12)(PORT=1521)))))
*              log_archive_dest_1                      LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES\,ALL_ROLES) MAX_FAILURE=1 REOPEN=5 DB_UNIQUE_NAME=TEST01_DR ALTERNATE=log_archive_dest_10
*              log_archive_dest_10                     LOCATION=+DATA/TEST01_DR/arc10 VALID_FOR=(ALL_LOGFILES\,ALL_ROLES) DB_UNIQUE_NAME=TEST01_DR ALTERNATE=log_archive_dest_1

We're here to help!

Comments