New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Example 14: Auto Starting Extract & Replicat, More Manager Parameters

Manager parameter also can be used to define many other functions to manage.

For example if you want to start the Extract and Replicat Process automatically when a manager process start , keep the following line

AUTOSTART ER *

There are other options also available , retries and wait before retry and reset the minutes along with your restart.

AUTORESTART ER *, RETRIES 3, WAITMINUTES 10, RESETMINUTES 60

There are other certain options which can help you to manage goldengate effectively and important are,

BOOTDELAYMINUTES When ever a database host restarts , the goldengate manager wait until this many minutes to ensure OS completes start up and start GG then, Applicable only for windows.
DOWNREPORTMINUTES Displays the Status of Extract/Replicat process in Error Log, the frequency of showing such status can be regulated with this option. If you have very large error log file it can be difficult to read every and then so you can specify how frequent you want to see such status.
DOWNCRITICAL In the report , it shows the process status abended/normal shutdown
LAGCRITICALSECONDS How many seconds of LAG threshold before it publish to error log.
LAGCRITICAL Specifies a lag threshold that is considered critical and generates a warning to the error log.

Sample parameter file

.ggsci

edit params MGR

AUTOSTART ER *

AUTORESTART ER *, RETRIES 3, WAITMINUTES 10, RESETMINUTES 60

DOWNREPORTMINUTES 15

DOWNCRITICAL

LAGCRITICALSECONDS 10

LAGINFOMINUTES 0

LAGREPORTMINUTES 15