Monday, November 6, 2017

step by step to stop golden gate process

Here is the step by step process to stop the golden gate process

Source side:
1.stop the application services
2.check if any records to be send
GGSCI>send extract <ext_name>,getlag This should  return "no  rows at EOF"

3.stop all extracts
GGSCI> stop extract <extract_name> or stop extract  * (if you have many extract this command will be helpful to stop extract)
4.stop the mgr process
GGSCI>stop mgr
5.make sure all Process stopped at source server
GGSCI>info all
6.stop the database

Target side
1.check if any replicat writing to database
2.GGSCI>send replicat <replicat_name>,getlag this should return  "At EOF, no more records to process."
3.stop the replicat
GGSCI> stop replicat <replicat_name> or stop replicat  * (if you have many replicat this command will be helpful to stop replicat)

4.stop the manager process
GGSCI>stop mgr
5.make sure all Process stopped at  target  server
GGSCI>info all
6.stop the database

No comments:

Post a Comment