Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



logfile_assignment parameter to EXPLICIT

Oracle Tips by Burleson 

Explicit assignment of logs

In this method, the steps are pretty much the same those presented in the implicit section. The major difference is setting the logfile_assignment parameter to EXPLICIT for the procedure create_capture of dbms_capture_adm while creating the Capture process at Down Streams database.

An example of capture creation with explicit assignment is shown below:

queue_name               => 'ln1_queue',
capture_name             => 'ln1_capture',
rule_set_name            => NULL,
start_scn                => NULL,
source_database          => '',
use_database_link        => false,
first_scn                => 155781561, -- Use value from build proc
logfile_assignment       => 'explicit');

In this method, the log files are assigned to the Capture process explicitly by a command. The required redo log files need to be transferred to the Down Streams database location by FTP or another copy method.

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:

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.

‘/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.


The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks