DMSでOracle SE2 12c（EC2）からOracle SE2 19c（RDS）への移行手順

小林　剛


この記事は公開されてから1年以上経過しています。情報が古い可能性がありますので十分ご注意ください。

背景

AWS Database Migration Service(DMS)でOracle SE2 12c（EC2）からOracle SE2 19c（RDS）への移行手順を検証しましたので、備忘録として構築手順を残したいと思います。

前提

・VPCが作成済みであること
・RDS用のセキュリティグループが作成済みであること
・CloudFormationのテンプレートをyaml形式とする。
・AWSの管理者ユーザで検証しています。
・AWSコンソール上でスタックを作成します（作成手順を割愛します）。
・S3バケットとIAMロールの作成手順を割愛します。
・検証用ソースDBと検証用ターゲットDBが作成済みであること

参照：
ソースDBの作成手順
Oracle Database 12c Standard Edtion 2 (12.1.0.2)のWindowsへのインストールと移行用DBの作成手順

ターゲットDBの作成手順
CloudFormationでRDS構築（Oracle SE2 19c bring-your-own-license）を構築する手順

構成図

DMSの仕組み

DMSは、
● Replication Instance (データレプリケーションを実行するインスタンス)
● Replication Task (データレプリケーションの実行単位)
● Source Endpoint (ソースデータベースへの接続定義)
● Target Endpoint (ターゲットデータベースへの接続定義)
で構成されます。

file

https://docs.aws.amazon.com/ja_jp/dms/latest/userguide/Welcome.html より抜粋

今回検証用の構成図

file

構築手順

1.DMSインスタンス用セキュリティグループの作成

Cfnで作成します。
テンプレート

AWSTemplateFormatVersion: '2010-09-09'
Description: KbyDev3-Tyo-Sg-Kobayashi-DMS
Resources:
  KbyDev3TyoSgKobayashiDMS:
    Type: AWS::EC2::SecurityGroup
    Properties:
      GroupName: KbyDev3-Tyo-Sg-Kobayashi-DMS
      GroupDescription: KbyDev3-Tyo-Sg-Kobayashi-DMS
      SecurityGroupIngress:
        - IpProtocol: tcp
          FromPort: 1521
          ToPort: 1521
          CidrIp: '0.0.0.0/0'
      Tags:
      - Key: Name
        Value: KbyDev3-Tyo-Sg-Kobayashi-DMS
      - Key: User
        Value: kobayashi
      - Key: env
        Value: KbyDev3
      VpcId: !ImportValue KbyDev3-Tyo-Vpc
Outputs:
  KbyDev3TyoSgKobayashiDMS:
    Value:
      Ref: KbyDev3TyoSgKobayashiDMS
    Export:
      Name: KbyDev3-Tyo-Sg-Kobayashi-DMS

2.サブネットグループの作成

file

file

file

file

3.レプリケーションインスタンスの作成

file

file

file

file

file

file

file

4.ソースエンドポイントの作成

file

file

file

file

file

file

file

file

file

5.ターゲットエンドポイントの作成

file

file

file

file

file

file

file

file

6.S3バケットとIAMロールの用意

手順を割愛します。
S3バケット：kobayashi-dms-test
IAMロール：
kobayashi-dms-s3-test-role
dms-vpc-role
dms-cloudwatch-logs-role

DMSサービスからS3バケットにアクセスするためのロールが事前に作成する必要がある。

以下の公式ドキュメントを参照してロールを作成する。

https://docs.aws.amazon.com/ja_jp/dms/latest/userguide/CHAP_Tasks.AssessmentReport.html

作成したバケットに権限を付与するようにして、「kobayashi-dms-test-policy」という名前のポリシーを作成する。
file

file

file

DMSサービスからCloudWatchLogsにアクセスするための「AmazonDMSCloudWatchLogsRole」ポリシーにアタッチしている「dms-cloudwatch-logs-role」という名前のDMSサービスロールが事前に作成する必要がある。

file

file

DMSサービスからCloudWatchLogsにアクセスするための「AmazonDMSCloudWatchLogsRole」ポリシーにアタッチしている「dms-cloudwatch-logs-role」という名前のDMSサービスロールが事前に作成する必要がある。

