Explicit assignment of logs
After a redo log file has been transferred
to the host running the Down Streams database, the log file
needs to be assigned to the Capture process explicitly using the
following DDL statement at the Down Streams database:
Format:
ALTER DATABASE REGISTER LOGICAL LOGFILE
file_name
FOR capture_process;
In the above format, the file_name
is the name of the redo log file and capture_process is
the name of the Capture process that will use the redo log file
at the Down Streams database. Thus, the redo log files need to
be added manually if the logfile_assignment parameter is
set to EXPLICIT.
The following is an example. Following the
SQL statement explicitly assigns the log file to the LN1_CAPTURE
process.
ALTER DATABASE REGISTER LOGICAL LOGFILE
‘/db_dumps/logs_from_tst10/1_14_1476.arc’
FOR LN1_capture;
The explicit type of configuration is useful for controlling the
capture flow. It allows the DBA to assign only the necessary
logs. This kind of situation may be useful to create a lab type
of replication environment that could be used to do
investigations of transactions, etc.
