1、修改rba,checkpoint
  alter EXT_ALO,extseqno 17,extrba 9194144,thread 1
  alter EXT_ALO,extseqno 10,extrba 5740032,thread 2
2、修改recovery checkpoint
   alter EXT_ALO,ioextseqno 17,ioextrba 9193488,thread 1
  alter  EXT_ALO,ioextseqno 10,ioextrba 5739536,thread 2
3、info extract cust_ext, detail   --抽取进程的详细信息
4、info extract ext*, showch  --抽取进程的检查点信息,注意checkpoint和recovery checkpoint
5、INFO TRANDATA user_name.table_names  --表的补充日志
6、常用添加extract命令
  ggsci> add extract ext1, tranlog, begin now
  ggsci> add extract ext1, tranlog, begin now, threads 4
  ggsci> add extract ext1, tranlog, begin now, passive
  ggsci> add extract ext1, extseqno 111, begin now
  ggsci> add extract ext1, extrba 567890, begin 2012-02-02 12:00:00
  ggsci> add extract ext1, sourceistable
  ggsci> add extract ext1, exttrailsource /oracle/gg11/dirdat/hr   --data pump
  ggsci> add extract ext1, vam                                  -- VAM - Vendor Access Module
  ggsci> add extract ext1, vamtrailsource /ogg/dirdat/vt
  ggsci> add extract ext1, rmthost host123, mgrport 7810, rmtname fin
6、status
  ggsci> STATUS MANAGER    -- To determine whether or not the Manager process is running
 
  ggsci> STATUS EXTRACT group_name [, TASKS | ALLPROCESSES]   -- To determine whether or not Extract is running
  ggsci> status extract extr_hr
  ggsci> status extract ext*, tasks
  ggsci> status extract *ext*, allprocesses
 
  ggsci> STATUS REPLICAT group_name [, TASKS | ALLPROCESSES]  -- To determine whether or not Replicat is running
  ggsci> status replicat emp_rep
  ggsci> status replicat cust_rep, allprocesses
 
  ggsci> STATUS ER group_wildcard_specification   -- To check the status of multiple Extract and Replicat groups as a unit
  ggsci> status er *EX*
7、stats
  Reading Program Database management system Vacuum Pump The Word Find email address free
  ggsci> STATS EXTRACT group_name [, statistic] [, TABLE table] [, TOTALSONLY table_specification] [, REPORTFETCH | NOREPORTFETCH] [, REPORTRATE HR|MIN|SEC] [, ... ]  -- To display statistics for one or more Extract group
  ggsci> stats ext_hr
  ggsci> stats extract ext
  ggsci> stats extract ext2 reportrate sec
  ggsci> stats extract fin, total, daily
  ggsci> stats extract fin, total, hourly, table acct, reportrate min, reset, reportfetch
 
