この記事は公開されてから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 (ターゲットデータベースへの接続定義)
で構成されます。
https://docs.aws.amazon.com/ja_jp/dms/latest/userguide/Welcome.html より抜粋
今回検証用の構成図
構築手順
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-DMS2.サブネットグループの作成
3.レプリケーションインスタンスの作成
4.ソースエンドポイントの作成
5.ターゲットエンドポイントの作成
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」という名前のポリシーを作成する。
DMSサービスからCloudWatchLogsにアクセスするための「AmazonDMSCloudWatchLogsRole」ポリシーにアタッチしている「dms-cloudwatch-logs-role」という名前のDMSサービスロールが事前に作成する必要がある。
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.データベース移行タスクの作成
8.移行を実行
9.移行結果の確認
移行タスク
ログ
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)移行後テーブル一覧
移行後テーブルのレコード確認
まとめ
今回、DMSでOracle SE2 12c（EC2）からOracle SE2 19c（RDS）を紹介しました。オンプレミス環境からRDSへ移行する場合参考になると思います。
以上です。
少しでもお役に立てれば幸いです。