(Oracle) Points Extract to the archived or backup Oracle

transaction logs when they reside somewhere other than

the default location. Extract first checks the specified

location and then checks the default location.

◆ specifies the fully qualified path to the

archived logs in the alternate directory. This directory

must be NFS mounted to the node where Oracle

GoldenGate is running. Use that mount point for

ALTARCHIVELOGDEST.

Options:

◆ PRIMARY prevents Extract from checking the default log

location if it does not find the log in the alternate

location. Only the ALTARCHIVELOGDEST path is checked.

PRIMARY is the default for an Extract that is running in

Archived Log Only (ALO) mode; otherwise, it is optional.

◆ INSTANCE applies the specified

ALTARCHIVELOGDEST behavior to a specific Oracle instance.

On RAC, if this option is used, you must specify the

ALTARCHIVELOGDEST parameter on each node.

◆ THREADID applies the specified ALTARCHIVELOGDEST

behavior to a specific thread number.

You can specify more than one ALTARCHIVELOGDEST parameter

for any given Oracle instance. In that case, Extract

searches each one in the order specified with

ALTARCHIVELOGDEST.

For example:

TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY INSTANCE

rac1 /disk1/node1/arch,

ALTARCHIVELOGDEST INSTANCE rac1 /disk2/node1/arch,

ALTARCHIVELOGDEST

INSTANCE rac2 /disk1/node2/arch

In this example, Extract searches under /disk1/node1/arch for

logs related to instance “rac1” then under /disk2/node1/arch if

the first search fails. Extract does not check the default

location for “rac1.” For “rac2”, it checks /disk1/node2/arch, then

the default location.