以下の公式ドキュメントを参照してロールを作成する。
https://docs.aws.amazon.com/ja_jp/dms/latest/userguide/CHAP_Security.html#CHAP_Security.APIRole

7.データベース移行タスクの作成

file

file

file

file

file

file

file

file

file

file

file

file

file

file

file

file

file

8.移行を実行

file

file

file

file

9.移行結果の確認

移行タスク
file

file

ログ
file

timestamp,message
1673372113000,"2023-01-10T17:35:13 [AT_GLOBAL       ]I:  Task Server Log - kobayashi-dms-task1  (V3.4.7.R709 ip-172-23-0-217 Linux 4.14.301-224.520.amzn2.x86_64 #1 SMP Fri Dec 9 09:57:03 UTC 2022 x86_64 64-bit, PID: 23451) started at Tue Jan 10 17:35:13 2023  (at_logger.c:3021)"
1673372113000,2023-01-10T17:35:13 [DATA_STRUCTURE  ]I:  SQLite version is 3.31.1  (at_sqlite.c:174)
1673372113000,2023-01-10T17:35:13 [VALIDATOR       ]I:  validation_util_class_initialize  (validation_util.c:71)
1673372113000,2023-01-10T17:35:13 [VALIDATOR       ]I:  Creating Table Def Mutex  (validation_util.c:75)
1673372113000,2023-01-10T17:35:13 [VALIDATOR       ]I:  ==> Success Creating Table Def Mutex  (validation_util.c:83)
1673372113000,2023-01-10T17:35:13 [COMMON          ]D:  at_common_is_supported: load_common_wrapper( common_load_locker ) failed  (at_common.c:69)
1673372114000,2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Execute Request Task 'kobayashi-dms-task1' running full load only with flags fresh start with cdcPosition null and stop_at null  (replicationtask.c:766)
1673372114000,"2023-01-10T17:35:14 [TASK_MANAGER    ]I:  BatchApplyPreserveTransaction is set to false, because BatchApplyEnabled is false  (replicationtask.c:1114)"
1673372114000,2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Task 'kobayashi-dms-task1' starting full load only in fresh start mode  (replicationtask.c:1325)
1673372114000,2023-01-10T17:35:14 [VALIDATOR       ]I:  Latest supported feature version is : 1  (task_features.c:107)
1673372114000,2023-01-10T17:35:14 [VALIDATOR       ]I:  Initialized cMaxPartitionInflightKeys to : 1000  (partition_update_tracker.c:245)
1673372114000,2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Task Id: d8f582eb-4eb8-426c-9daf-69c686bb26da  (replicationtask.c:3348)
1673372114000,2023-01-10T17:35:14 [TASK_MANAGER    ]I:  LOB support on the task has been enabled  (endpointshell.c:1816)
1673372114000,2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Task is running in Limited LOB Mode. MaxLobSize is set to '32768' Bytes  (endpointshell.c:1819)
1673372114000,2023-01-10T17:35:14 [METADATA_MANAGE ]I:  Truncate trailing binary zeros in char columns  (oracle_endpoint_imp.c:731)
1673372114000,2023-01-10T17:35:14 [METADATA_MANAGE ]I:  Trim spaces in n/char columns  (oracle_endpoint_imp.c:753)
1673372114000,2023-01-10T17:35:14 [METADATA_MANAGE ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1362)
1673372114000,2023-01-10T17:35:14 [METADATA_MANAGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372114000,2023-01-10T17:35:14 [METADATA_MANAGE ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372114000,2023-01-10T17:35:14 [METADATA_MANAGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372114000,2023-01-10T17:35:14 [METADATA_MANAGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372114000,2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Preparing all components  (replicationtask.c:1960)
1673372114000,"2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Task - kobayashi-dms-task1 is in STARTING state, updating starting status to AR_PREPARING_COMPONENTS  (repository.c:5110)"
1673372114000,2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Creating threads for all components  (replicationtask.c:1993)
1673372114000,"2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Task - kobayashi-dms-task1 is in STARTING state, updating starting status to AR_CREATING_TREADS  (repository.c:5110)"
1673372114000,"2023-01-10T17:35:14 [TASK_MANAGER    ]I:  Task - kobayashi-dms-task1 is in STARTING state, updating starting status to AR_CREATING_TABLES_LIST  (repository.c:5110)"
1673372114000,2023-01-10T17:35:14 [TABLES_MANAGER  ]I:  Calling for get capture table list from the Metadata Manager started.  (tasktablesmanager.c:934)
1673372114000,2023-01-10T17:35:14 [METADATA_MANAGE ]I:  OCI_ATTR_RECEIVE_TIMEOUT temporary set to 1800000 millisecs (~30 mins)  (oracle_endpoint_lists.c:1022)
1673372115000,2023-01-10T17:35:15 [TABLES_MANAGER  ]I:  Calling for get capture table list from the Metadata Manager ended.  (tasktablesmanager.c:941)
1673372115000,"2023-01-10T17:35:15 [TASK_MANAGER    ]I:  Task - kobayashi-dms-task1 is in RUNNING state, updating starting status to AR_RUNNING  (repository.c:5110)"
1673372115000,2023-01-10T17:35:15 [TASK_MANAGER    ]I:  All stream components were initialized  (replicationtask.c:3098)
1673372115000,2023-01-10T17:35:15 [TASK_MANAGER    ]I:  Starting the validation process...  (replicationtask.c:3180)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_TARGE ]I:  Oracle target database version is 19.0.0.0.0  (oracle_endpoint_conn.c:358)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_TARGE ]I:  Oracle Client version: 12.2.0.1.0  (oracle_endpoint_conn.c:368)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  No validation prepare target endpoint step found for target endpoint.  Continuing with validation as normal.  (task_validator.c:454)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Created thread for component task_validator  (task_validator.c:205)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Validation Manager notified full load only: 1  (validation_manager.c:462)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Set Full Load Single Pass Mode to : 1  (partition_update_tracker.c:1014)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Set cMaxPartitionInflightKeys to : 2147483647  (partition_update_tracker.c:1019)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Set cTableFailureMaxCount to : 2147483647  (partition_update_tracker.c:1021)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Validation is in Single Pass mode. Set iFailureThreshold and iTableFailureThreshold to : 2147483647  (partition_validator.c:391)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [TASK_MANAGER    ]I:  Starting subtask #1  (replicationtask_util.c:521)
1673372115000,2023-01-10T17:35:15 [TASK_MANAGER    ]I:  Threads for all components were created  (replicationtask.c:2180)
1673372115000,2023-01-10T17:35:15 [TASK_MANAGER    ]I:  Task initialization completed successfully  (replicationtask.c:3405)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR       ]I:  Creating the thread of 'validation_result_fetcher' component  (validation_result.c:192)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372115000,2023-01-10T17:35:15 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372116000,2023-01-10T17:35:16 [SOURCE_UNLOAD   ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372116000,2023-01-10T17:35:16 [TARGET_LOAD     ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [TARGET_LOAD     ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372116000,2023-01-10T17:35:16 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372116000,2023-01-10T17:35:16 [SOURCE_CAPTURE  ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372117000,2023-01-10T17:35:17 [SOURCE_CAPTURE  ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372117000,2023-01-10T17:35:17 [TASK_MANAGER    ]I:  Starting component st_1_kobayashi-oracle19c  (subtask.c:1399)
1673372117000,2023-01-10T17:35:17 [TASK_MANAGER    ]I:  Starting subtask #2  (replicationtask_util.c:521)
1673372117000,2023-01-10T17:35:17 [TASK_MANAGER    ]I:  Starting component st_1_ME6OTH7SENIGB23K3M343IFL5O5HPNUAYSTJGJY  (subtask.c:1399)
1673372117000,2023-01-10T17:35:17 [TASK_MANAGER    ]I:  Starting subtask #3  (replicationtask_util.c:521)
1673372117000,2023-01-10T17:35:17 [TASK_MANAGER    ]I:  Starting subtask #4  (replicationtask_util.c:521)
1673372117000,"2023-01-10T17:35:17 [TABLES_MANAGER  ]I:  Next table to load 'APEX_040200'.'WWV_FLOW_DUAL100' ID = 1, order = 0  (tasktablesmanager.c:1838)"
1673372117000,2023-01-10T17:35:17 [TASK_MANAGER    ]I:  Start loading table 'APEX_040200'.'WWV_FLOW_DUAL100' (Id = 1) by subtask 1. Start load timestamp 0005F1EC4E9E6BF2  (replicationtask_util.c:746)
1673372117000,2023-01-10T17:35:17 [TARGET_LOAD     ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372117000,2023-01-10T17:35:17 [TARGET_LOAD     ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372117000,2023-01-10T17:35:17 [SOURCE_UNLOAD   ]I:  Unload finished for table 'APEX_040200'.'WWV_FLOW_DUAL100' (Id = 1). 100 rows sent.  (streamcomponent.c:3543)
1673372118000,2023-01-10T17:35:18 [SOURCE_CAPTURE  ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372119000,2023-01-10T17:35:19 [SOURCE_CAPTURE  ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372121000,2023-01-10T17:35:21 [TARGET_LOAD     ]I:  Load finished for table 'APEX_040200'.'WWV_FLOW_DUAL100' (Id = 1). 100 rows received. 0 rows skipped. Volume transferred 37600.  (streamcomponent.c:3838)
1673372122000,2023-01-10T17:35:22 [SOURCE_UNLOAD   ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372122000,2023-01-10T17:35:22 [PERFORMANCE     ]I:  End load handler time for DMSUSER2.WWV_FLOW_DUAL100 = 1030273 microseconds  (endpointshell.c:2856)
1673372122000,2023-01-10T17:35:22 [PERFORMANCE     ]I:  Total load time for DMSUSER2.WWV_FLOW_DUAL100 = 1145527 microseconds  (endpointshell.c:2858)
1673372122000,2023-01-10T17:35:22 [TASK_MANAGER    ]I:  Loading finished for table 'APEX_040200'.'WWV_FLOW_DUAL100' (Id = 1) by subtask 1. 100 records transferred. Time taken: 45121 micro seconds  (replicationtask.c:2447)
1673372122000,"2023-01-10T17:35:22 [TABLES_MANAGER  ]I:  Next table to load 'DMSUSER'.'DMSTABLE1' ID = 2, order = 0  (tasktablesmanager.c:1838)"
1673372122000,2023-01-10T17:35:22 [TASK_MANAGER    ]I:  Start loading table 'DMSUSER'.'DMSTABLE1' (Id = 2) by subtask 1. Start load timestamp 0005F1EC4EF082DC  (replicationtask_util.c:746)
1673372123000,2023-01-10T17:35:23 [TASK_MANAGER    ]I:  Starting component st_2_ME6OTH7SENIGB23K3M343IFL5O5HPNUAYSTJGJY  (subtask.c:1399)
1673372123000,2023-01-10T17:35:23 [TASK_MANAGER    ]I:  Starting component st_2_kobayashi-oracle19c  (subtask.c:1399)
1673372123000,"2023-01-10T17:35:23 [TABLES_MANAGER  ]I:  Next table to load 'DMSUSER'.'DMSTABLE2' ID = 3, order = 0  (tasktablesmanager.c:1838)"
1673372123000,2023-01-10T17:35:23 [TASK_MANAGER    ]I:  Start loading table 'DMSUSER'.'DMSTABLE2' (Id = 3) by subtask 2. Start load timestamp 0005F1EC4EFCE8BF  (replicationtask_util.c:746)
1673372123000,2023-01-10T17:35:23 [SOURCE_UNLOAD   ]I:  Unload finished for table 'DMSUSER'.'DMSTABLE1' (Id = 2). 10 rows sent.  (streamcomponent.c:3543)
1673372123000,2023-01-10T17:35:23 [SOURCE_UNLOAD   ]I:  Unload finished for table 'DMSUSER'.'DMSTABLE2' (Id = 3). 10 rows sent.  (streamcomponent.c:3543)
1673372123000,2023-01-10T17:35:23 [TARGET_LOAD     ]I:  Load finished for table 'DMSUSER'.'DMSTABLE2' (Id = 3). 10 rows received. 0 rows skipped. Volume transferred 4000.  (streamcomponent.c:3838)
1673372123000,2023-01-10T17:35:23 [TARGET_LOAD     ]I:  Load finished for table 'DMSUSER'.'DMSTABLE1' (Id = 2). 10 rows received. 0 rows skipped. Volume transferred 4000.  (streamcomponent.c:3838)
1673372124000,2023-01-10T17:35:24 [TARGET_LOAD     ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372125000,2023-01-10T17:35:25 [PERFORMANCE     ]I:  End load handler time for DMSUSER2.DMSTABLE2 = 1001626 microseconds  (endpointshell.c:2856)
1673372125000,2023-01-10T17:35:25 [PERFORMANCE     ]I:  Total load time for DMSUSER2.DMSTABLE2 = 1093830 microseconds  (endpointshell.c:2858)
1673372125000,2023-01-10T17:35:25 [PERFORMANCE     ]I:  End load handler time for DMSUSER2.DMSTABLE1 = 1001504 microseconds  (endpointshell.c:2856)
1673372125000,2023-01-10T17:35:25 [PERFORMANCE     ]I:  Total load time for DMSUSER2.DMSTABLE1 = 1093811 microseconds  (endpointshell.c:2858)
1673372125000,2023-01-10T17:35:25 [TASK_MANAGER    ]I:  Loading finished for table 'DMSUSER'.'DMSTABLE1' (Id = 2) by subtask 1. 10 records transferred. Time taken: 103401 micro seconds  (replicationtask.c:2447)
1673372125000,"2023-01-10T17:35:25 [TABLES_MANAGER  ]I:  Next table to load 'SYSTEM'.'HELP' ID = 4, order = 0  (tasktablesmanager.c:1838)"
1673372125000,2023-01-10T17:35:25 [TASK_MANAGER    ]I:  Start loading table 'SYSTEM'.'HELP' (Id = 4) by subtask 1. Start load timestamp 0005F1EC4F1911DA  (replicationtask_util.c:746)
1673372125000,2023-01-10T17:35:25 [TASK_MANAGER    ]I:  Loading finished for table 'DMSUSER'.'DMSTABLE2' (Id = 3) by subtask 2. 10 records transferred. Time taken: 2308 micro seconds  (replicationtask.c:2447)
1673372125000,2023-01-10T17:35:25 [SOURCE_UNLOAD   ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372125000,2023-01-10T17:35:25 [TARGET_LOAD     ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372125000,2023-01-10T17:35:25 [SOURCE_UNLOAD   ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372125000,2023-01-10T17:35:25 [TARGET_LOAD     ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372125000,2023-01-10T17:35:25 [SOURCE_CAPTURE  ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372125000,2023-01-10T17:35:25 [SOURCE_CAPTURE  ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372125000,2023-01-10T17:35:25 [TASK_MANAGER    ]I:  Subtask #2 ended  (replicationtask_util.c:589)
1673372126000,2023-01-10T17:35:26 [TARGET_LOAD     ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372126000,2023-01-10T17:35:26 [SOURCE_UNLOAD   ]I:  Unload finished for table 'SYSTEM'.'HELP' (Id = 4). 938 rows sent.  (streamcomponent.c:3543)
1673372126000,2023-01-10T17:35:26 [TARGET_LOAD     ]I:  Load finished for table 'SYSTEM'.'HELP' (Id = 4). 938 rows received. 0 rows skipped. Volume transferred 473632.  (streamcomponent.c:3838)
1673372127000,2023-01-10T17:35:27 [PERFORMANCE     ]I:  End load handler time for DMSUSER2.HELP = 388643 microseconds  (endpointshell.c:2856)
1673372127000,2023-01-10T17:35:27 [PERFORMANCE     ]I:  Total load time for DMSUSER2.HELP = 422396 microseconds  (endpointshell.c:2858)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  Loading finished for table 'SYSTEM'.'HELP' (Id = 4) by subtask 1. 938 records transferred. Time taken: 111023 micro seconds  (replicationtask.c:2447)
1673372127000,2023-01-10T17:35:27 [SOURCE_UNLOAD   ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372127000,2023-01-10T17:35:27 [TARGET_LOAD     ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372127000,2023-01-10T17:35:27 [TARGET_LOAD     ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372127000,2023-01-10T17:35:27 [SOURCE_UNLOAD   ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372127000,2023-01-10T17:35:27 [SOURCE_CAPTURE  ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372127000,2023-01-10T17:35:27 [SOURCE_CAPTURE  ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372127000,2023-01-10T17:35:27 [SOURCE_CAPTURE  ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  Subtask #1 ended  (replicationtask_util.c:589)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372127000,2023-01-10T17:35:27 [SOURCE_CAPTURE  ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372127000,2023-01-10T17:35:27 [SOURCE_UNLOAD   ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  Starting component st_3_ME6OTH7SENIGB23K3M343IFL5O5HPNUAYSTJGJY  (subtask.c:1399)
1673372127000,2023-01-10T17:35:27 [SOURCE_UNLOAD   ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  Starting component st_3_kobayashi-oracle19c  (subtask.c:1399)
1673372127000,2023-01-10T17:35:27 [TARGET_LOAD     ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372127000,2023-01-10T17:35:27 [SOURCE_UNLOAD   ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372127000,2023-01-10T17:35:27 [TARGET_LOAD     ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372127000,2023-01-10T17:35:27 [SOURCE_CAPTURE  ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372127000,2023-01-10T17:35:27 [SOURCE_CAPTURE  ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  Subtask #3 ended  (replicationtask_util.c:589)
1673372127000,2023-01-10T17:35:27 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372127000,2023-01-10T17:35:27 [SOURCE_UNLOAD   ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372128000,2023-01-10T17:35:28 [TARGET_LOAD     ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372128000,2023-01-10T17:35:28 [TARGET_LOAD     ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372128000,2023-01-10T17:35:28 [SOURCE_CAPTURE  ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372128000,2023-01-10T17:35:28 [SOURCE_CAPTURE  ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372128000,2023-01-10T17:35:28 [TASK_MANAGER    ]I:  Starting component st_4_kobayashi-oracle19c  (subtask.c:1399)
1673372128000,2023-01-10T17:35:28 [TARGET_LOAD     ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372128000,2023-01-10T17:35:28 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372128000,2023-01-10T17:35:28 [TARGET_LOAD     ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372128000,2023-01-10T17:35:28 [SOURCE_CAPTURE  ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372128000,2023-01-10T17:35:28 [SOURCE_CAPTURE  ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372128000,2023-01-10T17:35:28 [SOURCE_UNLOAD   ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372128000,2023-01-10T17:35:28 [SOURCE_UNLOAD   ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372128000,2023-01-10T17:35:28 [TASK_MANAGER    ]I:  Subtask #4 ended  (replicationtask_util.c:589)
1673372128000,2023-01-10T17:35:28 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372128000,2023-01-10T17:35:28 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372130000,2023-01-10T17:35:30 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372132000,2023-01-10T17:35:32 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372134000,2023-01-10T17:35:34 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372136000,2023-01-10T17:35:36 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372138000,2023-01-10T17:35:38 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372140000,2023-01-10T17:35:40 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372142000,2023-01-10T17:35:42 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372144000,2023-01-10T17:35:44 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372145000,2023-01-10T17:35:45 [VALIDATOR       ]I:  No validation preprocessing step found for target endpoint.  Continuing with validation as normal.  (task_validator.c:398)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372145000,2023-01-10T17:35:45 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372146000,"2023-01-10T17:35:46 [VALIDATOR_EXT   ]I:  No primary/unique key found, skipping the validation for Table : WWV_FLOW_DUAL100  (table_partitioner.c:275)"
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372146000,2023-01-10T17:35:46 [VALIDATOR       ]I:  No validation preprocessing step found for target endpoint.  Continuing with validation as normal.  (task_validator.c:398)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372146000,"2023-01-10T17:35:46 [VALIDATOR_EXT   ]I:  No primary/unique key found, skipping the validation for Table : DMSTABLE1  (table_partitioner.c:275)"
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372146000,2023-01-10T17:35:46 [VALIDATOR       ]I:  No validation preprocessing step found for target endpoint.  Continuing with validation as normal.  (task_validator.c:398)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372146000,"2023-01-10T17:35:46 [VALIDATOR_EXT   ]I:  No primary/unique key found, skipping the validation for Table : DMSTABLE2  (table_partitioner.c:275)"
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372146000,2023-01-10T17:35:46 [VALIDATOR       ]I:  No validation preprocessing step found for target endpoint.  Continuing with validation as normal.  (task_validator.c:398)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Going to connect to Oracle server (DESCRIPTION=(CONNECT_TIMEOUT=8)(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.101.198)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sourcedb))) with username dmsuser  (oracle_endpoint_imp.c:1360)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372146000,2023-01-10T17:35:46 [VALIDATOR_SOURC ]I:  Source endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:623)
1673372147000,2023-01-10T17:35:47 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372147000,2023-01-10T17:35:47 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372147000,2023-01-10T17:35:47 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372147000,2023-01-10T17:35:47 [VALIDATOR_EXT   ]I:  Partitioning the Table : HELP  (table_partitioner.c:302)
1673372147000,"2023-01-10T17:35:47 [VALIDATOR       ]I:  Finished Partitioning the Table : HELP, Created : 1 partitions with time : 14892 micros  (table_partitioner.c:312)"
1673372147000,2023-01-10T17:35:47 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372147000,2023-01-10T17:35:47 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372147000,2023-01-10T17:35:47 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372147000,2023-01-10T17:35:47 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372148000,2023-01-10T17:35:48 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372150000,2023-01-10T17:35:50 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372152000,2023-01-10T17:35:52 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372154000,2023-01-10T17:35:54 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372156000,2023-01-10T17:35:56 [TASK_MANAGER    ]I:  All tables are loaded. waiting for validation to finish...  (replicationtask.c:3779)
1673372158000,2023-01-10T17:35:58 [TASK_MANAGER    ]I:  All tables are loaded. Full load only task is stopped  (replicationtask.c:3773)
1673372164000,"2023-01-10T17:36:04 [TASK_MANAGER    ]I:  Task - kobayashi-dms-task1 is in STOPPED state, updating starting status to AR_NOT_APPLICABLE  (repository.c:5102)"
1673372164000,"2023-01-10T17:36:04 [TASK_MANAGER    ]I:  Updated Task, kobayashi-dms-task1, info with TaskState - 0  (replicationtask.c:3936)"
1673372164000,2023-01-10T17:36:04 [VALIDATOR       ]I:  Wait for termination of the thread of 'task_validator' component  (task_validator.c:217)
1673372164000,2023-01-10T17:36:04 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372164000,2023-01-10T17:36:04 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372164000,2023-01-10T17:36:04 [VALIDATOR       ]I:  finished partition reporting run for thread: 5  (partition_validator.c:467)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of 5 partition validator threads  (partition_validator.c:256)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Wait for termination of the thread of 'validation_result_fetcher' component  (validation_result.c:231)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'validation_result_fetcher' component terminated  (validation_result.c:236)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_SOURC ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  All partition validator threads are terminated  (partition_validator.c:272)
1673372165000,"2023-01-10T17:36:05 [VALIDATOR       ]I:  Stopped partition validators, exiting task validator thread  (task_validator.c:304)"
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  Thread of 'task_validator' component terminated  (task_validator.c:223)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Connecting to Oracle: Beginning session  (oracle_endpoint_conn.c:946)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Target endpoint 'Oracle' is using provider syntax 'Oracle'  (provider_syntax_manager.c:629)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Working in transactional apply mode  (endpointshell.c:1973)
1673372165000,2023-01-10T17:36:05 [VALIDATOR       ]I:  No validation cleanup target endpoint step found for target endpoint.  Continuing with cleanup as normal.  (task_validator.c:496)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372165000,2023-01-10T17:36:05 [VALIDATOR_TARGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372165000,2023-01-10T17:36:05 [TASK_MANAGER    ]I:  Task management thread terminated  (replicationtask.c:3959)
1673372168000,2023-01-10T17:36:08 [METADATA_MANAGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372168000,2023-01-10T17:36:08 [METADATA_MANAGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372168000,2023-01-10T17:36:08 [METADATA_MANAGE ]I:  Disconnecting Oracle database  (oracle_endpoint_conn.c:1473)
1673372168000,2023-01-10T17:36:08 [METADATA_MANAGE ]I:  Disconnected Oracle database  (oracle_endpoint_conn.c:1508)
1673372168000,2023-01-10T17:36:08 [AT_GLOBAL       ]I:  Closing log file at Tue Jan 10 17:36:08 2023  (at_logger.c:2766)

移行後テーブル一覧

file

移行後テーブルのレコード確認
file

まとめ

今回、DMSでOracle SE2 12c（EC2）からOracle SE2 19c（RDS）を紹介しました。オンプレミス環境からRDSへ移行する場合参考になると思います。

以上です。
少しでもお役に立てれば幸いです。

参考

https://docs.aws.amazon.com/ja_jp/dms/latest/userguide/CHAP_Source.Oracle.html#CHAP_Source.Oracle.Limitations

Last modified: 2023-01-11

Author