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
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