OGG杂记

add extract ext1, tranlog , begin now

add exttrail ./dirdat/e1, extract ext1

add extract pump1, exttrailsource ./dirdat/e1, begin now

add rmttrail ./dirdat/r1, extract pump1

add replicat rep1, exttrail ./dirdat/r1, checkpointtable oggadm.chpt_table   --为单个进程指定检查表

info all --看所有进程

info rep --看rep进程

info rep detail --看rep运行详细情况

--查看dat文件的操作

logdump

open  ./diedat/r1000000

ghdr on --显示头部

detail on

detail data

n   --看下一条数据

position 8587  pos rba --跳到某个rba

--更改复制进程到某个rba点

 alter replicat rep1,extseqno 100001 extrba 00

--只能跳过一个事务 

start rep1 , skiptransaction