Oracle GoldenGate Install For Linux, oraclegoldengate
DownLoad:
Http://edelivery.oracle.com
Prepare (Source And Target DB): Add Environment Variblevi/home/oracle /. bash_profileexport LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib:/opt/ogg Configure Databasealter database archivelog; alter database force logging; alter database add supplemental log data; alter system set recyclebin = OFF scope = spfile; for Oracle 11g, need to be restart Create OGG User: sqlplus/as sysdbacreate user ogg identif Ied by ogg; grant dba to ogg; GGSCI (testdb) 1> edit params. /GLOBALGGSCHEMA oggCHECKPOINTTABLE ogg. for checkpoint For ddl synchronization, run the following Script: marker_setup. SQL-this script is required to install the marker system. When you execute this script, you will be prompted to enter the schema name of the GoldenGate management account. ddl_setup-execute this script to ensure that all ORACLE sessions are closed. sessions that are not closed are displayed in the list. During execution, you must want the object owner and select the installation mode. If "INITIALSETUP" is selected for the first installation, this mode assumes that no GoldenGate DDL object exists. If yes, it will be deleted and rebuilt. If the installation is reinstalled, select "NORMAL ". role_setup-This operation recreates the permissions required for DDL synchronization and grants the DDL object in GoldenGate the DML permission. ddl_enable-enable DDL triggers to capture DDL operations. to improve the performance of DDL triggers, you can use the ddl_pin script to load the packages used by the triggers to the memory to improve efficiency. The dbms_shared_pool system package must be referenced when the script is executed. Therefore, make sure that dbms_shared_pool is available before using the ddl_pin script. @? /Rdbms/admin/dbmspool. sqlddl_pin-to execute the ddl_pin script, you must specify the GoldenGate administrator schema name. Then, the object used to synchronize DDL operations is created. Source DB: GGSCI (ogg1) 1> create subdirs
GGSCI (ogg1) 75> edit param mgr
PORT 7809
Userid ogg, password ogg
PURGEOLDEXTRACTS./dirdat/k1 *, USECHECKPOINTS, MINKEEPFILES 10
Autorestart er *, RETRIES 3, WAITMINUTES 5
Purgeddlhistory minkeepdays 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
Purgemarkerhistory minkeepdays 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
##########
DatapumpGGSCI (ogg1) 4> add extract dpump, exttrailsource/opt/ogg/dirdat/k1EXTRACT added. GGGSCI (ogg1) 4> add rmttrail/opt/ogg/dirdat/k1, extract dpumpRMTTRAIL added. GGSCI (ogg1) 76> edit param dpump
Extract dpump
Setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
Userid ogg, password ogg
Rmthost 192.168.56.13, mgrport 7809
Rmttrail/opt/ogg/dirdat/k1
DYNAMICRESOLUTION
Table zbdba .*;
###########
ExtractGGSCI (ogg1) 1> dblogin userid ogg, password oggSuccessfully logged into database. GGSCI (ogg1) 2> add extract ext1, tranlog, begin nowEXTRACT added. GGSCI (ogg1) 4> add exttrail/opt/ogg/dirdat/k1, extract ext1EXTTRAIL added. GGSCI (ogg1) 78> edit param ext1
EXTRACT EXT1
Setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
USERID ogg, PASSWORD ogg
Exttrail/opt/ogg/dirdat/k1
DYNAMICRESOLUTION
DDL INCLUDE MAPPED
Ddloptions addtrandata, REPORT
FETCHOPTIONS, USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
WARNLONGTRANS 1 H, CHECKINTERVAL 5 M
TABLE zbdba .*;
Start managerstart dpumpstart ext1 GGSCI (ogg1) 16> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
Extract running dpump 00:00:00 00:00:07
Extract running EXT1 00:00:00 00:00:03
Target DB: GGSCI (ogg2) 1> create subdirs
Edit param mgrPORT 7809 userid ogg, password oggPURGEOLDEXTRACTS. /dirdat/k1 *, USECHECKPOINTS, MINKEEPFILES 10 autorestart er *, RETRIES 3, WAITMINUTES 5 PURGEDDLHISTORY limit 3, limit 5, limit 30 purgemarkerhistory minkeepdays 3, limit 5, limit 30
Create ReplicatGGSCI (ogg2) 1> view param. /GLOBALSGGSCHEMA oggCHECKPOINTTABLE ogg. checkpointGGSCI (ogg2) 1> dblogin userid ogg, password oggGGSCI (ogg2) 2> add checkpointtable ogg. checkpoint Successfully created checkpoint table OGG. CHECKPOINT. GGSCI (ogg2) 2> add replicat rep1, exttrail/opt/ogg/dirdat/k1, checkpointtable ogg. checkpointREPLICAT added. GGSCI (ogg2) 19> edit param rep1
REPLICAT rep1
ASSUMETARGETDEFS
USERID ogg, PASSWORD ogg
Discardfile./dirdat/rep1_discard.txt, append, megabytes 5
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
BATCHSQL
DBOPTIONS DEFERREFCONST
Dboptions lobwritesize 102400
HANDLECOLLISIONS
Ddlerror default discard retryop maxretries 5 RETRYDELAY 20
-Grouptransops 1
-Maxtransops 1
APPLYNOOPUPDATES
MAP zbdba. *, TARGET zbdba .*;
Start manager
GGSCI (ogg2) 23> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
Replicat stopped REP1 00:00:00
Test Data (Source and Target DB): create tablepsace zbdab datafile '/opt/oracle/oradata/zbdba. dbf 'size 100 m; create zbdba identified by oracle default tablespace zbdba; grant dba to zbbda; On Source DB: User data pump: expdp zbdba/oracle DIRECTORY = dumpdir
DUMPFILE = zbdba. dmp LOGFILE = zbdba. log
SCHEMAS = zbdba JOB_NAME = exp_zbdba_schema scp data to target DB On Target DB: impdp zbdba/oracle DIRECTORY = dumpdir
DUMPFILE = zbdba. dmp SCHEMAS = zbdba
JOB_NAME = imp_zbdba_schema
GGSCI (ogg2) 24> start rep1
Sending START request to MANAGER...
REPLICAT REP1 starting
GGSCI (ogg2) 26> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
Replicat running REP1 00:00:00
On Source DB:
Create table test as select * from dba_objects;
Monitor OGG (Source And Target DB): tail-100f ggserr. log
Oracle goldengate for linux X86 installation package, 617053105 @ qqcom. The official website does not support Chinese IP addresses.
Buddy, sent
Oracle GoldenGate For Oracle 10g (windows) installation package, help zhang3130079 @ 163com
Of course, this kind of things has been downloaded on the official website, and it does not cost money to download them.
Www.oracle.com/..ocomen