快速强制killgoldengate异常进程-创新互联

goldengate在遇到大的事务或者异常时,使用stop 无法正常关闭进程,遇到这个问题的时候很是头疼,于是help一下,发现两个大杀器,从此再也不用担心stop不掉进程了,如果是遇到大的事务还是建议stop后等待事务提交或者回滚正常关闭,但是遇到一些异常时,可以使用如下kill掉进程:

创新互联主要从事网站设计、网站制作、网页设计、企业做网站、公司建网站等业务。立足成都服务宜都,10多年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:13518219792

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

另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。


网站栏目:快速强制killgoldengate异常进程-创新互联
链接分享:http://cdiso.cn/article/coosdj.html

其他资讯