| Oracle® GoldenGate Oracle GoldenGate Veridataの管理 12c (12.1.3) E59460-02 |
|
 前 |
 次 |
この付録では、Oracle GoldenGate Veridataスクリプト・ユーティリティで使用するための、次のサンプル構成ファイルの内容について説明します。
この構成ファイルで使用されるパラメータの詳細は、5.2項「要素」を参照してください。
この項では、サンプル構成ファイルの内容について説明します。この構成ファイルの各要素の詳細は、5.2項「要素」を参照してください。
<?xml version="1.0" encoding="UTF-8"?>
<!-- Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved. -->
<!DOCTYPE configuration SYSTEM "configuration.dtd">
<configuration validation="required">
<connection name="sqlScriptingSource" host="localhost" port="7860"
user="source2" password="source2" agent-timeout="6000" truncate-spaces="true" fetch-size="4"/>
<connection name="sqlScriptingTarget" host="localhost" port="7862"
user="target2" password="target2"/>
<connection name="connection-with-properties" host="localhost"
port="7860" user="source2" password="source2" repairUser="source2" repairPassword="source2" agent-timeout="4000"
truncate-spaces="false" fetch-size="3" use-ssl="false">
<description>
<![CDATA[ SQL Scripting Source Connection with user defined properties]]>
</description>
<conn-properties datatype-name="array" format="clob"/>
<conn-properties datatype-name="binary_double" format="number" scale="3"/>
<conn-properties datatype-name="binary_float" format="dec_float" precision="5"/>
<conn-properties datatype-name="timestamp" format="binary_timestamp" scale="10" timezone="(UTC+05:30) Kolkata - India Time (IT)"/>
</connection>
<connection name="nskScriptingSource" host="server.us.company.com" port="9999"/>
<connection name="nskScriptingTarget" host="server.us.company.com" port="9999" />
<group name="column-mapping" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has various types of column mapping specifications.
]]>
</description>
<compare-pair source-table="SYSMAPPING1" name="exlcudeCol6">
<excluded-column name="COL6"/>
</compare-pair>
<compare-pair source-table="SYSMAPPING2" name="userDefinedKeys">
<key-column source-name="COL1" target-name="COL2"/>
<key-column source-name="COL2" target-name="COL3"/>
</compare-pair>
<compare-pair source-table="SYSMAPPING3" name="userDefinedColsWildCard">
<column source-name="COL.*" />
</compare-pair>
<compare-pair source-table="SYSMAPPING3" name="userDefinedColsLiteral">
<column source-name="COL5" target-name="COL6" type="literal"/>
<column source-name="COL.*" />
</compare-pair>
</group>
<group name="table-mapping" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="">
<description>
<![CDATA[
This group has table mapping specifications.
]]>
</description>
<compare-pair source-table="SYSMAPPING1" target-table="SYSMAPPING1" name="sameTables"
source-schema="SOURCE2" target-schema="TARGET2" >
</compare-pair>
<compare-pair source-table="SYSMAPPING2" target-table="SYSMAPPING3" name="diffTables"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
</compare-pair>
<compare-pair source-table="CHAR_*" target-table="*" name="sameTables"
source-schema="SOURCE2" target-schema="TARGET2" >
</compare-pair>
</group>
<group name="delta-processing" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has delta processing specifications.
]]>
</description>
<compare-pair source-table="SYSMAPPING1" target-table="SYSMAPPING1" name="scriptingConfigTest1"
delta-processing="true" >
<key-column source-name="COL1" target-name="COL2"/>
<key-column source-name="COL2" target-name="COL3"/>
<column source-name="COL5" target-name="COL6" type="literal"/>
<delta-config>
<source-config column-name="COL1">
<query><![CDATA[
SELECT MAX(COL1) from SYSMAPPING1
]]>
</query>
</source-config>
<target-config column-name="COL2">
<query><![CDATA[
SELECT MAX(COL1) from SYSMAPPING1
]]>
</query>
</target-config>
</delta-config>
</compare-pair>
</group>
<group name="enscribe-partition" source-conn="SourceNSKConnection" target-conn="TargetNSKConnection" validation="none">
<description>
<![CDATA[
This group has all the tables for NSK
]]>
</description>
<compare-pair source-file-pattern="\ZEUS.$FSS02.FSSVSRC.*" source-table="ACCTN*" target-file-pattern="\ZEUS.$FSS03.FSSVTAR.*" target-table="*" >
<enscribe-key
name = "Part1"
end-key ="1000"
format ="hexadecimal"
default ="false"
side="source"/>
<enscribe-key
name = "Part1"
start-key ="001"
format ="hexadecimal"
default ="false"
side="target"/>
<enscribe-key
name = "Both"
start-key ="001"
end-key ="1000"
default ="true"/>
</compare-pair>
</group>
<group name="sql-partition" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has sql partition specification.
]]>
</description>
<compare-pair source-table="SYSMAPPING1" name="PART1">
<sql-partition name="partition_wo_default" >
<![CDATA[
col4 > 50
]]>
</sql-partition>
<sql-partition name="part2" side="source">
<![CDATA[
col2 > 20
]]>
</sql-partition>
<sql-partition name="part2" side="target">
<![CDATA[
col3 > 30
]]>
</sql-partition>
</compare-pair>
<compare-pair source-table="SYSMAPPING2" name="PART2">
<sql-partition name="partition_default" default="true" >
<![CDATA[
col3 > 30
]]>
</sql-partition>
</compare-pair>
</group>
<group name="compare-pair-with-pkey" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has all the SYSMAPPING tables.
SYSMAPPING3 uses the user defined index B_SYSMAPPING4_IDX.
]]>
</description>
<compare-pair source-table="SYSMAPPING3" source-pkey="B_SYSMAPPING3_IDX"/>
<compare-pair source-table="SYSMAPPING*" target-table="*">
</compare-pair>
<compare-pair source-table="SYSMAPPING5" exclude="true"/>
</group>
<group name="enscribe-expand-ddl" source-conn="SourceNSKConnection" target-conn="TargetNSKConnection" validation="none">
<description>
<![CDATA[
This group has expand ddl specification for NSK
]]>
</description>
<compare-pair source-file-pattern="\ZEUS.$FSS02.FSSVSRC.*" source-table="TELLER" target-file-pattern="\ZEUS.$FSS03.FSSVTAR.*"
target-table="TELLER" name="excludeCompKeyCol">
<enscribe-info side="source"
dictionary="$FSS04.FSSVDCT" record="ENSSRC-REC">
<expandddl
redefined-columns ="include"
resolvedups="appendAlphaIndex"
expandGroupArrays="false"
ddl-separator="underscore"
zero-fill-length="1"
fix-long-names="false"
max-col-name-len="110"/>
</enscribe-info>
<enscribe-info side="target"
dictionary="$FSS04.FSSVDCT" record="ENSSRC-REC">
<expandddl />
</enscribe-info>
<excluded-column name="ENSCRIBE-NUMBER"/>
</compare-pair>
<compare-pair source-file-pattern="\ZEUS.$FSS02.FSSVSRC.*" source-table="TELLER" target-file-pattern="\ZEUS.$FSS03.FSSVTAR.*"
target-table="TELLER" name="userDefined">
<enscribe-info side="source"
dictionary="$FSS04.FSSVDCT" record="ENSSRC-REC"/>
<enscribe-info side="target"
dictionary="$FSS04.FSSVDCT" record="ENSSRC-REC"/>
<key-column source-name="KEY1" target-name="KEY1"/>
<column source-name="ENSCRIBE-STRING" target-name="ENSCRIBE-STRING"/>
<column source-name="FIRST-NAME" target-name="FIRST-NAME"/>
<column source-name="LAST-NAME" target-name="LAST-NAME"/>
<column source-name="ENSCRIBE-NUMBER" target-name="ENSCRIBE-NUMBER"/>
</compare-pair>
</group>
<group name="include-exclude-filter" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog=""
source-schema="SOURCE2" target-schema="TARGET2">
<description>
<![CDATA[
This group has include/exclude filter description
]]>
</description>
<filter type="include" table="SYSMAPPING*">
<colfilter type ="exclude">
<colfiltercol name="COL3" />
<colfiltercol name="COL6" />
</colfilter>
</filter>
<filter type="exclude" table="SYSMAPPING4">
</filter>
<compare-pair source-table="SYSMAPPING1" target-table="*" name="userDefinedCols"> <!-- exclude col6 -->
<column source-name="COL5" target-name="COL5"/>
<column source-name="COL6" target-name="COL6"/>
</compare-pair>
<compare-pair source-table="SYSMAPPING2" name="userDefinedKeys"> <!-- exclude col3 -->
<key-column source-name="COL1" target-name="COL2"/>
<key-column source-name="COL2" target-name="COL3"/>
</compare-pair>
<compare-pair source-table="SYSMAPPING3" target-table="*"><!-- exclude col3, col6 -->
</compare-pair>
<compare-pair source-table="SYSMAPPING4" target-table="*"/>
</group>
<group name="quotedSchemaQuotedTable" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog=""
source-schema=""abc 11"" target-schema=""abc 11"">
<description>
<![CDATA[
SQL group with simple quoted schema and quoted table name
]]>
</description>
<compare-pair source-table=""Quoted Table"" target-table="*" />
<compare-pair source-table=""Quoted*Table"" target-table="*" />
</group>
<group name="group-schema-wildcard" source-conn="sqlScriptingSource" target-conn="sqlScriptingTarget"
source-catalog="" target-catalog="" source-schema="source*" target-schema="*">
<description>
<![CDATA[
SQL group with source-schema wildcard at group level and no compare-pair schema.
]]>
</description>
<filter type="include" table="CHAR_TYPES*">
</filter>
<filter type="exclude" table="CHAR_TYPES2*">
</filter>
<compare-pair source-table="CHAR_TYPE*" target-table="*">
</compare-pair>
</group>
<job name="test" profile="allParams">
<group name="column-mapping"/>
<group name="table-mapping"/>
<group name="delta-processing"/>
</job>
<profile name="allParams">
<description>
<![CDATA[
Full Profile description.
]]>
</description>
<profile-general>
<param name="oos-format" value="xml" />
<param name="oos-xml-chunk-size" value="1000" />
<param name="reports-insync" value="true" />
<param name="reports-inflight" value="true" />
</profile-general>
<sorting-method>
<param name="sort-method" value="server" />
<param name="sort-src-temp-dir" value="/dummy/location" />
<param name="sort-tar-temp-dir" value="/dummy/location" />
</sorting-method>
<initial-compare>
<param name="max-thread" value="6" />
<param name="max-oos-record" value="777777" />
<param name="output-oos-rpt" value="true" />
<param name="update-rpt-second" value="100" />
<param name="update-rpt-record" value="100" />
<param name="limit-input-row" value="100" />
<param name="src-oracle-hint" value="FIRST_ROWS(10)" />
<param name="tar-oracle-hint" value="FIRST_ROWS(10)" />
<param name="rpt-msg" value="both" />
<param name="rpt-warn-msg-threshold" value="100" />
<param name="src-agent-static-port" value="777" />
<param name="tar-agent-static-port" value="777" />
<param name="src-nsk-name" value="$AA*" />
<param name="src-nsk-cpu" value="2" />
<param name="src-nsk-priority" value="1" />
<param name="tar-nsk-name" value="$AA*" />
<param name="tar-nsk-cpu" value="2" />
<param name="tar-nsk-priority" value="1" />
</initial-compare>
<confirm-out-of-sync>
<param name="coos-enable" value="false" />
<param name="coos-concurrent" value="false" />
<param name="batch-size" value="15"/>
<param name="coos-delay" value="2" />
<param name="max-oos-record" value="777777" />
<param name="output-oos-rpt" value="true" />
<param name="update-rpt-second" value="100" />
<param name="update-rpt-record" value="100" />
<param name="src-oracle-hint" value="FIRST_ROWS(10)" />
<param name="tar-oracle-hint" value="FIRST_ROWS(10)" />
<param name="rpt-msg" value="both" />
<param name="rpt-warn-msg-threshold" value="100" />
<param name="src-agent-static-port" value="777" />
<param name="tar-agent-static-port" value="777" />
<param name="src-nsk-name" value="$AA*" />
<param name="src-nsk-cpu" value="2" />
<param name="src-nsk-priority" value="1" />
<param name="tar-nsk-name" value="$AA*" />
<param name="tar-nsk-cpu" value="2" />
<param name="tar-nsk-priority" value="1" />
</confirm-out-of-sync>
<repair>
<param name="repair-after-compare" value="true" />
<param name="batch-size" value="15" />
<param name="txn-size" value="2" />
<param name="concurrent-operation" value="2" />
<param name="check-change-value" value="false" />
<param name="terminate-max-warn" value="77777" />
<param name="write-success-rpt" value="false" />
<param name="disable-trigger" value="true" />
</repair>
</profile>
</configuration>
