HomeОбразованиеRelated VideosMore From: ORACLOUD

Oracle GoldenGate data replication

11 ratings | 481 views
#goldengate #oracle #replication #12c ==========хэрэгтэй коммандууд================= select log_mode from v$database; alter database add supplemental log data; add extract ext1, tranlog, begin now add exttrail /gg/dirdat/tr, extract ext1 edit params ext1 extract ext1 userid ggate, password oracle TRANLOGOPTIONS DBLOGREADER exttrail /dirdat/tr table ub.*; add extract pump1, exttrailub /gg/dirdat/tr , begin now add rmttrail /gg/dirdat/tr, extract pump1 edit params pump1 EXTRACT pump1 USERID ggate, PASSWORD oracle RMTHOST db2, MGRPORT 15002 RMTTRAIL /gg/dirdat/tr PASSTHRU table ub.*; ================darkhan=================== EDIT PARAMS ./GLOBALS CHECKPOINTTABLE darkhan.checkpoint add checkpointtable darkhan.checkpoint add replicat rep1, exttrail /gg/dirdat/tr, begin now, checkpointtable darkhan.checkpoint edit params rep1 REPLICAT rep1 ASSUMETARGETDEFS USERID darkhan, PASSWORD oracle map ub.*, target darkhan.*; Mongolian Oracle Database Administrators Community - www.batmunkh.net
Html code for embedding videos on your blog
Text Comments (1)
excuse me ur …. na na na :P

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.