CDC Guide for Linux, UNIX, and Windows

10.0
- 10.2.2
- 10.2.1
- 10.2

Back Next

DIRSUB Statement

The DIRSUB statement specifies a path prefix that PowerExchange Express CDC substitutes for the original path prefix that the Oracle server uses to access active and archived redo logs.

This substitute path is required when the PowerExchange Express CDC log reader runs on a system other than the Oracle server and uses a different mapping to access the redo log files. The redo logs might reside on shared disk, or they might have been copied to the system where Express CDC runs.

Use this statement only under the following conditions:

You do not use Oracle Automatic Storage Management (ASM) to manage the redo logs that PowerExchange Express CDC needs to access.

PowerExchange Express CDC runs on a system that has the same operating system and architecture as the Oracle server.

You can specify multiple DIRSUB statements. Each one must have a unique value for the original path prefix that Oracle server uses. PowerExchange compares the original path prefix against redo log directories and file names, starting with the longest string for a file. For the matching log files, the PowerExchange Express CDC log reader uses the corresponding substitute path prefix to access the redo logs.

DIRSUB SERVER="original_path_prefix",LOCAL="substitute_path_prefix";

If you want to include a trailing backslash in a Windows path, you must enter a double backslash (\\).

SERVER: Required. The original path prefix for the redo logs that the Oracle server uses. This value must be unique in each DIRSUB statement.
LOCAL: Required. The substitute path prefix that the PowerExchange Express CDC log reader uses to access redo logs. This value does not have to be unique across multiple DIRSUB statements.

The Oracle server and PowerExchange Express CDC run on separate Linux systems. The redo logs reside on shared disk. In this case, the PowerExchange Express CDC configuration file contains the following DIRSUB statement:

DIRSUB SERVER="/ora01/oraarchlogs/ORAB11",LOCAL="/oracle/oralogs/orab";

Rename Saved Search

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

DIRSUB Statement

DIRSUB Statement