goldengate 刪除複製程式步驟

paulyibinyi發表於2011-08-30
Go
      如果我們誤操作，新增了一個命名錯誤複製程式，這個時候如果我們想刪掉，
 
重新新建複製程式，則刪除步驟如下：
 
 
[: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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-706209/，如需轉載，請註明出處，否則將追究法律責任。

相關文章