=====>Node 1 details
OS details:
[oracle@gg1 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
hostname: gg1.example.com
database details:
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -
64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE
11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Database name : Dev1
golden gate details:
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1
OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012
08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All
rights reserved.
====>Node2 details
OS details:
[oracle@gg2 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
hostname: gg2.example.com
database details:
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -
64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE
11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Database name : Dev2
golden gate details:
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1
OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012
08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All
rights reserved.
====>TNS configuration both node..
edit tnsname.ora
node 1:
DEV2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = gg2.example.com)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME =
dev2)
)
)
DEV1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = gg1.example.com)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER =
DEDICATED)
(SERVICE_NAME =
dev1)
)
)
node 2:
DEV2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = gg2.example.com)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER =
DEDICATED)
(SERVICE_NAME =
dev2)
)
)
DEV1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = gg1.example.com)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME =
dev1)
)
)
====>On source database
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
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> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> SELECT force_logging, supplemental_log_data_min FROM
v$database;
FOR SUPPLEME
--- --------
NO YES
SQL> ALTER DATABASE FORCE LOGGING;
Database altered.
SQL> SELECT force_logging, supplemental_log_data_min FROM
v$database;
FOR SUPPLEME
--- --------
YES YES
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> CREATE USER ggate IDENTIFIED BY oracle;
User created.
SQL> grant create session to ggate;
Grant succeeded.
SQL> grant dba to ggate;
Grant succeeded.
SQL> alter system set undo_retention=86400 scope=both;
System altered.
SQL> grant flashback any table to ggate;
Grant succeeded.
SQL>
==>On target server
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> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> SELECT force_logging, supplemental_log_data_min FROM
v$database;
FOR SUPPLEME
--- --------
NO YES
SQL> ALTER DATABASE FORCE LOGGING;
Database altered.
SQL> SELECT force_logging, supplemental_log_data_min FROM
v$database;
FOR SUPPLEME
--- --------
YES YES
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> CREATE USER ggate IDENTIFIED BY ggate;
User created.
SQL> grant create session to ggate;
Grant succeeded.
SQL> grant dba to ggate;
Grant succeeded.
SQL> alter system set undo_retention=86400 scope=both;
System altered.
SQL> grant flashback any table to ggate;
Grant succeeded.
SQL>
============> run below sql script on both node(server)
scrip location GG_HOME:
/u01/app/oracle/product/gg
SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ggate;
SQL> @/ddl_enable.sql
====>Source
GGSCI (gg1.example.com) 3> dblogin userid ggate, Password
ggate
Successfully logged into database.
GGSCI (gg1.example.com) 4> ADD CHECKPOINTTABLE
ggate.OGGCHKPT
GGSCI (gg1.example.com) 5> add trandata scott.*
=====>target
GGSCI (gg1.example.com) 3> dblogin userid ggate, Password
ggate
Successfully logged into database.
GGSCI (gg1.example.com) 4> ADD CHECKPOINTTABLE
ggate.OGGCHKPT
GGSCI (gg1.example.com) 5> add trandata scott.*
Note:creating extract and replicate process on both server.
====>Source
GGSCI (gg1.example.com) 2> edit param mgr
PORT 7809
DYNAMICPORTLIST 7810-7820
PURGEOLDEXTRACTS /u01/app/oracle/product/gg/dirdat/rx*,
USECHECKPOINTS, MINKEEPHOURS 2
GGSCI (gg1.example.com) 4> edit param RX1 -----extract process
EXTRACT rx1
USERID ggate, PASSWORD ******
EXTTRAIL /u01/app/oracle/product/gg/dirdat/rx
DDL INCLUDE ALL
TranLogOptions ExcludeUser ggate
TranLogOptions ExcludeUser ggate
TABLE scott.*;
GGSCI (gg1.example.com) 5> edit param DP1 -------datapump process
EXTRACT dp1
USERID ggate, PASSWORD ******
RMTHOST gg2.example.com, MGRPORT 7809
RMTTRAIL /u01/app/oracle/product/gg/dirdat/rt
DDL INCLUDE ALL
TABLE scott.*;
GGSCI (gg1.example.com) 6> edit param REP1 ------replication process
REPLICAT rep1
USERID ggate, PASSWORD ******
ASSUMETARGETDEFS
DISCARDFILE /u01/app/oracle/product/gg/discards, PURGE
HANDLECOLLISIONS
--COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
--RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, IGNORE)),
--RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
--RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE
MAP scott.*, TARGET scott.*;
USERID ggate, PASSWORD ******
ASSUMETARGETDEFS
DISCARDFILE /u01/app/oracle/product/gg/discards, PURGE
HANDLECOLLISIONS
--COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
--RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, IGNORE)),
--RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
--RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE
MAP scott.*, TARGET scott.*;
GGSCI (gg1.example.com) 7> ADD EXTRACT rx1, TRANLOG,
BEGIN NOW
GGSCI (gg1.example.com) 8> ADD EXTTRAIL
/u01/app/oracle/product/gg/dirdat/rx, EXTRACT rx1
GGSCI (gg1.example.com) 9> ADD EXTRACT dp1 EXTTRAILSOURCE
/u01/app/oracle/product/gg/dirdat/rx
GGSCI (gg1.example.com) 10> ADD RMTTRAIL
/u01/app/oracle/product/gg/dirdat/rt, EXTRACT dp1
GGSCI (gg1.example.com) 11> ADD REPLICAT rep1, EXTTRAIL
/u01/app/oracle/product/gg/dirdat/rt CHECKPOINTTABLE rx025n.OGGCHKPT
REPLICAT added.
GGSCI (gg1.example.com) 20> Info ExtTrail *
Extract Trail:
/u01/app/oracle/product/gg/dirdat/rt
Extract:
DP1
Seqno:
3
RBA:
1513
File Size:
100M
Extract Trail:
/u01/app/oracle/product/gg/dirdat/rx
Extract:
EX1
Seqno:
3
RBA:
1243
File Size:
100M
========> On targate
GGSCI (gg2.example.com) 2> edit param mgr
PORT 7809
DYNAMICPORTLIST 7810-7820
PURGEOLDEXTRACTS /u01/app/oracle/product/gg/dirdat/rx*,
USECHECKPOINTS, MINKEEPHOURS 2
GGSCI (gg2.example.com) 4> edit param RX1 -----extract process
EXTRACT rx1
USERID ggate, PASSWORD ******
EXTTRAIL /u01/app/oracle/product/gg/dirdat/rx
DDL INCLUDE ALL
TranLogOptions ExcludeUser ggate
TranLogOptions ExcludeUser ggate
TABLE scott.*;
GGSCI (gg2.example.com) 5> edit param DP1 -------datapump process
EXTRACT dp1
USERID ggate, PASSWORD ******
RMTHOST gg2.example.com, MGRPORT 7809
RMTTRAIL /u01/app/oracle/product/gg/dirdat/tx
DDL INCLUDE ALL
TABLE scott.*;
GGSCI (gg2.example.com) 6> edit param REP1 ------replication process
REPLICAT rep1
USERID ggate, PASSWORD ******
ASSUMETARGETDEFS
DISCARDFILE /u01/app/oracle/product/gg/discards, PURGE
HANDLECOLLISIONS
--COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
--RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, IGNORE)),
--RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
--RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE
MAP scott.*, TARGET scott.*;
USERID ggate, PASSWORD ******
ASSUMETARGETDEFS
DISCARDFILE /u01/app/oracle/product/gg/discards, PURGE
HANDLECOLLISIONS
--COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
--RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, IGNORE)),
--RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
--RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE
MAP scott.*, TARGET scott.*;
GGSCI (gg2.example.com) 7> ADD EXTRACT ex1, TRANLOG,
BEGIN NOW
EXTRACT added.
GGSCI (gg2.example.com) 8> ADD EXTTRAIL
/u01/app/oracle/product/gg/dirdat/rx, EXTRACT rx1
EXTTRAIL added.
GGSCI (gg2.example.com) 9> ADD EXTRACT dp1 EXTTRAILSOURCE
/u01/app/oracle/product/gg/dirdat/rx
EXTRACT added.
GGSCI (gg2.example.com) 10> ADD RMTTRAIL
/u01/app/oracle/product/gg/dirdat/tx, EXTRACT dp1
RMTTRAIL added
GGSCI (gg2.example.com) 11> ADD REPLICAT rep1, EXTTRAIL
/u01/app/oracle/product/gg/dirdat/tx CHECKPOINTTABLE rx025n.OGGCHKPT
REPLICAT added.
GGSCI (gg2.example.com) 30> Info ExtTrail *
Extract Trail:
/u01/app/oracle/product/gg/dirdat/tx
Extract: DP1
Seqno:
0
RBA:
0
File Size:
100M
Extract Trail:
/u01/app/oracle/product/gg/dirdat/rx
Extract:
EX1
Seqno:
0
RBA:
0
File Size:
100M
======> start gg extract,datapump process on source
- start manager process
- start extract process
- start datapump process
GGSCI (gg1.example.com) 33> start manager
Manager started.
GGSCI (gg1.example.com) 34> start EXTRACT EX1
Sending START request to MANAGER ...
EXTRACT EX1 starting
GGSCI (gg1.example.com) 35> start EXTRACT DP1
Sending START request to MANAGER ...
EXTRACT DP1 starting
GGSCI (gg1.example.com) 36> info all
Program
Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT
RUNNING DP1 00:00:00 00:00:10
EXTRACT
RUNNING RX1 00:00:00 00:00:03
REPLICAT
STOPPED REP1 00:00:00 00:20:17
note: replicate process we will start after target extract
and replication process.
======> start gg extract,datapump process on targate
- start manager process
- start extract process
- start datapump process
GGSCI (gg2.example.com) 47> start extract EX1
Sending START request to MANAGER ...
EXTRACT EX1 starting
GGSCI (gg2.example.com) 48> start extract DP1
Sending START request to MANAGER ...
EXTRACT DP1 starting
GGSCI (gg2.example.com) 49> info all
Program
Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT
RUNNING DP1 00:00:00 00:00:07
EXTRACT
RUNNING RX1 00:00:00 00:00:04
REPLICAT
STOPPED REP1 00:00:00 00:00:09
note: replicate process we will start after target extract
and replication process.
=======> start gg replicate process on target
GGSCI (gg2.example.com) 50> start REPLICAT REP1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (gg1.example.com) 52> info all
Program
Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT
RUNNING DP1 00:00:00 00:00:03
EXTRACT
RUNNING RX1 00:00:00 00:00:01
REPLICAT
RUNNING REP1 00:00:00 00:00:04
=====> start gg replicate process on source
GGSCI (gg1.example.com) 66> start REPLICAT REP1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (gg1.example.com) 67> info all
Program
Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT
RUNNING DP1 00:00:00 00:00:07
EXTRACT
RUNNING RX1 00:00:00 00:00:04
REPLICAT
RUNNING REP1 00:00:00 00:00:09
======> create on table on source database (on source)
SQL> create table t2(id number(10) primary key);
Table created.
SQL> select TABLE_NAME from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
EMP1
T1
T2
7 rows selected.
===> insert one row into dept
SQL> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
66
marketing new york
68
testing perth
10
ACCOUNTING NEW YORK
20
RESEARCH DALLAS
30 SALES CHICAGO
40
OPERATIONS BOSTON
6 rows selected.
SQL> insert into dept values(11,'test','BROOME');
1 row created.
SQL> commit;
Commit complete.
====> GG process stats
GGSCI (gg1.example.com) 9> stats EX1
Sending STATS request to EXTRACT EX1 ...
Start of Statistics at 2016-01-01 02:39:45.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 1.00
Mapped
operations
1.00
Unmapped
operations
0.00
Other
operations
0.00
Excluded
operations
0.00
Extracting from SCOTT.DEPT to SCOTT.DEPT:
*** Total statistics since 2016-01-01 02:27:07 ***
Total
inserts
1.00
Total
updates 0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Daily statistics since 2016-01-01 02:27:07 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards 0.00
Total
operations
1.00
*** Hourly statistics since 2016-01-01 02:27:07 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Latest statistics since 2016-01-01 02:27:07 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
End of Statistics.
GGSCI (gg1.example.com) 7> stats DP1
Sending STATS request to EXTRACT DP1 ...
Start of Statistics at 2016-01-01 02:31:14.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 1.00
Mapped
operations
0.00
Unmapped
operations
0.00
Other
operations
0.00
Excluded
operations
0.00
Output to /u01/app/oracle/product/gg/dirdat/rt:
Extracting from SCOTT.DEPT to SCOTT.DEPT:
*** Total statistics since 2016-01-01 02:30:56 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Daily statistics since 2016-01-01 02:30:56 ***
Total
inserts
1.00
Total
updates 0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Hourly statistics since 2016-01-01 02:30:56 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards 0.00
Total
operations
1.00
*** Latest statistics since 2016-01-01 02:30:56 ***
Total
inserts
1.00
Total
updates 0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
End of Statistics.
====> replication checking (on target)
GGSCI (gg2.example.com) 8> stats rep1
Sending STATS request to REPLICAT REP1 ...
Start of Statistics at 2016-01-01 02:35:39.
DDL replication statistics:
*** Total statistics since replicat started ***
Operations 1.00
Mapped
operations
1.00
Unmapped
operations
0.00
Other
operations 0.00
Excluded
operations
0.00
Errors
0.00
Retried
errors
0.00
Discarded
errors 0.00
Ignored
errors
0.00
Replicating from SCOTT.DEPT to SCOTT.DEPT:
*** Total statistics since 2016-01-01 02:35:29 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Daily statistics since 2016-01-01 02:35:29 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Hourly statistics since 2016-01-01 02:35:29 ***
Total
inserts
1.00
Total
updates 0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Latest statistics since 2016-01-01 02:35:29 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards 0.00
Total
operations
1.00
End of Statistics.
SQL> conn scott
Enter password:
Connected.
SQL> select TABLE_NAME from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
T1
T2
6 rows selected.
SQL> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
68
testing perth
10
ACCOUNTING NEW YORK
20
RESEARCH DALLAS
30 SALES CHICAGO
40
OPERATIONS BOSTON
66
marketing new york
11 test BROOME
7 rows selected.
======> perform DDL and DML opration target
SQL> conn scott
Enter password:
Connected.
SQL> select TABLE_NAME from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
T1
T2
6 rows selected.
SQL> insert into t2 values(11);
1 row created.
SQL> commit;
Commit complete.
SQL> create table t3(id number(10) primary key);
Table created.
SQL> select TABLE_NAME from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
T1
T2
T3
7 rows selected.
SQL> select * from t2;
ID
----------
11
====> target gg process stats
GGSCI (gg2.example.com) 2> stats EX1
Sending STATS request to EXTRACT EX1 ...
Start of Statistics at 2016-01-01 02:55:17.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 12.00
Mapped
operations
2.00
Unmapped
operations
7.00
Other
operations
3.00
Excluded
operations
0.00
Output to /u01/app/oracle/product/gg/dirdat/ex:
Extracting from RX025N.GGS_MARKER to RX025N.GGS_MARKER:
*** Total statistics since 2016-01-01 02:49:00 ***
No database
operations have been performed.
*** Daily statistics since 2016-01-01 02:49:00 ***
No database
operations have been performed.
*** Hourly statistics since 2016-01-01 02:49:00 ***
No database
operations have been performed.
*** Latest statistics since 2016-01-01 02:49:00 ***
No database
operations have been performed.
Extracting from SCOTT.DEPT to SCOTT.DEPT:
*** Total statistics since 2016-01-01 02:49:00 ***
Total
inserts
5.00
Total
updates
2.00
Total
deletes
4.00
Total
discards
0.00
Total
operations
11.00
*** Daily statistics since 2016-01-01 02:49:00 ***
Total
inserts
5.00
Total
updates
2.00
Total
deletes
4.00
Total
discards
0.00
Total
operations
11.00
*** Hourly statistics since 2016-01-01 02:49:00 ***
Total
inserts
5.00
Total
updates 2.00
Total
deletes
4.00
Total
discards
0.00
Total
operations
11.00
*** Latest statistics since 2016-01-01 02:49:00 ***
Total
inserts
5.00
Total
updates
2.00
Total
deletes
4.00
Total
discards
0.00
Total
operations
11.00
Extracting from SCOTT.T2 to SCOTT.T2:
*** Total statistics since 2016-01-01 02:49:00 ***
Total
inserts 1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations 1.00
*** Daily statistics since 2016-01-01 02:49:00 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes 0.00
Total
discards
0.00
Total
operations
1.00
*** Hourly statistics since 2016-01-01 02:49:00 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Latest statistics since 2016-01-01 02:49:00 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
GGSCI (gg2.example.com) 4> stats DP1
Sending STATS request to EXTRACT DP1 ...
Start of Statistics at 2016-01-01 02:55:53.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 12.00
Mapped
operations
0.00
Unmapped
operations 0.00
Other
operations
0.00
Excluded
operations
0.00
Output to /u01/app/oracle/product/gg/dirdat/tx:
Extracting from SCOTT.DEPT to SCOTT.DEPT:
*** Total statistics since 2016-01-01 02:50:01 ***
Total
inserts
5.00
Total
updates
2.00
Total
deletes
4.00
Total discards 0.00
Total
operations
11.00
*** Daily statistics since 2016-01-01 02:50:01 ***
Total
inserts
5.00
Total
updates
2.00
Total
deletes
4.00
Total
discards
0.00
Total
operations
11.00
*** Hourly statistics since 2016-01-01 02:50:01 ***
Total
inserts
5.00
Total
updates
2.00
Total
deletes
4.00
Total
discards
0.00
Total
operations
11.00
*** Latest statistics since 2016-01-01 02:50:01 ***
Total
inserts
5.00
Total updates 2.00
Total
deletes
4.00
Total
discards
0.00
Total
operations
11.00
Extracting from SCOTT.T2 to SCOTT.T2:
*** Total statistics since 2016-01-01 02:50:01 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Daily statistics since 2016-01-01 02:50:01 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Hourly statistics since 2016-01-01 02:50:01 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Latest statistics since 2016-01-01 02:50:01 ***
Total
inserts
1.00
Total updates 0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
End of Statistics.
=====> cheking replication on source database
GGSCI (gg1.example.com) 17> stats rep1
Sending STATS request to REPLICAT REP1 ...
Start of Statistics at 2016-01-01 03:05:12.
DDL replication statistics:
*** Total statistics since replicat started ***
Operations 12.00
Mapped
operations
1.00
Unmapped
operations
8.00
Other
operations
3.00
Excluded
operations
0.00
Errors
0.00
Retried
errors
0.00
Discarded
errors
0.00
Ignored
errors
0.00
Replicating from SCOTT.DEPT to SCOTT.DEPT:
*** Total statistics since 2016-01-01 03:05:06 ***
Total
inserts 9.00
Total
updates
4.00
Total
deletes
9.00
Total
discards
0.00
Total
operations 22.00
*** Daily statistics since 2016-01-01 03:05:06 ***
Total
inserts
9.00
Total
updates
4.00
Total
deletes
9.00
Total
discards
0.00
Total
operations
22.00
*** Hourly statistics since 2016-01-01 03:05:06 ***
Total
inserts
9.00
Total
updates
4.00
Total
deletes
9.00
Total
discards
0.00
Total
operations
22.00
*** Latest statistics since 2016-01-01 03:05:06 ***
Total
inserts
9.00
Total
updates
4.00
Total deletes 9.00
Total
discards
0.00
Total
operations
22.00
Replicating from SCOTT.T2 to SCOTT.T2:
*** Total statistics since 2016-01-01 03:05:06 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Daily statistics since 2016-01-01 03:05:06 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Hourly statistics since 2016-01-01 03:05:06 ***
Total
inserts
1.00
Total
updates
0.00
Total
deletes
0.00
Total
discards
0.00
Total
operations
1.00
*** Latest statistics since 2016-01-01 03:05:06 ***
Total
inserts
1.00
Total
updates
0.00
Total deletes 0.00
Total
discards
0.00
Total
operations
1.00
End of Statistics.
SQL> select
TABLE_NAME from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
EMP1
T1
T2
T3
8 rows selected.
SQL> select * from
t2;
ID
----------
11
*********END**********
No comments:
Post a Comment