Setup
Environment details
1. Prerequisite
Follow this document to prepare srcdb, tgtdb and mngdb databases.
2. Configure source db – srcdb
a. Enable force logging and supplemental logging
SQL> select name from v$database;
NAME
---------
SRCDB
SQL> SELECT log_mode FROM v$database;
LOG_MODE
------------
ARCHIVELOG
SQL> SELECT force_logging, supplemental_log_data_min FROM v$database;
FOR SUPPLEME
--- --------
NO NO
SQL> SELECT force_logging, supplemental_log_data_min FROM v$database;
FOR SUPPLEME
--- --------
NO NO
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> ALTER DATABASE FORCE LOGGING;
Database altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> SELECT force_logging, supplemental_log_data_min FROM v$database;
FOR SUPPLEME
--- --------
YES YES
b. Overwrite the Oracle RDBMS password file to enable case insensitivity on source
[oracle@oel6-node03 ~]$ cd ${ORACLE_HOME}/dbs
[oracle@oel6-node03 dbs]$ ls -ltr orapw*
-rw-r-----. 1 oracle oinstall 1536 May 12 09:34 orapwDBUA3433408
-rw-r-----. 1 oracle oinstall 1536 May 18 12:00 orapwsrcdb
[oracle@oel6-node03 dbs]$ orapwd file=orapwsrcdb password=oracle ignorecase=Y entries=30 force=Y
[oracle@oel6-node03 dbs]$ ls -ltr orapw*
-rw-r-----. 1 oracle oinstall 1536 May 12 09:34 orapwDBUA3433408
-rw-r-----. 1 oracle oinstall 5120 May 18 12:47 orapwsrcdb
c. Create users and tablespace -srcdb
SQL> select name from v$database;
NAME
---------
SRCDB
SQL> create tablespace oggdata datafile '/u01/app/oracle/oradata/srcdb/oggdata01.dbf' size 100M extent management local uniform size 256k;
Tablespace created.
SQL> CREATE USER oggadm IDENTIFIED BY Welcome1 default tablespace oggdata;
User created.
SQL> GRANT dba TO oggadm;
Grant succeeded.
SQL> CREATE USER oggsrc IDENTIFIED BY Welcome1 default tablespace oggdata;
User created.
SQL> GRANT CONNECT, RESOURCE, UNLIMITED TABLESPACE TO oggsrc;
Grant succeeded.
d. Configure the Data Guard Log Shipping -srcdb
SQL> alter system set log_archive_dest_2='SERVICE=mngdb SYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) REOPEN=10 DB_UNIQUE_NAME=mngdb';
System altered.
SQL> alter system set log_archive_dest_state_2=enable;
System altered.
SQL> alter system set log_archive_config='dg_config=(srcdb,mngdb)';
System altered.
SQL> select GROUP#,THREAD#, bytes/1024/1024 MB from gv$log;
GROUP# THREAD# MB
---------- ---------- ----------
1 1 50
2 1 50
3 1 50
SQL> select count(group#) from gv$log;
COUNT(GROUP#)
-------------
3
3. Configuring mining database – mngdb
a. db password file – to enable case insensitivity
[oracle@oel6-node05 ~]$ cd ${ORACLE_HOME}/dbs
[oracle@oel6-node05 dbs]$ ls -ltr orapw*
-rw-r-----. 1 oracle oinstall 1536 May 12 09:34 orapwDBUA3433408
-rw-r-----. 1 oracle oinstall 1536 May 18 10:30 orapwDBUA3001349
-rw-r-----. 1 oracle oinstall 1536 May 18 12:07 orapwmngdb
[oracle@oel6-node05 dbs]$ orapwd file=orapwmngdb password=oracle ignorecase=Y entries=30 force=Y
[oracle@oel6-node05 dbs]$ ls -ltr orapw*
-rw-r-----. 1 oracle oinstall 1536 May 12 09:34 orapwDBUA3433408
-rw-r-----. 1 oracle oinstall 1536 May 18 10:30 orapwDBUA3001349
-rw-r-----. 1 oracle oinstall 5120 May 18 14:38 orapwmngdb
b. Configuring users and tablespaces -mngdb
SQL> select name from v$database;
NAME
---------
MNGDB
SQL> create tablespace oggdata datafile '/u01/app/oracle/oradata/mngdb/oggdata01.dbf' size 100M extent management local uniform size 256k;
Tablespace created.
SQL> CREATE USER oggadm IDENTIFIED BY Welcome1 default tablespace oggdata;
User created.
SQL> GRANT dba TO oggadm;
SQL> CREATE USER oggadmdwn IDENTIFIED BY Welcome1 default tablespace oggdata;
User created.
SQL> GRANT dba TO oggadmdwn;
Grant succeeded.
SQL> exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(grantee=>'OGGADMDWN', privilege_type=>'capture',grant_select_privileges=>true, do_grants=>TRUE);
PL/SQL procedure successfully completed.
c. Configure archival dest and standby logs – mngdb
[oracle@oel6-node05 dbs]$ mkdir /u01/app/oracle/oradata/mngdb/arch
[oracle@oel6-node05 dbs]$ mkdir /u01/app/oracle/oradata/mngdb/redo
[oracle@oel6-node05 dbs]$ mkdir /u01/app/oracle/oradata/mngdb/standby
[oracle@oel6-node05 dbs]$
SQL> select name from v$database;
NAME
---------
MNGDB
Local archiving
SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/mngdb/arch VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)';
System altered.
Standby logs archiving
SQL> alter system set log_archive_dest_2='LOCATION=/u01/app/oracle/oradata/mngdb/standby VALID_FOR=(STANDBY_LOGFILE,ALL_ROLES)';
System altered.
SQL> alter system set log_archive_config='DG_CONFIG=(srcdb,mngdb)';
System altered.
Standby redo logs
SQL> alter database add standby logfile group 4 ('/u01/app/oracle/oradata/mngdb/redo/slog4a.rdo','/u01/app/oracle/oradata/mngdb/redo/slog4b.rdo') size 60M;
Database altered.
SQL> alter database add standby logfile group 5 ('/u01/app/oracle/oradata/mngdb/redo/slog5a.rdo','/u01/app/oracle/oradata/mngdb/redo/slog5b.rdo') size 60M;
alter database add standby logfile group 6 ('/u01/app/oracle/oradata/mngdb/redo/slog6a.rdo','/u01/app/oracle/oradata/mngdb/redo/slog6b.rdo') size 60M;
alter database add standby logfile group 7 ('/u01/app/oracle/oradata/mngdb/redo/slog7a.rdo','/u01/app/oracle/oradata/mngdb/redo/slog7b.rdo') size 60M;
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL> SQL>
SQL>
SQL> select group#,thread#,sequence#,archived,status from V$STANDBY_LOG;
GROUP# THREAD# SEQUENCE# ARC STATUS
---------- ---------- ---------- --- ----------
4 0 0 YES UNASSIGNED
5 0 0 YES UNASSIGNED
6 0 0 YES UNASSIGNED
7 0 0 YES UNASSIGNED
Create users and tablespace – tgtdb
SQL> select name from v$database;
NAME
---------
TGTDB
SQL> create tablespace oggdata datafile '/u01/app/oracle/oradata/tgtdb/oggdata01.dbf' size 100M extent management local uniform size 256k;
Tablespace created.
SQL> CREATE USER oggadm IDENTIFIED BY Welcome1 default tablespace oggdata;
User created.
SQL> GRANT dba TO oggadm;
Grant succeeded.
SQL> CREATE USER oggtrg IDENTIFIED BY Welcome1 default tablespace oggdata;
User created.
SQL> GRANT CONNECT, RESOURCE, UNLIMITED TABLESPACE TO oggtrg;
Grant succeeded.
4. Installing golden gate
a. Source db
[oracle@oel6-node03 ~]$ rm -rf goldengate/
[oracle@oel6-node03 ~]$ mkdir /home/oracle/goldengate
[oracle@oel6-node03 ~]$ cd /home/oracle/goldengate
[oracle@oel6-node03 goldengate]$ cp /shared_dir/Goldengate/GG-11.2.1.0.0/V34339-01.zip .
[oracle@oel6-node03 goldengate]$ unzip V34339-01.zip
[oracle@oel6-node03 goldengate]$ tar xfv fbo_ggs_Linux_x64_ora11g_64bit.tar
[oracle@oel6-node03 goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (oel6-node03.localdomain) 1> Create Subdirs
Creating subdirectories under current directory /home/oracle/goldengate
Parameter files /home/oracle/goldengate/dirprm: already exists
Report files /home/oracle/goldengate/dirrpt: created
Checkpoint files /home/oracle/goldengate/dirchk: created
Process status files /home/oracle/goldengate/dirpcs: created
SQL script files /home/oracle/goldengate/dirsql: created
Database definitions files /home/oracle/goldengate/dirdef: created
Extract data files /home/oracle/goldengate/dirdat: created
Temporary files /home/oracle/goldengate/dirtmp: created
Stdout files /home/oracle/goldengate/dirout: created
GGSCI (oel6-node03.localdomain) 3> Edit Param mgr
GGSCI (oel6-node03.localdomain) 5> Edit Param mgr
GGSCI (oel6-node03.localdomain) 6> view Param mgr
Port 7909
DynamicPortList 20100-20199
PurgeOldExtracts ./dirdat/pe*, UseCheckPoints, MinKeepHours 2
GGSCI (oel6-node03.localdomain) 7> Info mgr
Manager is DOWN!
GGSCI (oel6-node03.localdomain) 8> Start mgr
Manager started.
GGSCI (oel6-node03.localdomain) 9> Info mgr
Manager is running (IP port oel6-node03.localdomain.7909).
b. target db
Setup golden gate on tgtdb
[oracle@oel6-node04 ~]$ rm -rf goldengate/
[oracle@oel6-node04 ~]$ mkdir /home/oracle/goldengate
[oracle@oel6-node04 ~]$ cd /home/oracle/goldengate
[oracle@oel6-node04 goldengate]$ cp /shared_dir/Goldengate/GG-11.2.1.0.0/V34339-01.zip .
[oracle@oel6-node04 goldengate]$ unzip V34339-01.zip
[oracle@oel6-node04 goldengate]$ tar xfv fbo_ggs_Linux_x64_ora11g_64bit.tar
[oracle@oel6-node04 goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (oel6-node04.localdomain) 1> CREATE SUBDIRS
Creating subdirectories under current directory /home/oracle/goldengate
Parameter files /home/oracle/goldengate/dirprm: already exists
Report files /home/oracle/goldengate/dirrpt: created
Checkpoint files /home/oracle/goldengate/dirchk: created
Process status files /home/oracle/goldengate/dirpcs: created
SQL script files /home/oracle/goldengate/dirsql: created
Database definitions files /home/oracle/goldengate/dirdef: created
Extract data files /home/oracle/goldengate/dirdat: created
Temporary files /home/oracle/goldengate/dirtmp: created
Stdout files /home/oracle/goldengate/dirout: created
c. on mining db
[oracle@oel6-node05 ~]$ rm -rf goldengate/
[oracle@oel6-node05 ~]$ mkdir /home/oracle/goldengate
[oracle@oel6-node05 ~]$ cd /home/oracle/goldengate
[oracle@oel6-node05 goldengate]$ cp /shared_dir/Goldengate/GG-11.2.1.0.0/V34339-01.zip .
[oracle@oel6-node05 goldengate]$ unzip V34339-01.zip
[oracle@oel6-node05 goldengate]$ tar xfv fbo_ggs_Linux_x64_ora11g_64bit.tar
[oracle@oel6-node05 goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (oel6-node05.localdomain) 1> Create Subdirs
Creating subdirectories under current directory /home/oracle/goldengate
Parameter files /home/oracle/goldengate/dirprm: already exists
Report files /home/oracle/goldengate/dirrpt: created
Checkpoint files /home/oracle/goldengate/dirchk: created
Process status files /home/oracle/goldengate/dirpcs: created
SQL script files /home/oracle/goldengate/dirsql: created
Database definitions files /home/oracle/goldengate/dirdef: created
Extract data files /home/oracle/goldengate/dirdat: created
Temporary files /home/oracle/goldengate/dirtmp: created
Stdout files /home/oracle/goldengate/dirout: created
GGSCI (oel6-node05.localdomain) 2> Edit Param mgr
GGSCI (oel6-node05.localdomain) 6> view params mgr
Port 7809
DynamicPortList 20000-20099
PurgeOldExtracts ./dirdat/*, UseCheckPoints, MinKeepHours 2
GGSCI (oel6-node05.localdomain) 3> Info mgr
Manager is DOWN!
GGSCI (oel6-node05.localdomain) 4> Start mgr
Manager started.
GGSCI (oel6-node05.localdomain) 5> Info mgr
Manager is running (IP port oel6-node05.localdomain.7809).
5. Adding Transaction Data
a. Restart GGSCI and run Add TranData for the whole oggsrc schema – srcdb
[oracle@oel6-node03 goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (oel6-node03.localdomain) 1> dblogin userid oggadm@srcdb, password Welcome1
Successfully logged into database.
GGSCI (oel6-node03.localdomain) 2> info trandata oggsrc.*
Logging of supplemental redo log data is disabled for table OGGSRC.ECONOMIC_ENTITY.
Logging of supplemental redo log data is disabled for table OGGSRC.GDP_BY_YEAR.
Logging of supplemental redo log data is disabled for table OGGSRC.GDP_GROWTH_BY_YEAR.
GGSCI (oel6-node03.localdomain) 3> add trandata oggsrc.*
Logging of supplemental redo data enabled for table OGGSRC.ECONOMIC_ENTITY.
Logging of supplemental redo data enabled for table OGGSRC.GDP_BY_YEAR.
Logging of supplemental redo data enabled for table OGGSRC.GDP_GROWTH_BY_YEAR.
GGSCI (oel6-node03.localdomain) 4> info trandata oggsrc.*
Logging of supplemental redo log data is enabled for table OGGSRC.ECONOMIC_ENTITY.
Columns supplementally logged for table OGGSRC.ECONOMIC_ENTITY: ENTITY_ID.
Logging of supplemental redo log data is enabled for table OGGSRC.GDP_BY_YEAR.
Columns supplementally logged for table OGGSRC.GDP_BY_YEAR: ENTITY_ID, GDP_YEAR.
Logging of supplemental redo log data is enabled for table OGGSRC.GDP_GROWTH_BY_YEAR.
Columns supplementally logged for table OGGSRC.GDP_GROWTH_BY_YEAR: ENTITY_ID, GDP_YEAR.
6. Configuring and register the Primary Extract on the Oracle downstream instance – mngdb
[oracle@oel6-node05 goldengate]$ pwd
/home/oracle/goldengate
[oracle@oel6-node05 goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (oel6-node05.localdomain) 1> dblogin userid oggadm@srcdb, password Welcome1
Successfully logged into database.
GGSCI (oel6-node05.localdomain) 2> miningdblogin userid oggadmdwn, password Welcome1
Successfully logged into mining database.
GGSCI (oel6-node05.localdomain) 3> register extract exdwn database
2020-05-18 15:12:46 WARNING OGG-02064 Oracle compatibility version 11.2.0.0.0 has limited datatype support for integrated capture. Version 11.2.0.3 required for full support.
2020-05-18 15:12:59 INFO OGG-02003 Extract EXDWN successfully registered with database at SCN 1108090.
7. Create extract parameter file on the Oracle downstream instance – mngdb
GGSCI (oel6-node05.localdomain) 4> edit param exdwn
GGSCI (oel6-node05.localdomain) 3> view param exdwn
Extract exdwn
userid oggadm@srcdb password Welcome1
tranlogoptions mininguser oggadmdwn@mngdb miningpassword Welcome1
tranlogoptions integratedparams (max_sga_size 128, downstream_real_time_mine Y)
exttrail ./dirdat/dw
table oggsrc.*;
GGSCI (oel6-node05.localdomain) 6> add extract exdwn, integrated tranlog, begin now
EXTRACT added.
GGSCI (oel6-node05.localdomain) 7> add exttrail ./dirdat/dw, extract exdwn, megabytes 10
EXTTRAIL added.
GGSCI (oel6-node05.localdomain) 8> Info All
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXDWN 00:00:00 00:01:05
8. Configure pump on mining db – mngdb
GGSCI (oel6-node05.localdomain) 50> Edit Param pmpdw
GGSCI (oel6-node05.localdomain) 5> view params pmpdw
Extract pmpdw
userid oggadm, password Welcome1
rmthost oel6-node04.localdomain, mgrport 7909
rmttrail ./dirdat/pw
passthru
table oggsrc.*;
GGSCI (oel6-node05.localdomain) 51> add extract pmpdw, exttrailsource ./dirdat/dw
EXTRACT added.
GGSCI (oel6-node05.localdomain) 52> add rmttrail ./dirdat/pw, extract pmpdw, megabytes 10
RMTTRAIL added.
9. Configure replicat on target DB – tgtdb
GGSCI (oel6-node04.localdomain) 2> Edit Param mgr
GGSCI (oel6-node04.localdomain) 3> view Param mgr
Port 7909
DynamicPortList 20100-20199
PurgeOldExtracts ./dirdat/pw*, UseCheckPoints, MinKeepHours 2
GGSCI (oel6-node04.localdomain) 5> start manager
Manager started.
GGSCI (oel6-node04.localdomain) 9> view params REPTGT
Replicat reptgt
SETENV(ORACLE_HOME="/u01/app/oracle/product/11.2.0/db_1")
SETENV(ORACLE_SID = "tgtdb")
AssumeTargetDefs
DiscardFile ./dirrpt/rpdw.dsc, Purge
UserID oggadm, Password Welcome1
Map oggsrc.*, target oggtrg.*;
GGSCI (oel6-node04.localdomain) 18> add replicat REPTGT , exttrail ./dirdat/pw, nodbcheckpoint
REPLICAT added.
10. Start extract and pump
GGSCI (oel6-node05.localdomain) 212> start extract *
Sending START request to MANAGER ...
EXTRACT EXDWN starting
Sending START request to MANAGER ...
EXTRACT PMPDW starting
GGSCI (oel6-node05.localdomain) 213> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXDWN 00:05:29 00:00:00
EXTRACT RUNNING PMPDW 00:00:00 00:01:32
11. Do initial load using expdp
a. Check current scn on source – srcdb
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
1173072
b. Export using flashback scn
[oracle@oel6-node03 dpdump]$ expdp directory=DATA_PUMP_DIR schemas=oggsrc parallel=4 dumpfile=oggsrc_%u.dmp logfile=oggsrc.log flashback_scn=1173072
Export: Release 11.2.0.3.0 - Production on Tue May 19 14:19:45 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA directory=DATA_PUMP_DIR schemas=oggsrc parallel=4 dumpfile=oggsrc_%u.dmp logfile=oggsrc.log flashback_scn=1173072
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 768 KB
. . exported "OGGSRC"."ECONOMIC_ENTITY" 12.21 KB 235 rows
. . exported "OGGSRC"."GDP_BY_YEAR" 14.06 KB 470 rows
. . exported "OGGSRC"."TEST1" 5.054 KB 8 rows
. . exported "OGGSRC"."GDP_GROWTH_BY_YEAR" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/srcdb/dpdump/oggsrc_01.dmp
/u01/app/oracle/admin/srcdb/dpdump/oggsrc_02.dmp
/u01/app/oracle/admin/srcdb/dpdump/oggsrc_03.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:20:04
c. Copy the dump files on target
[oracle@oel6-node03 dpdump]$ scp ogg* oel6-node04:/u01/app/oracle/admin/tgtdb/dpdump/
oracle@oel6-node04's password:
oggsrc_01.dmp 100% 44KB 44.0KB/s 00:00
oggsrc_02.dmp 100% 32KB 32.0KB/s 00:00
oggsrc_03.dmp 100% 204KB 204.0KB/s 00:00
oggsrc.log 100% 1864 1.8KB/s 00:00
d. Import on target
[oracle@oel6-node04 dpdump]$ impdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=oggsrc_%u.dmp logfile=oggsrc_imp.log remap_SCHEMA=oggsrc:oggtrg
Import: Release 11.2.0.3.0 - Production on Tue May 19 13:47:01 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": /******** AS SYSDBA DIRECTORY=DATA_PUMP_DIR DUMPFILE=oggsrc_%u.dmp logfile=oggsrc_imp.log remap_SCHEMA=oggsrc:oggtrg
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "OGGTRG"."ECONOMIC_ENTITY" 12.21 KB 235 rows
. . imported "OGGTRG"."GDP_BY_YEAR" 14.06 KB 470 rows
. . imported "OGGTRG"."TEST1" 5.062 KB 9 rows
. . imported "OGGTRG"."GDP_GROWTH_BY_YEAR" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 13:47:06
12. Start replicat using ATCSN
GGSCI (oel6-node04.localdomain) 2> start replicat REPTGT, aftercsn 1173072
Sending START request to MANAGER ...
REPLICAT REPTGT starting
GGSCI (oel6-node04.localdomain) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPTGT 00:00:00 00:00:02
13. Testing the load stats
GGSCI (oel6-node04.localdomain) 12> stats REPTGT
Sending STATS request to REPLICAT REPTGT ...
Start of Statistics at 2020-05-19 15:44:14.
Replicating from OGGSRC.TEST1 to OGGTRG.TEST1:
*** Total statistics since 2020-05-19 14:32:48 ***
Total inserts 2.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
*** Daily statistics since 2020-05-19 14:32:48 ***
Total inserts 2.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
*** Hourly statistics since 2020-05-19 15:00:00 ***
No database operations have been performed.
*** Latest statistics since 2020-05-19 14:32:48 ***
Total inserts 2.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 2.00
Replicating from OGGSRC.GDP_BY_YEAR to OGGTRG.GDP_BY_YEAR:
*** Total statistics since 2020-05-19 14:32:48 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
*** Daily statistics since 2020-05-19 14:32:48 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
*** Hourly statistics since 2020-05-19 15:00:00 ***
No database operations have been performed.
*** Latest statistics since 2020-05-19 14:32:48 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
End of Statistics.
GGSCI (oel6-node05.localdomain) 8> stats EXDWN
Sending STATS request to EXTRACT EXDWN ...
Start of Statistics at 2020-05-19 15:44:47.
Output to ./dirdat/dw:
Extracting from OGGSRC.TEST1 to OGGSRC.TEST1:
*** Total statistics since 2020-05-19 14:04:09 ***
Total inserts 5.00
Total updates 0.00
Total deletes 6.00
Total discards 0.00
Total operations 11.00
*** Daily statistics since 2020-05-19 14:04:09 ***
Total inserts 5.00
Total updates 0.00
Total deletes 6.00
Total discards 0.00
Total operations 11.00
*** Hourly statistics since 2020-05-19 15:00:00 ***
No database operations have been performed.
*** Latest statistics since 2020-05-19 14:04:09 ***
Total inserts 5.00
Total updates 0.00
Total deletes 6.00
Total discards 0.00
Total operations 11.00
Extracting from OGGSRC.GDP_BY_YEAR to OGGSRC.GDP_BY_YEAR:
*** Total statistics since 2020-05-19 14:04:09 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
*** Daily statistics since 2020-05-19 14:04:09 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
*** Hourly statistics since 2020-05-19 15:00:00 ***
No database operations have been performed.
*** Latest statistics since 2020-05-19 14:04:09 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
End of Statistics.
GGSCI (oel6-node05.localdomain) 10> stats PMPDW
Sending STATS request to EXTRACT PMPDW ...
Start of Statistics at 2020-05-19 15:45:13.
Output to ./dirdat/pw:
Extracting from OGGSRC.TEST1 to OGGSRC.TEST1:
*** Total statistics since 2020-05-19 14:04:09 ***
Total inserts 5.00
Total updates 0.00
Total deletes 6.00
Total discards 0.00
Total operations 11.00
*** Daily statistics since 2020-05-19 14:04:09 ***
Total inserts 5.00
Total updates 0.00
Total deletes 6.00
Total discards 0.00
Total operations 11.00
*** Hourly statistics since 2020-05-19 15:00:00 ***
No database operations have been performed.
*** Latest statistics since 2020-05-19 14:04:09 ***
Total inserts 5.00
Total updates 0.00
Total deletes 6.00
Total discards 0.00
Total operations 11.00
Extracting from OGGSRC.GDP_BY_YEAR to OGGSRC.GDP_BY_YEAR:
*** Total statistics since 2020-05-19 14:04:09 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
*** Daily statistics since 2020-05-19 14:04:09 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
*** Hourly statistics since 2020-05-19 15:00:00 ***
No database operations have been performed.
*** Latest statistics since 2020-05-19 14:04:09 ***
Total inserts 0.00
Total updates 0.00
Total deletes 470.00
Total discards 0.00
Total operations 470.00
End of Statistics.
DBATracker 