Goldengate在遇到大的事务或者异常时,使用stop 无法正常关闭进程,遇到这个问题的时候很是头疼,于是help一下,发现两个大杀器,从此再也不用担心stop不掉进程了,如果是遇到大的事务还是建议st
Goldengate在遇到大的事务或者异常时,使用stop 无法正常关闭进程,遇到这个问题的时候很是头疼,于是help一下,发现两个大杀器,从此再也不用担心stop不掉进程了,如果是遇到大的事务还是建议stop后等待事务提交或者回滚正常关闭,但是遇到一些异常时,可以使用如下kill掉进程:
GGSCI>KILL REPLICAT group_name
GGSCI>KILL EXTRACT finance
正常停掉进程:
GGSCI>stop REPLICAT group_name
GGSCI>stop EXTRACT finance
下面是两个命令的详细说明
GGSCI> help kill replicat
Use KILL REPLICAT to kill a Replicat process. Killing a process leaves the
most recent checkpoint in place, and the current transaction is rolled back
by the database, guaranteeing that no data is lost when the process is
restarted. The Manager process will not attempt to restart a killed Replicat
process. Use this command only if Replicat cannot be stopped gracefully with
the STOP REPLICAT command.
Syntax
KILL REPLICAT group_name
group_name
The name of a Replicat group or a wildcard () to specify multiple groups.
For example, T kills all Replicat processes whose group names begin with T.
Example
KILL REPLICAT finance
GGSCI > help kill extract
Use KILL EXTRACT to kill an Extract process running in regular or PASSIVE mode.
Use this command only if a process cannot be stopped gracefully with the STOP
EXTRACT command. The Manager process will not attempt to restart a killed
Extract process.
Syntax
KILL EXTRACT group_name
group_name
The name of an Extract group or a wildcard () to specify multiple groups.
For example, T kills all Extract processes whose group names start with T.
Example
KILL EXTRACT finance
--结束END--
本文标题: 快速强制kill goldengate异常进程
本文链接: https://lsjlt.com/news/43039.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0