Shulou(Shulou.com)05/31 Report--

This article shares with you the content of a sample analysis of oracle goldengate maintenance. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. Configure an ogg environment with pump on the source side and trail on the target side

1.1 Parameter Fil

Extract process ett parameters:

EXTRACT ett

USERID system, PASSWORD oracle

EXTTRAIL. / dirdat/tr

TABLE gguser.huangliqiang, WHERE (ID = 100)

Data pump process dpp parameters:

EXTRACT dpp

USERID system, PASSWORD oracle

RMTHOST 192.168.1.29, MGRPORT 7809

RMTTRAIL. / dirdat/tr

TABLE gguser.huangliqiang

Target replicat process rpp:

REPLICAT rpp

USERID system, PASSWORD oracle

HANDLECOLLISIONS

ASSUMETARGETDEFS

DISCARDFILE. / dirrpt/RORAKK.DSC, PURGE

MAP gguser.huangliqiang, TARGET gguser.huangliqiang

1.2 add processes and trail files

Add extract ett,tranlog,begin now

Add exttrail. / dirdat/tr,extract ett

Add extract dpp,exttrailsource. / dirdat/tr

Add rmttrail. / dirdat/tr,extract dpp

Add replicat rpp,exttrail. / dirdat/tr, checkpointtable system.ggchkptable

two。 Filter

2.1 Line filtering in extract parameters (comparison symbol

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.