Oracle goldengate删除复制进程步骤
Oracle goldengate 删除复制进程步骤
如果我们误操作,添加了一个命名错误复制进程,这个时候如果我们想删掉,
重新新建复制进程,则删除步骤如下:
[:oracle]ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.26 Build 001
AIX 5L, ppc, 64bit (optimized), Oracle 11 on Mar 2 2011 21:38:45
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI () 1> add replicat rtest, exttrail /software/ggs/dirrpt/te , checkpointtable ggt.ckptfpfxdm
REPLICAT added.
GGSCI () 2> delete replicat rtest
ERROR: Could not delete DB checkpoint for REPLICAT RTEST (Database login required to delete database checkpoint).
GGSCI () 3> dblogin userid ggt,password ggt
Successfully logged into database.
GGSCI () 4> delete replicat rtest
Deleted REPLICAT RTEST.
注意一定要登录到dblogin到目标数据库,否则提示要删除checkpoint table