Source RAC3 HOST / db ora_pmon_SRC / 19c DB & GG /SCHEMA HR / load1
Target RAC 4 HOST/ db ora_pmon_TRGT/ 19c DB & GG / SCHEMA HR /load2
You can use Oracle GoldenGate to:
1.Perform a standalone batch load to populate database tables for migration or other purposes.
2.Load data into database tables as part of an initial synchronisation run in preparation for change synchronisation with Oracle GoldenGate.
Prerequisites for Initial Load
Disable DDL Processing
Before executing an initial load, disable DDL extraction and replication. DDL processing is controlled by the DDL parameter in the Extract and Replicat parameter files.
Prepare the Target Tables
The following are suggestions that can make the load go faster and help you to avoid errors.
Data: Make certain that the target tables are empty. Otherwise, there may be duplicate-row errors or conflicts between existing rows and rows that are being loaded.
Constraints: Disable foreign-key constraints and check constraints. Foreign-key constraints can cause errors, and check constraints can slow down the loading process. Constraints can be reactivated after the load concludes successfully.
Indexes: Remove indexes from the target tables. Indexes are not necessary for inserts. They will slow down the loading process significantly. For each row that is inserted into a table, the database will update every index on that table. You can add back the indexes after the load is finished.
Keys: For Oracle GoldenGate to reconcile the replicated incremental data changes with the results of the load, each target table must have a primary or unique key. If you cannot create a key through your application, use the KEYCOLS option of the TABLE and MAP parameters to specify columns as a substitute key for Oracle GoldenGate's purposes. A key helps identify which row to process. If you cannot create keys, the source database must be quiesced for the load.
Source :-
GGSCI (rac3.dbexpert.com) 1> view param load1
EXTRACT load1
USERID hr, PASSWORD hr
RMTHOST rac4, MGRPORT 7809
RMTTASK replicat, GROUP load2
TABLE HR.*;
Target :-
GGSCI (rac4.dbexpert.com) 1> view param load2
REPLICAT load2
USERID hr, PASSWORD hr
ASSUMETARGETDEFS
MAP HR.*,target HR.*;
=================================================================
execute init load from OS level insted ggsci prompt ...
Source :-
[oracle@rac3 gg]$ ./extract paramfile dirprm/load1.prm reportfile dirrpt/load1.rpt
=================================================================
Source Log :-
[oracle@rac3 gg]$ tail -100f dirrpt/load1.rpt
2022-04-07 22:29:04 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2022-04-07 22:29:04 INFO OGG-01360 EXTRACT is running in Initial Load mode.
2022-04-07 22:29:04 INFO OGG-01889 Flush size (max message size) is set to 27,985.
EXTRACT load1
USERID hr, PASSWORD ***
RMTHOST rac4, MGRPORT 7809
RMTTASK replicat, GROUP load2
TABLE HR.*;
2022-04-07 22:29:04 INFO OGG-01851 filecaching started: thread ID: 140075611510528.
2022-04-07 22:29:04 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u002/app/goldengate/19.1.0/gg/dirtmp.
2022-04-07 22:29:04 INFO OGG-25340
Database Version:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
2022-04-07 22:29:04 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8".
2022-04-07 22:29:04 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."COUNTRIES".
2022-04-07 22:29:04 INFO OGG-06509 Using the following key columns for source table HR.COUNTRIES: COUNTRY_ID.
2022-04-07 22:29:04 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."DEPARTMENTS".
2022-04-07 22:29:04 INFO OGG-06509 Using the following key columns for source table HR.DEPARTMENTS: DEPARTMENT_ID.
2022-04-07 22:29:04 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."EMPLOYEES".
2022-04-07 22:29:04 INFO OGG-06509 Using the following key columns for source table HR.EMPLOYEES: EMPLOYEE_ID.
2022-04-07 22:29:04 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."EMP_DETAILS_VIEW".
2022-04-07 22:29:04 WARNING OGG-06439 No unique key is defined for table EMP_DETAILS_VIEW. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2022-04-07 22:29:04 INFO OGG-06509 Using the following key columns for source table HR.EMP_DETAILS_VIEW: EMPLOYEE_ID, JOB_ID, MANAGER_ID, DEPARTMENT_ID, LOCATION_ID, COUNTRY_ID, FIRST_NAME, LAST_NAME, SALARY, COMMISSION_PCT, DEPARTMENT_NAME, JOB_TITLE, CITY, STATE_PROVINCE, COUNTRY_NAME, REGION_NAME.
2022-04-07 22:29:04 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."JOBS".
2022-04-07 22:29:04 INFO OGG-06509 Using the following key columns for source table HR.JOBS: JOB_ID.
2022-04-07 22:29:04 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."JOB_HISTORY".
2022-04-07 22:29:04 INFO OGG-06509 Using the following key columns for source table HR.JOB_HISTORY: EMPLOYEE_ID, START_DATE.
2022-04-07 22:29:04 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."LOCATIONS".
2022-04-07 22:29:04 INFO OGG-06509 Using the following key columns for source table HR.LOCATIONS: LOCATION_ID.
2022-04-07 22:29:04 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."REGIONS".
2022-04-07 22:29:04 INFO OGG-06509 Using the following key columns for source table HR.REGIONS: REGION_ID.
2022-04-07 22:29:10 INFO OGG-02911 Processing table HR.COUNTRIES.
2022-04-07 22:29:10 INFO OGG-02911 Processing table HR.DEPARTMENTS.
2022-04-07 22:29:10 INFO OGG-02911 Processing table HR.EMPLOYEES.
2022-04-07 22:29:10 INFO OGG-02911 Processing table HR.EMP_DETAILS_VIEW.
2022-04-07 22:29:11 WARNING OGG-01194 EXTRACT task load2 abended : Initial data load error reported by REPLICAT.
Source Context :
SourceModule : [er.idlx]
SourceID : [er/idlx.c]
SourceMethod : [IDLX_complete_tcp_msg]
SourceLine : [434]
ThreadBacktrace : [17] elements
: [/u002/app/goldengate/19.1.0/gg/libgglog.so(CMessageContext::AddThreadContext())]
: [/u002/app/goldengate/19.1.0/gg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u002/app/goldengate/19.1.0/gg/libgglog.so(_MSG_(CSourceContext*, int, CMessageFactory::MessageDisposition))]
: [./extract(IDLX_complete_tcp_msg)]
: [./extract(ggs::gglib::ggtrail::LegacyTrailDataTarget::complete_tcp_msg(extract_def*))]
: [./extract(ggs::gglib::ggtrail::LegacyTrailDataTarget::flush_tcp(extract_def*, bool))]
: [./extract(IDLX_send_table_end_cmd)]
: [./extract(ggs::er::DatabaseDataSource::processSourceTables())]
: [./extract(ggs::er::OraDatabaseDataSource::processSourceTables())]
: [./extract()]
: [./extract()]
: [./extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [./extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [./extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [./extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [./extract()]
2022-04-07 22:29:11 ERROR OGG-01203 EXTRACT abending.
2022-04-07 22:29:11 ERROR OGG-01668 PROCESS ABENDING.
tail: dirrpt/load1.rpt: file truncated
2022-04-07 22:33:57 INFO OGG-01017 Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.1.0.0.2 OGGCORE_19.1.0.0.0_PLATFORMS_190823.0013_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Aug 23 2019 13:52:50
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
Starting at 2022-04-07 22:33:57
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Mon Mar 12 23:57:12 PDT 2018, Release 4.1.12-112.16.4.el7uek.x86_64
Node: rac3.databasexpert.com
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 17922
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2022-04-07 22:33:57 INFO OGG-03059 Operating system character set identified as UTF-8.
2022-04-07 22:33:57 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2022-04-07 22:33:57 INFO OGG-01360 EXTRACT is running in Initial Load mode.
2022-04-07 22:33:57 INFO OGG-01889 Flush size (max message size) is set to 27,985.
EXTRACT load1
USERID hr, PASSWORD ***
RMTHOST rac4, MGRPORT 7809
RMTTASK replicat, GROUP load2
TABLE HR.*;
2022-04-07 22:33:58 INFO OGG-01851 filecaching started: thread ID: 140148306716416.
2022-04-07 22:33:58 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u002/app/goldengate/19.1.0/gg/dirtmp.
2022-04-07 22:33:58 INFO OGG-25340
Database Version:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
2022-04-07 22:33:58 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8".
2022-04-07 22:33:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."COUNTRIES".
2022-04-07 22:33:58 INFO OGG-06509 Using the following key columns for source table HR.COUNTRIES: COUNTRY_ID.
2022-04-07 22:33:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."DEPARTMENTS".
2022-04-07 22:33:58 INFO OGG-06509 Using the following key columns for source table HR.DEPARTMENTS: DEPARTMENT_ID.
2022-04-07 22:33:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."EMPLOYEES".
2022-04-07 22:33:58 INFO OGG-06509 Using the following key columns for source table HR.EMPLOYEES: EMPLOYEE_ID.
2022-04-07 22:33:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."JOBS".
2022-04-07 22:33:58 INFO OGG-06509 Using the following key columns for source table HR.JOBS: JOB_ID.
2022-04-07 22:33:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."JOB_HISTORY".
2022-04-07 22:33:58 INFO OGG-06509 Using the following key columns for source table HR.JOB_HISTORY: EMPLOYEE_ID, START_DATE.
2022-04-07 22:33:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."LOCATIONS".
2022-04-07 22:33:58 INFO OGG-06509 Using the following key columns for source table HR.LOCATIONS: LOCATION_ID.
2022-04-07 22:33:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."REGIONS".
2022-04-07 22:33:58 INFO OGG-06509 Using the following key columns for source table HR.REGIONS: REGION_ID.
2022-04-07 22:34:03 INFO OGG-02911 Processing table HR.COUNTRIES.
2022-04-07 22:34:03 INFO OGG-02911 Processing table HR.DEPARTMENTS.
2022-04-07 22:34:03 INFO OGG-02911 Processing table HR.EMPLOYEES.
2022-04-07 22:34:03 WARNING OGG-01194 EXTRACT task load2 abended : Initial data load error reported by REPLICAT.
Source Context :
SourceModule : [er.idlx]
SourceID : [er/idlx.c]
SourceMethod : [IDLX_complete_tcp_msg]
SourceLine : [434]
ThreadBacktrace : [18] elements
: [/u002/app/goldengate/19.1.0/gg/libgglog.so(CMessageContext::AddThreadContext())]
: [/u002/app/goldengate/19.1.0/gg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u002/app/goldengate/19.1.0/gg/libgglog.so(_MSG_(CSourceContext*, int, CMessageFactory::MessageDisposition))]
: [./extract(IDLX_complete_tcp_msg)]
: [./extract(ggs::gglib::ggtrail::LegacyTrailDataTarget::complete_tcp_msg(extract_def*))]
: [./extract(ggs::gglib::ggtrail::LegacyTrailDataTarget::flush_tcp(extract_def*, bool))]
: [./extract()]
: [./extract(ggs::gglib::ggtrail::LegacyTrailDataTarget::flush(bool))]
: [./extract(ggs::er::DatabaseDataSource::processSourceTables())]
: [./extract(ggs::er::OraDatabaseDataSource::processSourceTables())]
: [./extract()]
: [./extract()]
: [./extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [./extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [./extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [./extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [./extract()]
2022-04-07 22:34:03 ERROR OGG-01203 EXTRACT abending.
2022-04-07 22:34:03 ERROR OGG-01668 PROCESS ABENDING.
tail: dirrpt/load1.rpt: file truncated
2022-04-07 22:36:58 INFO OGG-01017 Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.1.0.0.2 OGGCORE_19.1.0.0.0_PLATFORMS_190823.0013_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Aug 23 2019 13:52:50
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
Starting at 2022-04-07 22:36:58
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Mon Mar 12 23:57:12 PDT 2018, Release 4.1.12-112.16.4.el7uek.x86_64
Node: rac3.databasexpert.com
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 18116
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2022-04-07 22:36:58 INFO OGG-03059 Operating system character set identified as UTF-8.
2022-04-07 22:36:58 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2022-04-07 22:36:58 INFO OGG-01360 EXTRACT is running in Initial Load mode.
2022-04-07 22:36:58 INFO OGG-01889 Flush size (max message size) is set to 27,985.
EXTRACT load1
USERID hr, PASSWORD ***
RMTHOST rac4, MGRPORT 7809
RMTTASK replicat, GROUP load2
TABLE HR.*;
2022-04-07 22:36:58 INFO OGG-01851 filecaching started: thread ID: 140389428127488.
2022-04-07 22:36:58 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u002/app/goldengate/19.1.0/gg/dirtmp.
2022-04-07 22:36:58 INFO OGG-25340
Database Version:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
2022-04-07 22:36:58 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8".
2022-04-07 22:36:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."COUNTRIES".
2022-04-07 22:36:58 INFO OGG-06509 Using the following key columns for source table HR.COUNTRIES: COUNTRY_ID.
2022-04-07 22:36:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."DEPARTMENTS".
2022-04-07 22:36:58 INFO OGG-06509 Using the following key columns for source table HR.DEPARTMENTS: DEPARTMENT_ID.
2022-04-07 22:36:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."EMPLOYEES".
2022-04-07 22:36:58 INFO OGG-06509 Using the following key columns for source table HR.EMPLOYEES: EMPLOYEE_ID.
2022-04-07 22:36:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."JOBS".
2022-04-07 22:36:58 INFO OGG-06509 Using the following key columns for source table HR.JOBS: JOB_ID.
2022-04-07 22:36:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."JOB_HISTORY".
2022-04-07 22:36:58 INFO OGG-06509 Using the following key columns for source table HR.JOB_HISTORY: EMPLOYEE_ID, START_DATE.
2022-04-07 22:36:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."LOCATIONS".
2022-04-07 22:36:58 INFO OGG-06509 Using the following key columns for source table HR.LOCATIONS: LOCATION_ID.
2022-04-07 22:36:58 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry HR.*): TABLE "HR"."REGIONS".
2022-04-07 22:36:58 INFO OGG-06509 Using the following key columns for source table HR.REGIONS: REGION_ID.
2022-04-07 22:37:04 INFO OGG-02911 Processing table HR.COUNTRIES.
2022-04-07 22:37:04 INFO OGG-02911 Processing table HR.DEPARTMENTS.
2022-04-07 22:37:04 INFO OGG-02911 Processing table HR.EMPLOYEES.
2022-04-07 22:37:04 INFO OGG-02911 Processing table HR.JOBS.
2022-04-07 22:37:05 INFO OGG-02911 Processing table HR.JOB_HISTORY.
2022-04-07 22:37:05 INFO OGG-02911 Processing table HR.LOCATIONS.
2022-04-07 22:37:06 INFO OGG-02911 Processing table HR.REGIONS.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2022-04-07 22:37:06 (activity since 2022-04-07 22:36:58)
Output to load2:
From Table HR.COUNTRIES:
# inserts: 26
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.DEPARTMENTS:
# inserts: 27
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.EMPLOYEES:
# inserts: 107
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.JOBS:
# inserts: 19
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.JOB_HISTORY:
# inserts: 10
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.LOCATIONS:
# inserts: 23
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.REGIONS:
# inserts: 4
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
REDO Log Statistics
Bytes parsed 0
Bytes output 40821
====================================================================
Target :-
GGSCI (rac4.databasexpert.com) 2> view report load2
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 19.1.0.0.2 OGGCORE_19.1.0.0.0_PLATFORMS_190823.0013_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Aug 23 2019 13:53:12
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
Starting at 2022-04-09 20:43:47
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Mon Mar 12 23:57:12 PDT 2018, Release 4.1.12-112.16.4.el7uek.x86_64
Node: rac4.databasexpert.com
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 24960
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2022-04-09 20:43:52 INFO OGG-03059 Operating system character set identified as UTF-8.
2022-04-09 20:43:52 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2022-04-09 20:43:52 INFO OGG-01360 REPLICAT is running in Remote Task mode.
REPLICAT load2
USERID hr, PASSWORD ***
ASSUMETARGETDEFS
MAP HR.*,target HR.*;
2022-04-09 20:43:52 INFO OGG-06451 Triggers will be suppressed by default.
2022-04-09 20:43:52 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u002/app/goldengate/19.1.0/gg/dirtmp.
2022-04-09 20:43:52 INFO OGG-25340
Database Version:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
2022-04-09 20:43:52 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8".
2022-04-09 20:43:52 INFO OGG-06604 Database TRGT CPU info: CPU Count 2, CPU Core Count 2, CPU Socket Count 1.
***********************************************************************
** Run Time Messages **
***********************************************************************
2022-04-09 20:43:53 WARNING OGG-02760 ASSUMETARGETDEFS is ignored because trail file contains table definitions.
2022-04-09 20:43:53 INFO OGG-06506 Wildcard MAP resolved (entry HR.*): MAP "HR"."COUNTRIES",target HR."COUNTRIES".
2022-04-09 20:43:53 WARNING OGG-06439 No unique key is defined for table COUNTRIES. All viable columns will be used to represent the key, but may not guara
ntee uniqueness. KEYCOLS may be used to define the key.
2022-04-09 20:43:53 INFO OGG-02756 The definition for table HR.COUNTRIES is obtained from the trail file.
2022-04-09 20:43:53 INFO OGG-06511 Using following columns in default map by name: COUNTRY_ID, COUNTRY_NAME, REGION_ID.
2022-04-09 20:43:53 INFO OGG-06510 Using the following key columns for target table HR.COUNTRIES: COUNTRY_ID, COUNTRY_NAME, REGION_ID.
2022-04-09 20:43:53 INFO OGG-06506 Wildcard MAP resolved (entry HR.*): MAP "HR"."DEPARTMENTS",target HR."DEPARTMENTS".
2022-04-09 20:43:53 WARNING OGG-06439 No unique key is defined for table DEPARTMENTS. All viable columns will be used to represent the key, but may not gua
rantee uniqueness. KEYCOLS may be used to define the key.
2022-04-09 20:43:53 INFO OGG-02756 The definition for table HR.DEPARTMENTS is obtained from the trail file.
2022-04-09 20:43:53 INFO OGG-06511 Using following columns in default map by name: DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID.
2022-04-09 20:43:53 INFO OGG-06510 Using the following key columns for target table HR.DEPARTMENTS: DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION
_ID.
2022-04-09 20:43:53 INFO OGG-06506 Wildcard MAP resolved (entry HR.*): MAP "HR"."EMPLOYEES",target HR."EMPLOYEES".
2022-04-09 20:43:53 INFO OGG-06441 Unique key EMP_EMP_ID_PK for table EMPLOYEES cannot be used due to the inclusion of virtual columns, or user-defined
datatypes, or extended long varchar columns, or function-based index columns.
2022-04-09 20:43:53 INFO OGG-02756 The definition for table HR.EMPLOYEES is obtained from the trail file.
2022-04-09 20:43:53 INFO OGG-06511 Using following columns in default map by name: EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, J
OB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID.
2022-04-09 20:43:53 INFO OGG-06510 Using the following key columns for target table HR.EMPLOYEES: EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBE
R, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID.
2022-04-09 20:43:53 INFO OGG-06506 Wildcard MAP resolved (entry HR.*): MAP "HR"."JOBS",target HR."JOBS".
2022-04-09 20:43:53 INFO OGG-06441 Unique key JOB_ID_PK for table JOBS cannot be used due to the inclusion of virtual columns, or user-defined datatypes
, or extended long varchar columns, or function-based index columns.
2022-04-09 20:43:53 INFO OGG-02756 The definition for table HR.JOBS is obtained from the trail file.
2022-04-09 20:43:53 INFO OGG-06511 Using following columns in default map by name: JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY.
2022-04-09 20:43:53 INFO OGG-06510 Using the following key columns for target table HR.JOBS: JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY.
2022-04-09 20:43:53 INFO OGG-06506 Wildcard MAP resolved (entry HR.*): MAP "HR"."JOB_HISTORY",target HR."JOB_HISTORY".
2022-04-09 20:43:54 INFO OGG-06441 Unique key JHIST_EMP_ID_ST_DATE_PK for table JOB_HISTORY cannot be used due to the inclusion of virtual columns, or u
ser-defined datatypes, or extended long varchar columns, or function-based index columns.
2022-04-09 20:43:54 INFO OGG-02756 The definition for table HR.JOB_HISTORY is obtained from the trail file.
2022-04-09 20:43:54 INFO OGG-06511 Using following columns in default map by name: EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID.
2022-04-09 20:43:54 INFO OGG-06510 Using the following key columns for target table HR.JOB_HISTORY: EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMEN
T_ID.
2022-04-09 20:43:54 INFO OGG-06506 Wildcard MAP resolved (entry HR.*): MAP "HR"."LOCATIONS",target HR."LOCATIONS".
2022-04-09 20:43:54 INFO OGG-06441 Unique key LOC_ID_PK for table LOCATIONS cannot be used due to the inclusion of virtual columns, or user-defined data
types, or extended long varchar columns, or function-based index columns.
2022-04-09 20:43:54 INFO OGG-02756 The definition for table HR.LOCATIONS is obtained from the trail file.
2022-04-09 20:43:54 INFO OGG-06511 Using following columns in default map by name: LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE, COUNT
RY_ID.
2022-04-09 20:43:54 INFO OGG-06510 Using the following key columns for target table HR.LOCATIONS: LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_
PROVINCE, COUNTRY_ID.
2022-04-09 20:43:54 INFO OGG-06506 Wildcard MAP resolved (entry HR.*): MAP "HR"."REGIONS",target HR."REGIONS".
2022-04-09 20:43:55 INFO OGG-06441 Unique key REG_ID_PK for table REGIONS cannot be used due to the inclusion of virtual columns, or user-defined dataty
pes, or extended long varchar columns, or function-based index columns.
2022-04-09 20:43:55 INFO OGG-02756 The definition for table HR.REGIONS is obtained from the trail file.
2022-04-09 20:43:55 INFO OGG-06511 Using following columns in default map by name: REGION_ID, REGION_NAME.
2022-04-09 20:43:55 INFO OGG-06510 Using the following key columns for target table HR.REGIONS: REGION_ID, REGION_NAME.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2022-04-09 20:44:00 (activity since 2022-04-09 20:43:53)
From Table HR.COUNTRIES to HR.COUNTRIES:
# inserts: 26
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.DEPARTMENTS to HR.DEPARTMENTS:
# inserts: 27
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.EMPLOYEES to HR.EMPLOYEES:
# inserts: 107
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.JOBS to HR.JOBS:
# inserts: 19
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.JOB_HISTORY to HR.JOB_HISTORY:
# inserts: 10
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.LOCATIONS to HR.LOCATIONS:
# inserts: 23
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
From Table HR.REGIONS to HR.REGIONS:
# inserts: 4
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAGE
vm current = 0 vm anon queues = 0
vm anon in use = 0 vm file = 0
vm used max = 0 cachesize = 16G
CACHE CONFIGURATION
cache size = 16G cache force paging = 24G
pageout eligible size = 8M cache vm pageout max = 64M
================================================================================
RUNTIME STATS FOR SUPERPOOL
Note: CACHE objects are often but not always proxies for transactions
CACHE Object Stats
objects active = 0 max concurrent = 0
non-zero total = 0 objects total = 0
CACHE File Caching
filecache rqsts = 0 bytes to disk = 0
file retrieves = 0 objs filecached = 0
queue entries = 0 queue processed = 0
queue entry not needed = 0 queue not signaled = 0
fc requesting obj = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0
Note: For statistics tables below each specification represents a power of
two bucket.
For example: '|4K: 1234 |8K:' represents 1234 items between 4K and 8K-1
Allocation Request Distribution
< 128B: 0
128B: 0 | 256B: 0 | 512B: 0 | 1K: 0
2K: 0 | 4K: 0 | 8K: 0 | 16K: 0
32K: 0 | 64K: 0 | 128K: 0 | 256K: 0
512K: 0 | 1M: 0 | 2M: 0 | 4M: 0
8M: 0 | 16M: 0 | 32M: 0 | 64M: 0
128M: 0 | 256M: 0 | 512M: 0 | 1G: 0
2G: 0
Cached Object Size Distribution
0: 0
< 4K: 0
4K: 0 | 8K: 0 | 16K: 0 | 32K: 0
64K: 0 | 128K: 0 | 256K: 0 | 512K: 0
1M: 0 | 2M: 0 | 4M: 0 | 8M: 0
16M: 0 | 32M: 0 | 64M: 0 | 128M: 0
256M: 0 | 512M: 0 | 1G: 0 | 2G: 0
4G: 0 | 8G: 0 | 16G: 0 | 32G: 0
64G: 0 | 128G: 0 | 256G: 0 | 512G: 0
1T: 0 | 2T: 0 | 4T: 0 | 8T: 0
16T: 0 | 32T: 0 | 64T: 0 | 128T: 0
256T: 0 | 512T: 0 | 1P: 0 | 2P: 0
================================================================================
CUMULATIVE STATS FOR SUPERPOOL (PREVIOUS RUNS ONLY)
Note: CACHE objects are often but not always proxies for transactions
CACHE Object Stats
objects active = 0 max concurrent = 0
non-zero total = 0 objects total = 0
CACHE File Caching
filecache rqsts = 0 bytes to disk = 0
file retrieves = 0 objs filecached = 0
queue entries = 0 queue processed = 0
queue entry not needed = 0 queue not signaled = 0
fc requesting obj = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 | 256B: 0 | 512B: 0 | 1K: 0
2K: 0 | 4K: 0 | 8K: 0 | 16K: 0
32K: 0 | 64K: 0 | 128K: 0 | 256K: 0
512K: 0 | 1M: 0 | 2M: 0 | 4M: 0
8M: 0 | 16M: 0 | 32M: 0 | 64M: 0
128M: 0 | 256M: 0 | 512M: 0 | 1G: 0
2G: 0
Cached Object Size Distribution
0: 0
< 4K: 0
4K: 0 | 8K: 0 | 16K: 0 | 32K: 0
64K: 0 | 128K: 0 | 256K: 0 | 512K: 0
1M: 0 | 2M: 0 | 4M: 0 | 8M: 0
16M: 0 | 32M: 0 | 64M: 0 | 128M: 0
256M: 0 | 512M: 0 | 1G: 0 | 2G: 0
4G: 0 | 8G: 0 | 16G: 0 | 32G: 0
64G: 0 | 128G: 0 | 256G: 0 | 512G: 0
1T: 0 | 2T: 0 | 4T: 0 | 8T: 0
16T: 0 | 32T: 0 | 64T: 0 | 128T: 0
256T: 0 | 512T: 0 | 1P: 0 | 2P: 0
QUEUE Statistics
num queues = 13 q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
11 128M 0 0 0 0
12 256M 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: load2 id: p24960_BLOB instance: 0 tid: (nil)
objects active = 0 objects concurrent (max) = 0
objects total = 0 (0 )
flag = 0x000000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 | 256B: 0 | 512B: 0 | 1K: 0
2K: 0 | 4K: 0 | 8K: 0 | 16K: 0
32K: 0 | 64K: 0 | 128K: 0 | 256K: 0
512K: 0 | 1M: 0 | 2M: 0 | 4M: 0
8M: 0 | 16M: 0 | 32M: 0 | 64M: 0
128M: 0 | 256M: 0 | 512M: 0 | 1G: 0
2G: 0
================================================================================
CUMULATIVE STATS FOR CACHE POOL #0 (PREVIOUS RUNS ONLY)
POOL INFO group: load2 id: p24960_BLOB instance: 0 tid: (nil)
objects active = 0 objects concurrent (max) = 0
objects total = 0 (0 )
flag = 0x000000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 | 256B: 0 | 512B: 0 | 1K: 0
2K: 0 | 4K: 0 | 8K: 0 | 16K: 0
32K: 0 | 64K: 0 | 128K: 0 | 256K: 0
512K: 0 | 1M: 0 | 2M: 0 | 4M: 0
8M: 0 | 16M: 0 | 32M: 0 | 64M: 0
128M: 0 | 256M: 0 | 512M: 0 | 1G: 0
2G: 0
Comments
Post a Comment