8、send
  ggsci> SEND MANAGER [CHILDSTATUS [DEBUG]] [GETPORTINFO [DETAIL]] [GETPURGEOLDEXTRACTS]   -- To retrieve the status of the active Manager process or to retrieve dynamic port information as configured in the Manager parameter file
  ggsci> send manager childstatus
  ggsci> send manager childstatus debug
  ggsci> send manager getportinfo
  ggsci> send manager getportinfo detail
  ggsci> send manager getpurgeoldextracts
  ggsci> SEND EXTRACT group_name, 
  { CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} | FORCESTOP | FORCETRANS id [THREAD n] [FORCE] | GETLAG | GETTCPSTATS | LOGEND | REPORT | ROLLOVER | SHOWTRANS [id] [THREAD n] [COUNT n] [DURATION duration_unit] [TABULAR] [FILE file_name [DETAIL]] | SKIPTRANS id [THREAD n] [FORCE] | STATUS | STOP | TLTRACE {DEBUG | OFF | level} [SIZELIMIT size] [DDLINCLUDE | DDL[ONLY]] [FILE] file_name | TRACE[2] {tracefile | OFF} | TRACEINIT | TRANLOGOPTIONS {PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS} | TRANLOGOPTIONS TRANSCLEANUPFREQUENCY minutes | VAMMESSAGE "Teradata_command" | VAMMESSAGE {ARSTATS | INCLUDELIST [filter] | EXCLUDELIST [filter]} | VAMMESSAGE OPENTRANS
  } -- To communicate with a running Extract process
  Teradata_command = {"control:terminate" | "control:suspend" | "control:resume" | "control:copy database.table"
  ggsci> send extract exthr status
  ggsci> send extract extr, getlag
  ggsci> send extract group_name tltrace file file_name ddlinclude
  ggsci> send extract fin, rollover
  ggsci> send extract fin  stop
  ggsci> send extract fin, vammessage control:suspend
  ggsci> send extract fin, tranlogoptions transcleanupfrequency 15
  ggsci> send extract fin, showtrans count 10
  ggsci> send extract fin, skiptrans 5.17.27634 thread 2
9、alter
  ggsci> ALTER EXTRACT group_name [, ADD_EXTRACT_attribute] [, THREAD number] [, ETROLLOVER]  -- To change the attributes of an Extract group, To increment a trail to the next file in the sequence
  ggsci> alter extract fin, begin 2012-02-16
  ggsci> alter extract fin, etrollover
  ggsci> alter extract fin, extseqno 26, extrba 338
  ggsci> alter extract accounts, thread 4, begin 2012-03-09
  ggsci> alter extract sales, lsn 1234:123:1
10、lag
  ggsci> LAG EXTRACT group_name    -- To determine a true lag time between Extract and the datasource
  ggsci> lag extract ext*
  ggsci> lag extract *

1、send rep2, NOHANDLECOLLISIONS  --send 命令动态取消HANDLECOLLISIONS
2、info replicat fin, showch --复制进程的检查点信息
3、info replicat emp_rep, detail  --复制进程的相应信息
4、info checkpointtable gg_owner.chkpt_table --检查点表信息
5、常用添加replicat进程命令
  ggsci> add replicat repl, exttrail C:\OGG10G\dirdat\lt
  ggsci> add replicat repl, exttrail /oracle/gg11/dirdat/lt, checkpointtable gg_owner.checkpoint
  ggsci> add replicat initload, specialrun
  ggsci> add replicat repl, exttrail /oracle/gg11/dirdat/lt, nodbcheckpoint
6、stats
  ggsci> STATS REPLICAT group_name [, statistic] [, TABLE table] [, TOTALSONLY table_specification] [, REPORTDETAIL | NOREPORTDETAIL] [, REPORTRATE HR|MIN|SEC] [, ... ]   -- To display statistics for one or more Replicat groups
  ggsci> stats rep_hr
  ggsci> stats replicat fin, total, table acct, reportrate hr, reset, noreportdetail
 
  ggsci> STATS ER group_wildcard_specification   -- To get statistics on multiple Extract and Replicat groups as a unit
  ggsci> stats er ext*
7、send
 
  ggsci> SEND REPLICAT group_name,
  { FORCESTOP | GETLAG | HANDLECOLLISIONS [table_specification] | NOHANDLECOLLISIONS [table_specification] | REPORT [HANDLECOLLISIONS [table_specification]] | STATUS | STOP | TRACE[2] [DDLINCLUDE | DDL[ONLY]] [FILE] file_name | TRACE[2] OFF | TRACEINIT
  }    -- To communicate with a starting or running Replicat process
  ggsci> send replicat fin, handlecollisions
  ggsci> send replicat fin, report handlecollisions fin_*
  ggsci> send replicat fin, getlag
 
  ggsci> SEND ER group_wildcard_specification   -- To send instructions to multiple Extract and Replicat groups as a unit
  ggsci> send er *ext
8、lag
  ggsci> LAG REPLICAT group_name   -- To determine a true lag time between Replicat and the trail
  ggsci> lag replicat myrepl
  ggsci> lag replicat *

1、INFO EXTTRAIL trail_name 
2、info exttrail e:\ogg\dirdat\ex --本地trail文件信息
3、INFO RMTTRAIL trail_name
4、info rmttrail d:\ogg\dirdat\ex --远程trail文件信息
5、常用添加trail 命令
  ggsci> ADD EXTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]   -- To create a trail for online processing on local system
  ggsci> add exttrail /oracle/gg11/dirdat/lt, extract s_extr
  ggsci> add exttrail C:\OGG10G\dirdat\et, extract emp_ext
  ggsci> add exttrail c:\ogg\dirdat\fi, extract fin, megabytes 30
 
  ggsci> ADD RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]   -- To create a trail for online processing on remote system
  ggsci> add rmttrail C:\OGG10G\dirdat\hr, extract extr
  ggsci> add rmttrail /u01/app/oracle/ogg/dirdat/ms, extract msextr
  ggsci> add rmttrail /u01/app/oracle/ogg/dirdat/my, extract mysql, megabytes 50
6、alter
  ggsci> ALTER EXTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n]   -- To change the attributes of a trail (on the local system)
  ggsci> alter exttrail c:\ogg\dirdat\aa, extract fin, megabytes 30
 
  ggsci> ALTER RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n]   -- To change the attributes of a trail (on a remote system)
  ggsci> alter rmttrail c:\ogg\dirdat\et, extract fin, megabytes 25