Oracle goldengate删除复制进程步骤

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:807

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

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】