There are some restriction with Golden Gate DDL Replication.
1. Oracle database recyclebin must be TURN OFF.
2. Golden Gate can replicate DDL statements that are less than 2MB in length. DDL longer than this value must need to be done manually.
3. DDL replication is supported between only two systems.
4. The Source and Target schema must be identical. So you must use ASSUMETARGETDEFS parameter into Replicat.
5. PASSTHRU mode must need to put into DATA PUMP extract for tables which require DDL replication.
Here.
Source server- source.xxx.com
Target server- target.xxx.com
SQL> alter system set recyclebin=off scope=spfile;
System altered.
[oracle@source GG]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 25 18:21:54 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:gger
Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGER
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Script complete.
SQL> @ddl_setup.sql
GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:gger
You will be prompted for the mode of installation.
To install or reinstall DDL replication, enter INITIALSETUP
To upgrade DDL replication, enter NORMAL
Enter mode of installation:INITIALSETUP
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
Check complete.
Using GGER as a GoldenGate schema name, INITIALSETUP as a mode of installation.
Working, please wait ...
DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGER
DDLORA_GETTABLESPACESIZE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
CLEAR_TRACE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
CREATE_TRACE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
TRACE_PUT_LINE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
INITIAL_SETUP STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDLREPLICATION PACKAGE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDL HISTORY TABLE
-----------------------------------
OK
DDL HISTORY TABLE(1)
-----------------------------------
OK
DDL DUMP TABLES
-----------------------------------
OK
DDL DUMP COLUMNS
-----------------------------------
OK
DDL DUMP LOG GROUPS
-----------------------------------
OK
DDL DUMP PARTITIONS
-----------------------------------
OK
DDL DUMP PRIMARY KEYS
-----------------------------------
OK
DDL SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL TRIGGER CODE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
-----------------------------------
ENABLED
STAYMETADATA IN TRIGGER
-----------------------------------
OFF
DDL TRIGGER SQL TRACING
-----------------------------------
0
DDL TRIGGER TRACE LEVEL
-----------------------------------
0
LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/db1/db1/trace/ggs_ddl_trace.log
Analyzing installation status...
STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components
Script complete.
SQL> @role_setup.sql
GGS Role setup script
This script will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:gger
Wrote file role_setup_set.txt
PL/SQL procedure successfully completed.
Role setup script complete
Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:
GRANT GGS_GGSUSER_ROLE TO <loggedUser>
where <loggedUser> is the user assigned to the GoldenGate processes.
SQL> GRANT GGS_GGSUSER_ROLE TO gger;
Grant succeeded.
Now create the extract for DDL replication.
GGSCI (source.cybage.com) 1> edit params src_ext
extract src_ext
userid gger, password gger
exttrail dirdat/l1
ddl include mapped
table SCOTT.*;
GGSCI (source.cybage.com) 2> edit params src_dpmp
extract src_dpmp
passthru
rmthost 172.28.29.61, mgrport 7809
rmttrail dirdat/l2
table SCOTT.*;
1. Oracle database recyclebin must be TURN OFF.
2. Golden Gate can replicate DDL statements that are less than 2MB in length. DDL longer than this value must need to be done manually.
3. DDL replication is supported between only two systems.
4. The Source and Target schema must be identical. So you must use ASSUMETARGETDEFS parameter into Replicat.
5. PASSTHRU mode must need to put into DATA PUMP extract for tables which require DDL replication.
Here.
Source server- source.xxx.com
Target server- target.xxx.com
AT Source database server.
SQL> alter system set recyclebin=off scope=spfile;
System altered.
Bounce the Database.
[oracle@source GG]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 25 18:21:54 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:gger
Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGER
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Script complete.
SQL> @ddl_setup.sql
GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:gger
You will be prompted for the mode of installation.
To install or reinstall DDL replication, enter INITIALSETUP
To upgrade DDL replication, enter NORMAL
Enter mode of installation:INITIALSETUP
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
Check complete.
Using GGER as a GoldenGate schema name, INITIALSETUP as a mode of installation.
Working, please wait ...
DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGER
DDLORA_GETTABLESPACESIZE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
CLEAR_TRACE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
CREATE_TRACE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
TRACE_PUT_LINE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
INITIAL_SETUP STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDLREPLICATION PACKAGE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDL HISTORY TABLE
-----------------------------------
OK
DDL HISTORY TABLE(1)
-----------------------------------
OK
DDL DUMP TABLES
-----------------------------------
OK
DDL DUMP COLUMNS
-----------------------------------
OK
DDL DUMP LOG GROUPS
-----------------------------------
OK
DDL DUMP PARTITIONS
-----------------------------------
OK
DDL DUMP PRIMARY KEYS
-----------------------------------
OK
DDL SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL TRIGGER CODE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
-----------------------------------
ENABLED
STAYMETADATA IN TRIGGER
-----------------------------------
OFF
DDL TRIGGER SQL TRACING
-----------------------------------
0
DDL TRIGGER TRACE LEVEL
-----------------------------------
0
LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/db1/db1/trace/ggs_ddl_trace.log
Analyzing installation status...
STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components
Script complete.
SQL> @role_setup.sql
GGS Role setup script
This script will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:gger
Wrote file role_setup_set.txt
PL/SQL procedure successfully completed.
Role setup script complete
Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:
GRANT GGS_GGSUSER_ROLE TO <loggedUser>
where <loggedUser> is the user assigned to the GoldenGate processes.
SQL> GRANT GGS_GGSUSER_ROLE TO gger;
Grant succeeded.
Now create the extract for DDL replication.
GGSCI (source.cybage.com) 1> edit params src_ext
extract src_ext
userid gger, password gger
exttrail dirdat/l1
ddl include mapped
table SCOTT.*;
GGSCI (source.cybage.com) 2> edit params src_dpmp
extract src_dpmp
passthru
rmthost 172.28.29.61, mgrport 7809
rmttrail dirdat/l2
table SCOTT.*;
AT Target database .
GGSCI (target.cybage.com) 1> edit params tar_rep
replicat tar_rep
userid gger, password gger
handlecollisions
assumetargetdefs
discardfile /u01/app/GG/dirrpt/tar_rep.dsc, append
map SCOTT.*, target SCOTT.*;
I have not mentioned how to configure Golden Gate user,schema,privileges, manager etc.
Please follow my earlier post for the same.
=======================================================================
Golden Gate DML replication using Data Pump
Oracle Golden Gate Direct Load Method
Installation and configuration of Golden Gate
=======================================================================
Now Lets create a table GG and EXT over Source Database and check the same on Target database.
At Source Database.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
SALGRADE TABLE
TEST TABLE
5 rows selected.
SQL> create table GG as
2 select * from test;
Table created.
SQL> insert into GG
2 select * from test;
280 rows created.
SQL> select count(*) from GG;
COUNT(*)
----------
560
1 row selected.
SQL> conn /as sysdba
Connected.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> select count(*) from scott.GG;
COUNT(*)
----------
560
1 row selected.
SQL> conn scott/tiger
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
GG TABLE
SALGRADE TABLE
TEST TABLE
6 rows selected.
SQL> create table ext as
2 select * from dept;
Table created.
SQL> insert into ext
2 select * from dept;
4 rows created.
SQL> select count(*) from ext;
COUNT(*)
----------
8
1 row selected.
SQL> conn /as sysdba
Connected.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> conn scott/tiger
Connected.
SQL> create table rep as
2 select * from gg;
Table created.
SQL> insert into rep
2 select * from gg;
560 rows created.
SQL> select count(*) from rep;
COUNT(*)
----------
1120
1 row selected.
SQL> conn /as sysdba
Connected.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
GGSCI (source.cybage.com) 5> start src_ext
EXTRACT SRC_EXT is already running.
GGSCI (source.cybage.com) 6> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING SRC_DPMP 00:00:00 00:00:08
EXTRACT RUNNING SRC_EXT 00:00:00 00:00:09
GGSCI (source.cybage.com) 15> view report SRC_EXT
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 11g on Oct 7 2011 15:32:42
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-07-25 18:41:13
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue Mar 16 22:00:21 EDT 2010, Release 2.6.18-194.el5PAE
Node: source.cybage.com
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 19197
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
extract src_ext
userid gger, password ****
exttrail dirdat/l1
ddl include mapped
table SCOTT.*;
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /u01/app/GG
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.86G
CACHESIZEMAX (strict force to disk): 2.63G
2013-07-25 18:41:13 INFO OGG-01639 BOUNDED RECOVERY: ACTIVE: for object pool 1: p17288_extr.
2013-07-25 18:41:13 INFO OGG-01640 BOUNDED RECOVERY: recovery start XID: 0.0.0.
2013-07-25 18:41:13 INFO OGG-01641 BOUNDED RECOVERY: recovery start position: SeqNo: 155, RBA: 12950032, SCN: 0.6292737 (6292737), Timestamp: 2013-07-25
18:15:19.000000.
2013-07-25 18:41:13 INFO OGG-01642 BOUNDED RECOVERY: recovery end position: SeqNo: 155, RBA: 12964352, SCN: 0.6292737 (6292737), Timestamp: 2013-07-25 1
8:15:19.000000.
2013-07-25 18:41:13 INFO OGG-01643 BOUNDED RECOVERY: CANCELED: for object pool 1: p17288_extr.
2013-07-25 18:41:13 INFO OGG-01579 BOUNDED RECOVERY: VALID BCP: CP.SRC_EXT.000000001.
2013-07-25 18:41:13 INFO OGG-01629 BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>>.
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 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 Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
2013-07-25 18:41:13 INFO OGG-01513 Positioning to Sequence 155, RBA 19116048.
2013-07-25 18:41:13 INFO OGG-01516 Positioned to Sequence 155, RBA 19116048, Jul 25, 2013 6:40:47 PM.
2013-07-25 18:41:13 INFO OGG-01055 Recovery initialization completed for target file dirdat/l1000001, at RBA 30715.
2013-07-25 18:41:13 INFO OGG-01478 Output file dirdat/l1 is using format RELEASE 10.4/11.1.
2013-07-25 18:41:13 INFO OGG-01026 Rolling over remote file dirdat/l1000001.
2013-07-25 18:41:13 INFO OGG-01053 Recovery completed for target file dirdat/l1000002, at RBA 1031.
2013-07-25 18:41:13 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
2013-07-25 18:41:13 INFO OGG-01517 Position of first record processed Sequence 155, RBA 19116048, SCN 0.6296158, Jul 25, 2013 6:40:47 PM.
TABLE resolved (entry GGER.GGS_MARKER):
TABLE GGER.GGS_MARKER;
Using the following key columns for source table GGER.GGS_MARKER: SEQNO, FRAGMENTNO, OPTIME.
TABLEWildcard resolved (entry SCOTT.*):
table SCOTT.GG;
2013-07-25 18:42:54 WARNING OGG-00869 No unique key is defined for table GG. All viable columns will be used to represent the key, but may not guarantee un
iqueness. KEYCOLS may be used to define the key.
Using the following key columns for source table SCOTT.GG: EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO.
GGSCI (source.cybage.com) 16> stats SRC_EXT
Sending STATS request to EXTRACT SRC_EXT ...
Start of Statistics at 2013-07-25 18:43:35.
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
Output to dirdat/l1:
Extracting from GGER.GGS_MARKER to GGER.GGS_MARKER:
*** Total statistics since 2013-07-25 18:42:38 ***
No database operations have been performed.
*** Daily statistics since 2013-07-25 18:42:38 ***
No database operations have been performed.
*** Hourly statistics since 2013-07-25 18:42:38 ***
No database operations have been performed.
*** Latest statistics since 2013-07-25 18:42:38 ***
No database operations have been performed.
Extracting from SCOTT.GG to SCOTT.GG:
*** Total statistics since 2013-07-25 18:42:38 ***
Total inserts 280.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 280.00
*** Daily statistics since 2013-07-25 18:42:38 ***
Total inserts 280.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 280.00
*** Hourly statistics since 2013-07-25 18:42:38 ***
Total inserts 280.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 280.00
*** Latest statistics since 2013-07-25 18:42:38 ***
Total inserts 280.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 280.00
End of Statistics.
GGSCI (source.cybage.com) 17> start src_ext
EXTRACT SRC_EXT is already running.
GGSCI (source.cybage.com) 19> view report src_dpmp
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 11g on Oct 7 2011 15:32:42
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-07-25 18:41:17
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue Mar 16 22:00:21 EDT 2010, Release 2.6.18-194.el5PAE
Node: source.cybage.com
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 19204
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
extract src_dpmp
passthru
rmthost 172.28.29.61, mgrport 7809
rmttrail dirdat/l2
table SCOTT.*;
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.86G
CACHESIZEMAX (strict force to disk): 2.63G
2013-07-25 18:41:22 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).
2013-07-25 18:41:26 INFO OGG-01055 Recovery initialization completed for target file dirdat/l2000000, at RBA 30758.
2013-07-25 18:41:26 INFO OGG-01478 Output file dirdat/l2 is using format RELEASE 10.4/11.1.
2013-07-25 18:41:26 INFO OGG-01026 Rolling over remote file dirdat/l2000001.
2013-07-25 18:41:26 INFO OGG-01053 Recovery completed for target file dirdat/l2000001, at RBA 1051.
2013-07-25 18:41:26 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file dirdat/l1000001 at 2013-07-25 18:41:26
Switching to next trail file dirdat/l1000002 at 2013-07-25 18:41:26 due to EOF, with current RBA 30715
Opened trail file dirdat/l1000002 at 2013-07-25 18:41:26
TABLEWildcard resolved (entry SCOTT.*):
table SCOTT.GG;
PASSTHRU mapping resolved for source table SCOTT.GG
TABLEWildcard resolved (entry SCOTT.*):
table SCOTT.EXT;
PASSTHRU mapping resolved for source table SCOTT.EXT
GGSCI (source.cybage.com) 22> stats src_ext
Sending STATS request to EXTRACT SRC_EXT ...
Start of Statistics at 2013-07-25 19:01:45.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 3.00
Mapped operations 3.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Output to dirdat/l1:
Extracting from GGER.GGS_MARKER to GGER.GGS_MARKER:
*** Total statistics since 2013-07-25 18:42:38 ***
No database operations have been performed.
*** Daily statistics since 2013-07-25 18:42:38 ***
No database operations have been performed.
*** Hourly statistics since 2013-07-25 19:00:00 ***
No database operations have been performed.
*** Latest statistics since 2013-07-25 18:42:38 ***
No database operations have been performed.
Extracting from SCOTT.GG to SCOTT.GG:
*** Total statistics since 2013-07-25 18:42:38 ***
Total inserts 280.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 280.00
*** Daily statistics since 2013-07-25 18:42:38 ***
Total inserts 280.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 280.00
*** Hourly statistics since 2013-07-25 19:00:00 ***
No database operations have been performed.
*** Latest statistics since 2013-07-25 18:42:38 ***
Total inserts 280.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 280.00
Extracting from SCOTT.EXT to SCOTT.EXT:
*** Total statistics since 2013-07-25 18:42:38 ***
Total inserts 4.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
*** Daily statistics since 2013-07-25 18:42:38 ***
Total inserts 4.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
*** Hourly statistics since 2013-07-25 19:00:00 ***
No database operations have been performed.
*** Latest statistics since 2013-07-25 18:42:38 ***
Total inserts 4.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
Extracting from SCOTT.REP to SCOTT.REP:
*** Total statistics since 2013-07-25 18:42:38 ***
Total inserts 560.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 560.00
*** Daily statistics since 2013-07-25 18:42:38 ***
Total inserts 560.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 560.00
*** Hourly statistics since 2013-07-25 19:00:00 ***
Total inserts 560.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 560.00
*** Latest statistics since 2013-07-25 18:42:38 ***
Total inserts 560.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 560.00
End of Statistics.
AT Target Database server.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
EXT TABLE
GG TABLE
SALGRADE TABLE
TEST TABLE
SQL> select count(*) from GG;
COUNT(*)
----------
294
SQL> select count(*) from rep;
COUNT(*)
----------
854
GGSCI (target.cybage.com) 37> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING TAR_REP 00:00:00 00:00:04
GGSCI (target.cybage.com) 38> view report tar_rep
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 11g on Oct 7 2011 15:40:15
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-07-25 18:58:42
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Mon Mar 29 20:06:41 EDT 2010, Release 2.6.18-194.el5
Node: target.cybage.com
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 11601
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
replicat tar_rep
userid gger, password ****
handlecollisions
assumetargetdefs
discardfile /u01/app/GG/dirrpt/tar_rep.dsc, append
map SCOTT.*, target SCOTT.*;
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 512M
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1G
CACHESIZEMAX (strict force to disk): 881M
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 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 Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file dirdat/l2000001 at 2013-07-25 18:58:42
2013-07-25 18:58:42 INFO OGG-01407 Setting current schema for DDL operation to [SCOTT].
2013-07-25 18:58:42 INFO OGG-01408 Restoring current schema for DDL operation to [GGER].
Wildcard MAP resolved (entry SCOTT.*):
map SCOTT.GG, target SCOTT.GG;
2013-07-25 18:58:50 WARNING OGG-00869 No unique key is defined for table GG. All viable columns will be used to represent the key, but may not guarantee un
iqueness. KEYCOLS may be used to define the key.
Using following columns in default map by name:
EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
Using the following key columns for target table SCOTT.GG: EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO.
2013-07-25 18:58:51 INFO OGG-01407 Setting current schema for DDL operation to [SCOTT].
2013-07-25 18:58:51 INFO OGG-01408 Restoring current schema for DDL operation to [GGER].
Wildcard MAP resolved (entry SCOTT.*):
map SCOTT.EXT, target SCOTT.EXT;
2013-07-25 18:58:51 WARNING OGG-00869 No unique key is defined for table EXT. All viable columns will be used to represent the key, but may not guarantee u
niqueness. KEYCOLS may be used to define the key.
Using following columns in default map by name:
DEPTNO, DNAME, LOC
Using the following key columns for target table SCOTT.EXT: DEPTNO, DNAME, LOC.
2013-07-25 19:00:47 INFO OGG-01407 Setting current schema for DDL operation to [SCOTT].
2013-07-25 19:00:47 INFO OGG-01408 Restoring current schema for DDL operation to [GGER].
Wildcard MAP resolved (entry SCOTT.*):
map SCOTT.REP, target SCOTT.REP;
2013-07-25 19:01:10 WARNING OGG-00869 No unique key is defined for table REP. All viable columns will be used to represent the key, but may not guarantee u
niqueness. KEYCOLS may be used to define the key.
Using following columns in default map by name:
EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
Using the following key columns for target table SCOTT.REP: EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO.
Done.
Have a Good day. :)
No comments:
Post a Comment