1 ogg抓取进程只落地commit提交的数据。
2 抓取进程对于长事务进入缓存,但不落地。
3 BR永久长事务数据,就不需要再读取archiveog或者ORL文件。
OGG事务管理
GGSCI (t4-4-1) 10> info ext_a showch
GGSCI (t4-4-1) 10> send ext_a showtrans count 10
GGSCI (t4-4-1) 10>send extract ext_a , showtrans thread 1 count 10
Sending showtrans request to EXTRACT EXT_A ...
Oldest redo log file necessary to restart Extract is:
Redo Thread 1, Redo Log Sequence Number 855180, SCN 3006.768177673 (12911439869449), RBA 1222950416
------------------------------------------------------------
XID: 38.47.4028138
Items: 0
Extract: EXTMON_A
Redo Thread: 1
Start Time: 2019-10-01:05:47:17
SCN: 3006.768177673 (12911439869449)
Redo Seq: 855180
Redo RBA: 1222950416
Status: Running
Ggsci>SEND EXTRACT <进程名>, SKIPTRANS <5.17.27634> THREAD <2> //跳过交易
Ggsci>SEND EXTRACT <进程名>, FORCETRANS <5.17.27634> THREAD <1> //强制认为该交易已经提交
使脫脠脧sql脫戮盲询露脭娄脢脦状态隆拢
select t1.sid,
t1.serial#,
t1.program,
t1.status,
t1.event,
t1.client_info,
t2.sql_text
from v$transaction t, v$session t1, v$sql t2 --38.47.4028138
where t.xidusn || '.' || t.XIDSLOT || '.' || t.XIDSQN = '37.23.2998059'
and t.addr = t1.TADDR
and t1.sql_id = t2.sql_id(+)
[grid@gzrac01 ~]$