GoldenGate安装及配置

OGG的配置只做了简单的笔记方便自己以后查询，还没有深入研究。
unzip  v18157-01.zip
tar vxf ggs_redhatAS40_x64_ora10g_64bit_v10.4.0.19_002.tar
ggsci
create subdirs
edit param mgr
PORT 7809
SQL> alter database add supplemental log data;
SQL> alter system switch logfile;
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
--------
YES
------------------------
ggsci
dblogin userid qgtrans, password jbkjqgdb
add trandata qgtrans.tt_info_trader
GGSCI (LXDB1) 4> info trandata qgtrans.tt_info_trader
Logging of supplemental redo log data is enabled for table QGTRANS.TT_INFO_TRADER
######################################################################initial load

--------------------------------------------源库
ggsci
add extract einikk, sourceistable
edit param einikk
EXTRACT EINIKK
USERID qgtrans, PASSWORD jbkjqgdb
RMTHOST 172.20.19.10, MGRPORT 7809
RMTTASK REPLICAT, GROUP RINIKK
TABLE qgtrans.tt_info_trader;

----------------------------------------------目标库
add replicat rinikk, specialrun
edit param rinikk
replicat rinikk
assumetargetdefs
USERID ebaimiquery1, PASSWORD Eery1PotatO
DISCARDFILE ./dirrpt/RINIKK.dsc, PURGE
MAP qgtrans.tt_info_trader, TARGET ebaimiquery1.tt_info_trader_bak;

------------------------------------------源库
start extract einikk 
view report einikk
#################################################################change capture_extract

------------------------------------------源库
add extract eorakk, tranlog, begin now, threads 2
info extract
edit params eorakk
EXTRACT EORAKK
USERID qgtrans, PASSWORD jbkjqgdb
tranlogoptions altarchivedlogformat threadid 1 %t_%s_%r.dbf
tranlogoptions altarchivedlogformat threadid 2 %t_%s_%r.dbf
tranlogoptions altarchivelogdest instance lxrac1 /oraarch1, altarchivelogdest instance lxrac2 /oraarch1
RMTHOST 172.20.19.10, MGRPORT 7809
RMTTRAIL ./dirdat/kk
TABLE qgtrans.tt_info_trader;

add RMTTRAIL ./dirdat/kk, EXTRACT EORAKK, MEGABYTES 5
info rmttrail *
start extract eorakk
info all
info extract eorakk, detail
view report eorakk

----------------------------------------------目标库
ggsci
edit params ./GLOBALS
CHECKPOINTTABLE ebaimiquery1.ggchkptable

dblogin userid ebaimiquery1, password Eery1PotatO
add checkpointtable
sqlplus system/oracle
desc ggchkptable

ggsci
add replicat rorakk, exttrail ./dirdat/kk
edit params rorak
REPLICAT RORAKK
USERID ebaimiquery1, PASSWORD Eery1PotatO
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORAKK.DSC,PURGE
MAP qgtrans.tt_info_trader, TARGET ebaimiquery1.tt_info_tracer_bak;

start replicat rorakk
info all



###################################################################################################参考
------------------------------------------源库
cd dirdat
mkdir extrakk
cd ../dirprm
vi extrakk.prm
EXTRACT EXTRAKK
EXTRACT EXTRAKK
USERID qgtrans, PASSWORD jbkjqgdb
TRANLOGOPTIONS ASMUSER SYS@asm,ASMPASSWORD oracle
GETTRUNCATES
TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT THREADID 1 %t_%s_%r.dbf
TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT THREADID 2 %t_%s_%r.dbf
TRANLOGOPTIONS ALTARCHIVELOGDEST INSTANCE lxrac1 /oraarch1, ALTARCHIVELOGDEST INSTANCE lxrac2 /oraarch1
EXTTRAIL ./dirdat/extrakk/kk, MEGABYTES 100
TABLE QGTRANS.TT_INFO_TRADER;

vi dpprakk.prm
EXTRACT query2
passthru
USERID qgtrans, PASSWORD jbkjqgdb
RMTHOST 172.20.19.11, MGRPORT 7809
RMTTRAIL ./dirdat/extrakk/kk
TABLE QGTRANS.TT_INFO_TRADER;

ADD EXTRACT DPPRAKK , EXTTRAILSOURCE ./dirdat/extrakk/kk
ADD RMTTRAIL ./dirdat/extrakk/kk, EXTRACT DPPRAKK, MEGABYTES 100
ADD EXTRACT EXTRAKK, TRANLOG, BEGIN NOW, THREADS 2
ADD EXTTRAIL  ./dirdat/extrakk/kk, EXTRACT EXTRAKK
ADD EXTRACT query2 , EXTTRAILSOURCE ./dirdat/extrakk/kk
ADD RMTTRAIL ./dirdat/extrakk/kk, EXTRACT query2, MEGABYTES 100

------------------------------------------------------------------------------------------------------------
----------------------------------------------目标库
cd dirdat
mkdir extrakk
cd ../dirprm
vi reprakk.prm
REPLICAT REPRAKK
SETENV (ORACLE_SID=DBBUSI)
USERID ebaimiquery1, PASSWORD Eery1PotatO
GETTRUNCATES
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORAKK.DSC,PURGE
MAP QGTRANS.TT_INFO_TRADER, TARGET EBAIMIQUERY1.TT_INFO_TRACER_BAK;


add replicat reprakk, exttrail ./dirdat/extrakk/kk, nodbcheckpoint
start replicat reprakk
------------------------------------------------------------------------------------配置ASM
ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =lxdb1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = +ASM)
      (UR=A)
    )
  )

--------------------------------------------------------------------------------
ps -ef|grep pmon
delete ext dpp

------------------------------------------源库
SQL>create directoty dump_file_dir as '/data/backup/dmp';
SQL>grant read,write on directory dump_file_dir to zfxfzb;
ORACLE> expdp zfxfzb/zfsoft_zju directory=gyj dumpfile=zjlpd_20090618.dmp  filesize=3G parallel=4 FLASHBACK_SCN=358523

----------------------------------------------目标库
SQL>create directoty dump_file_dir as '/data/backup/dmp';
SQL>grant read,write on directory dump_file_dir to zfxfzb;
ORACLE> impdp jss/jss directory=dump_file_dir dumpfile=zjlpd_2090618.dmp parallel=2 nologfile=y remap_schema=(zj_lpd:jss) remap_tablespace=(zj_lpd:jsstbs)
add ext extlc2, tranlog, begin scn=358523

1、启动源端的抽取进程，投递进程
2、按SCN导出
3、在目标端导入
4、目标端按SCN启动应用进程
常用的初始化就是，基于SCN导出，然后直接导入到目标，启动EXT基于SCN就行了目标端的表先删掉假如基于SCN=5导出
那用EXT启动SCN=5如果用覆盖
table_exists_action=replace

**********本博客所有内容均为原创，如有转载请注明作者和出处!!!**********
Name:    guoyJoe

QQ:        252803295

Email:    [e-mail]

Blog:      http://blog.csdn.net/guoyJoe

ITPUB:   http://www.itpub.net/space-uid-28460966.html

OCM:     http://education.oracle.com/education/otn/YGuo.HTM
 _____________________________________________________________
加群验证问题：哪些SGA结构是必需的，哪些是可选的？否则拒绝申请!!!

答案在：http://blog.csdn.net/guoyjoe/article/details/8624392

Oracle@Paradise 　总群:127149411

Oracle@Paradise No.1群:177089463(已满)

Oracle@Paradise No.2群:121341761

Oracle@Paradise No.3群:140856036

分享到:QQ空间腾讯微博腾讯朋友