Creating a reporting configuration with a data pump on the source system Source system
1>. configure and startup the manager process
GGSCI>edit params mgr
----configure manager process port number
PORT 7809
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS 2
----startup manager process
GGSCI>start mgr
2>. configure the primary Extract group
GGSCI>dblogin userid test,password test sysdba
GGSCI>ADD EXTRACT ext1,TRANGLOG,BEGIN NOW
GGSCI>ADD EXTTRAIL /u01/app/oracle/ggs/dirdat/rl EXTRACT ext1
GGSCI>edit params ext1
USERID test,PASSWORD test/
EXTTRAIL /u01/app/oracle/ggs/dirdat/rl
GETTRUNCATES
TABLE test.*;
3>. configure the data pump Extract group
GGSCI>ADD EXTRACT pump1,EXTTRAILSOURCE /u01/app/oracle/ggs/dirdat/rl,BEGIN NOW
GGSCI>ADD RMTTRAIL /u01/app/oracle GETTRUNCATES /ggs/dirdat/r1, EXTRACT pump1
GGSCI>edit params pump1
EXTRACT pump1
USERID test,PASSWORD test
RMTHOST 10.0.0.4,MGRPORT 7809
RMTRAIL /u01/app/oracle/ggs/dirdat/rl
PASSTHRU
GETTRUNCATES
TABLE test.*;
Target system:
1>. configure and startup the manager process
GGSCI>edit params mgr
----configure manager process port number
PORT 7809
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/rl* USECHECKPOINTS,MINKEEPHOURS 2
----startup manager process
GGSCI>start manager mgr
2>. create checkpoint table
----参数生效需要重新登录GGSCI
GGSCI>edit params ./GLOBALS
checkpointtable test.chpt
GGSCI>dblogin userid test,password test
GGSCI>ADD CHECKPOINTTABLE
3>. configure the Replicat group
-----create replicat group
GGSCI>ADD REPLICAT rep1, EXTTRAIL /u01/app/oracle/ggs/dirdat/rl ,BEGIN NOW
------configure replicat group
GGSCI>edit params rep1
REPLICAT rep1
USERID test,PASSWORD test
ASSUMETARGETDEFS
GETTRUNCATES
MAP test.*,TARGET test.*;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7721556/viewspace-707683/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7721556/viewspace-707683/