Linux or UNIX example:

Windows example:

Default path is the TMP or TMPDIR environment variable value. If TMP or TMPDIR is not defined, the configuration uses the current directory.

New

. Specifies a list of numbers from 1 to 10, separated by commas. Each number represents the

n

value in an Oracle LOG_ARCHIVE_DEST_

n

initialization parameter. If you create more than one copy of each archive log, this parameter indicates the primary and secondary log destinations from which PowerExchange Express CDC reads archived logs. You can specify up to 10 destinations. The order in which you specify the destinations in the list determines the order in which PowerExchange Express CDC searches for archive logs. PowerExchange Express CDC tries to process the first two valid logs it finds in the specified destinations. If PowerExchange cannot read the first two logs, the process terminates.

PowerExchange Express CDC uses the secondary destination when the primary destination becomes unavailable or when the logs at the primary destination are unreadable, for example, because they have been corrupted or deleted.

For example, the Oracle source database uses the Oracle parameters LOG_ARCHIVE_DEST_1, LOG_ARCHIVE_DEST_2, and LOG_ARCHIVE_DEST_3 to create copies of archived logs. If you want PowerExchange Express CDC to use LOG_ARCHIVE_DEST_2 as the primary destination and ARCHIVE_DEST_3 as the secondary destination, set ARCHIVEDEST=(2,3).

If you do not specify ARCHIVEDEST, PowerExchange Express CDC queries v$archived_log for valid logs, favoring file system logs over ASM logs for performance reasons. Specifying ARCHIVEDEST provides more control over this process. For example, if the database writes archive logs to ASM and the file system, and you do not have access to the file system logs, you can use ARCHIVEDEST to specify the ASM location only.

This parameter replaces the ARCHIVEDEST1 and ARCHIVEDEST2 parameters. ARCHIVEDEST1 and ARCHIVEDEST2 are deprecated.