alter system set log_archive_dest_1='location=/oradata2/archivelog/';
alter system set log_archive_dest_state_1=enable;
=============
配置manager进程
edit params mgr
port 7809
dynamicportlist 7815-7850
autorestart er *, retries 5, waitminutes 3
purgeoldextracts /oradata1/ogg/dirdat/*,usecheckpoints, minkeepdays 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
==========
source端配置extract进程和DATA PUMP进程
add extract ggtest,tranlog,begin now
add exttrail /oradata1/ogg/dirdat/tr, extract ggtest, megabytes 100
edit params ggtest
extract ggtest
USERID oggadmin, PASSWORD oggadmin#123,
EXTTRAIL /oradata1/ogg/dirdat/tr
TRANLOGOPTIONS DBLOGREADER, DBLOGREADER BUFSIZE 4194304, BUFSIZE 4194304
FETCHOPTIONS FETCHPKUPDATECOLS
NOCOMPRESSDELETES
DYNAMICRESOLUTION
table oggadmin.t_customer_tel_log_test;
=================
add extract ggpump,exttrailsource /oradata1/ogg/dirdat/tr
add rmttrail /oradata1/ogg/dirdat/td,extract ggpump,megabytes 100
edit param ggpump
extract ggpump
USERID oggadmin, PASSWORD oggadmin#123,
rmthost 10.6.241.76,mgrport 7809, compress
rmttrail /oradata1/ogg/dirdat/td
Dynamicresolution
numfiles 8000
table oggadmin.t_customer_tel_log_test;
==================
目标端
edit param ./GLOBALS
GGSCHEMA oggadmin
CHECKPOINTTABLE oggadmin.checkpointtable
add checkpointtable oggadmin.checkpointtable
==
add replicat reptest,exttrail /oradata1/ogg/dirdat/td,checkpointtable oggadmin.checkpointtable
edit param reptest
replicat reptest
USERID oggadmin, PASSWORD oggadmin#123,
ASSUMETARGETDEFS
REPERROR DEFAULT,DISCARD
DISCARDFILE /oradata1/ogg/dirrpt/reptest.dsc,append,megabytes 100
DYNAMICRESOLUTION
MAP oggadmin.t_customer_tel_log_test, TARGET oggadmin.t_customer_tel_log_test;
===================================================================目标库ogg=================================
create user oggadmin identified by oggadmin#123 default tablespace users ;
oggadmin.bst_range_pub_tel_test
source端配置extract进程和DATA PUMP进程
add extract extch,tranlog,begin now
add exttrail /oradata1/ogg/dirdat/ch/tr, extract extch, megabytes 100
edit params extch
extract extch
USERID oggadmin, PASSWORD oggadmin#123,
EXTTRAIL /oradata1/ogg/dirdat/ch/tr
TRANLOGOPTIONS DBLOGREADER, DBLOGREADER BUFSIZE 4194304, BUFSIZE 4194304
FETCHOPTIONS FETCHPKUPDATECOLS
NOCOMPRESSDELETES
DYNAMICRESOLUTION
table oggadmin.bst_range_pub_tel_test;
=================
add extract ppch,exttrailsource /oradata1/ogg/dirdat/ch/tr
add rmttrail /oradata1/ogg/dirdat/ch/td,extract ppch,megabytes 100
edit param ppch
extract ppch
USERID oggadmin, PASSWORD oggadmin#123,
rmthost 10.6.239.10,mgrport 7809, compress
rmttrail /oradata1/ogg/dirdat/ch/td
Dynamicresolution
numfiles 8000
table oggadmin.bst_range_pub_tel_test;
==================
目标端
edit param ./GLOBALS
GGSCHEMA oggadmin
CHECKPOINTTABLE oggadmin.checkpointtable
add checkpointtable oggadmin.checkpointtable
==
add replicat repch,exttrail /oradata1/ogg/dirdat/ch/td,checkpointtable oggadmin.checkpointtable
edit param repch
replicat repch
USERID oggadmin, PASSWORD oggadmin#123,
ASSUMETARGETDEFS
REPERROR DEFAULT,DISCARD
DISCARDFILE /oradata1/ogg/dirrpt/repch.dsc,append,megabytes 100
ASSUMETARGETDEFS
DYNAMICRESOLUTION
MAP oggadmin.bst_range_pub_tel_test, TARGET oggadmin.bst_range_pub_tel_test;
alter system set log_archive_dest_state_1=enable;
=============
配置manager进程
edit params mgr
port 7809
dynamicportlist 7815-7850
autorestart er *, retries 5, waitminutes 3
purgeoldextracts /oradata1/ogg/dirdat/*,usecheckpoints, minkeepdays 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
==========
source端配置extract进程和DATA PUMP进程
add extract ggtest,tranlog,begin now
add exttrail /oradata1/ogg/dirdat/tr, extract ggtest, megabytes 100
edit params ggtest
extract ggtest
USERID oggadmin, PASSWORD oggadmin#123,
EXTTRAIL /oradata1/ogg/dirdat/tr
TRANLOGOPTIONS DBLOGREADER, DBLOGREADER BUFSIZE 4194304, BUFSIZE 4194304
FETCHOPTIONS FETCHPKUPDATECOLS
NOCOMPRESSDELETES
DYNAMICRESOLUTION
table oggadmin.t_customer_tel_log_test;
=================
add extract ggpump,exttrailsource /oradata1/ogg/dirdat/tr
add rmttrail /oradata1/ogg/dirdat/td,extract ggpump,megabytes 100
edit param ggpump
extract ggpump
USERID oggadmin, PASSWORD oggadmin#123,
rmthost 10.6.241.76,mgrport 7809, compress
rmttrail /oradata1/ogg/dirdat/td
Dynamicresolution
numfiles 8000
table oggadmin.t_customer_tel_log_test;
==================
目标端
edit param ./GLOBALS
GGSCHEMA oggadmin
CHECKPOINTTABLE oggadmin.checkpointtable
add checkpointtable oggadmin.checkpointtable
==
add replicat reptest,exttrail /oradata1/ogg/dirdat/td,checkpointtable oggadmin.checkpointtable
edit param reptest
replicat reptest
USERID oggadmin, PASSWORD oggadmin#123,
ASSUMETARGETDEFS
REPERROR DEFAULT,DISCARD
DISCARDFILE /oradata1/ogg/dirrpt/reptest.dsc,append,megabytes 100
DYNAMICRESOLUTION
MAP oggadmin.t_customer_tel_log_test, TARGET oggadmin.t_customer_tel_log_test;
===================================================================目标库ogg=================================
create user oggadmin identified by oggadmin#123 default tablespace users ;
oggadmin.bst_range_pub_tel_test
source端配置extract进程和DATA PUMP进程
add extract extch,tranlog,begin now
add exttrail /oradata1/ogg/dirdat/ch/tr, extract extch, megabytes 100
edit params extch
extract extch
USERID oggadmin, PASSWORD oggadmin#123,
EXTTRAIL /oradata1/ogg/dirdat/ch/tr
TRANLOGOPTIONS DBLOGREADER, DBLOGREADER BUFSIZE 4194304, BUFSIZE 4194304
FETCHOPTIONS FETCHPKUPDATECOLS
NOCOMPRESSDELETES
DYNAMICRESOLUTION
table oggadmin.bst_range_pub_tel_test;
=================
add extract ppch,exttrailsource /oradata1/ogg/dirdat/ch/tr
add rmttrail /oradata1/ogg/dirdat/ch/td,extract ppch,megabytes 100
edit param ppch
extract ppch
USERID oggadmin, PASSWORD oggadmin#123,
rmthost 10.6.239.10,mgrport 7809, compress
rmttrail /oradata1/ogg/dirdat/ch/td
Dynamicresolution
numfiles 8000
table oggadmin.bst_range_pub_tel_test;
==================
目标端
edit param ./GLOBALS
GGSCHEMA oggadmin
CHECKPOINTTABLE oggadmin.checkpointtable
add checkpointtable oggadmin.checkpointtable
==
add replicat repch,exttrail /oradata1/ogg/dirdat/ch/td,checkpointtable oggadmin.checkpointtable
edit param repch
replicat repch
USERID oggadmin, PASSWORD oggadmin#123,
ASSUMETARGETDEFS
REPERROR DEFAULT,DISCARD
DISCARDFILE /oradata1/ogg/dirrpt/repch.dsc,append,megabytes 100
ASSUMETARGETDEFS
DYNAMICRESOLUTION
MAP oggadmin.bst_range_pub_tel_test, TARGET oggadmin.bst_range_pub_tel_test;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30592920/viewspace-2143903/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30592920/viewspace-2143903/