??GoldenGate??Manager??
- by Liu Maclean(???)
???????OGG?????????????MGR(Manager)???????,????????./dirprm/mgr.prm????
????????manager?????:
ggsci > edit params mgr
??ggsci edit params???????,???????????? OGG??????????????????????? ???mgr.prm????,??????./dirprm??OGG????????
???Manager?????????,?????????????????????
????????????????,??????????????????????????????,????????????
PORT 7809
–??MGR?PORT????????,????????TCP?????,?????????????7809??????????
DYNAMICPORTLIST 9101 – 9356DYNAMICPORTSREASSIGNDELAY 5
–???????????source????????,??????target?????????
PURGEOLDEXTRACTS ./dirdat/*, usecheckpoints, minkeephours 96
Manager????trail?????????,minkeephours 96????96????4???trail
LAGINFOSECONDS 15LAGCRITICALMINUTES 2
??2??????LAG REPORT?????
BOOTDELAYMINUTES 3
??BOOTDELAYMINUTES??windows??,??Windows??3????BOOT OGG MGR
AUTOSTART ER *
AUTOSTART ???MGR????????EXTRACT?REPLICAT
AutoRestart ER *, WaitMinutes 5, Retries 3
AUTORESTART ?????????OGG??,??????????
PurgeMarkerHistory MinKeepDays 3, MaxKeepDays 7, FrequencyMinutes 120
??PurgeMarkerHistory?????DDL??????
CHECKMINUTES 10
CHECKMINUTES ??? MGR????????,?????10????
DOWNCRITICAL
?????OGG???abend??????????,?????DOWNCRITICAL??,???????
??Manager?????????,???????????,manager?????????
OGG??????Manager????????????Extract?Replicat?Manager??????,??Manager????????Manager????,????????????????,Refresh???MGR??????????
??????MGR PARAMS
GGSCI (XIANGBLI-CN) 2> view params mgr
Port 7809
UserId goldengate, Password goldengate
CheckMinutes 10PurgeOldExtracts ./dirdat/*, UseCheckpoints, MinKeepHours 96PurgeMarkerHistory MinKeepDays 3, MaxKeepDays 7, FrequencyMinutes 120AutoRestart ER *, WaitMinutes 5, Retries 3LagInfoMinutes 0LagReportMinutes 10
GGSCI (XIANGBLI-CN) 4> start mgr
Manager started.
