Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Saturday, December 04, 2010

OGG Reference - Commands and Options

Use TRANLOG as the data source option, It specifies the transaction log as the data source.Use this option for all databases except Teradata. TRANLOG requires the BEGIN option.
Use the BEGIN parameter to start processing with the first record in the database
transaction log or Oracle GoldenGate trail that has a timestamp greater than, or equal to,
the time specified with BEGIN. All subsequent records, including records where the
timestamp is less than the specified time, are processed.
Use the ASSUMETARGETDEFS parameter when the source and target tables specified with a
MAP statement have identical column structure, such as when synchronizing a hot site. It
directs Oracle GoldenGate not to look up source structures from a source-definitions file.
Use the SOURCEDEFS parameter to specify the name of a file that contains definitions of
source tables or files. Source definitions are required when using Oracle GoldenGate in a
heterogeneous synchronization environment, where source and target table structures are
different. Use SOURCEDEFS for one or more of the following processes, depending on your
Oracle GoldenGate configuration:
● A Replicat process on the target system
● A data pump on a source or intermediary system.
Use the TRANLOGOPTIONS parameter to control aspects of the way that Extract interacts with
the transaction logs. You can use multiple TRANLOGOPTIONS statements in the same
parameter file, or you can specify multiple options within the same TRANLOGOPTIONS
statement, if permissible for those options.
Use a given TRANLOGOPTIONS option only for the database or databases for which it is
Option ALTARCHIVEDLOGFORMAT:  (Oracle) Specifies a string that overrides the archive log
format of the source database. accepts the same specifier as Oracle's parameter LOG_ARCHIVE_FORMAT. Extract uses the supplied format specifier to derive the log file name.
Option ALTARCHIVELOGDEST:  (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.
Option PATHMAP : (Oracle) Use to specify the location of the redo and/or
archived logs when they are stored on a system other than the one which is hosting the database. Specify the NFS mount point followed by the path to the Oracle log structure(s). More than one PATHMAP statement can be used.

Related Posts:

Oracle GoldenGate Tutorial Part 1 - Concepts and Architecture 
Oracle GoldenGate Tutorial Part 2 - Installation (Windows 2003) 
Oracle GoldenGate Tutorial Part 3 - Manager process 
Oracle GoldenGate Tutorial Part 4 - Working with OGG 
Live Reporting with OGG 
Live Reporting with Data Pump -GG 
SQL Server to SQL Server Replication using GG

No comments: