溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

快速?gòu)?qiáng)制kill goldengate異常進(jìn)程

發(fā)布時(shí)間:2020-07-22 13:36:07 來(lái)源:網(wǎng)絡(luò) 閱讀:663 作者:春秋小記 欄目:關(guān)系型數(shù)據(jù)庫(kù)

goldengate在遇到大的事務(wù)或者異常時(shí),使用stop 無(wú)法正常關(guān)閉進(jìn)程,遇到這個(gè)問(wèn)題的時(shí)候很是頭疼,于是help一下,發(fā)現(xiàn)兩個(gè)大殺器,從此再也不用擔(dān)心stop不掉進(jìn)程了,如果是遇到大的事務(wù)還是建議stop后等待事務(wù)提交或者回滾正常關(guān)閉,但是遇到一些異常時(shí),可以使用如下kill掉進(jìn)程:

GGSCI>KILL REPLICAT group_name
GGSCI>KILL EXTRACT finance

正常停掉進(jìn)程:
GGSCI>stop REPLICAT group_name
GGSCI>stop EXTRACT finance

下面是兩個(gè)命令的詳細(xì)說(shuō)明

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

向AI問(wèn)一下細(xì)節(jié)

免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI