Specifying the Database Logs from Which to Extract Data
To extract change data from DB2 for Linux, UNIX, and Windows archive logs
, Microsoft SQL Server backup logs,
MySQL binary logs,
or Oracle archived redo logs and backup sets, you must specify the location of the log files. The log files can be on the local system or a remote system.
Data Replication searches for the last-used paths and directories for the Microsoft SQL Server backup log files
, MySQL binary log files,
or Oracle archived redo logs and displays these locations on the
Extract Range
tab, if found. For DB2 sources, you must add the directory that contains the DB2 archive log files.
Optionally, you can filter the logs for DB2,
Microsoft SQL Server,
and Oracle sources. Also, for
Microsoft SQL Server
and Oracle sources, you can configure extraction processing for database online logs.
Click the
Extract Range
tab.
To disable change data capture from online logs, clear one of the following options, depending on your source database type:
For Microsoft SQL Server sources, clear
Read from online transaction logs
.
For Oracle sources, clear
Read from online logs
.
By default, Data Replication captures change data from online logs for these source types.
To add the directory for DB2 archive logs
, Microsoft SQL Server backup logs,
MySQL binary logs,
or Oracle archived redo logs and backup sets:
Click
Add Directory
.
In the
Add Directory
dialog box, select one of the following options to indicate the location of the log files:
File system
. Use the location of the log files that you specify on the file system of the computer where the source Server Manager runs or on a network mapped share, such as NFS or Samba.
This option is the only available option for MySQL sources.
Oracle ASM
. For Oracle sources, use the location of the archived log files in ASM.
Default Archive Logs
. For DB2,
Microsoft SQL Server,
and Oracle sources, search for archived logs in the database-specific location. Oracle archived redo logs can be in RMAN backup sets.
The selected option determines what is displayed in the directory tree.
Specify the directory that Data Replication scans for the log files in one of the following ways:
In the
User-defined path
field, type the directory path and press Enter.
In the directory tree, select the directory that contains the log files.
For DB2, Oracle, and Microsoft SQL Server sources, select
Scan subfolders
to recursively search for log files in the subfolders of the specified directory.
In the
Filter files
field
or
Base Bin Log File Name
field
, enter a mask for the names of the log files in the selected directory to be read.
For MySQL sources, enter a mask for the base names of the binary log files.
You can use the following wildcard characters:
An asterisk (*) to match all characters
A question mark (?) to match any single character
Square brackets ([ ]) to match only one out of several characters
For example, to read all files with the .bak extension, enter *.bak.
The
Filter files
or
Base Bin Log File Name
field cannot be empty. The default is the asterisk (*) wildcard character.
Click
OK
.
The directory path, filter mask, and scan subfolders setting are displayed on the
Extract Range
tab.
The following image shows an example of a user-defined path to Oracle archive log files:
To edit the log path or filter, right-click the path and click
Edit
. To remove the log path and filter, right-click the path and click
Remove
, or select the path and click the
Remove Selected
button.
Repeat steps a through f to specify additional log-file locations.
For Oracle sources, if you specified multiple archive destinations, drag and drop the destinations in order of priority for Oracle Extractor processing. The first destination in the list has the highest priority, and the last destination has lowest priority.
The Extractor starts reading redo logs or RMAN backup sets from the destination with the highest priority. If the Extractor cannot read a redo log at that destination, it switches to the destination with the next lower priority.
Under
Transaction log format
, specify the DB2 or Oracle platform type and characteristics, which affect log file allocation:
In the
Platform with logs
list, select the platform type of the system that contains the source transaction logs. If you do not select a platform type, the
Use default
value remains selected, which causes the Extractor to use the platform on which the source database runs.
Select
Little endian system
for a little-endian system. Clear this box for a big-endian system.
In the
System block size (bytes)
field, accept the default value that is displayed for the selected platform type or enter another value.
In the
Disk align size (bytes)
field, accept the default that is displayed for the selected platform type or enter another value.