在OGG中跳過Oracle DB 長事務的命令 ~~~ GGSCI (hostdb2) 2> SEND EXTRACT extxxx , SKIPTRANS 10.40.1122351 THREAD 1 Sending SKIPTRANS request to EXTRACT EXTXXX ... Are you sure you sure you want to skip transaction [XID 10.40.1122351, Redo Thread 1, Start Time 2015-06-05:13:03:48, SCN 3035.1404832899 (13036630576259)]? (y/n)y Sending SKIPTRANS request to EXTRACT EXTXXX ... Transaction [XID 10.40.1122351, Redo Thread 1, Start Time 2015-06-05:13:03:48, SCN 3035.1404832899 (13036630576259)] skipped. GGSCI (hostdb2) 4> ~~~ 10.40.1122351這個長事務的來源： ~~~ GGSCI (hostdb2) 1> send extxxx, showtrans Sending SHOWTRANS request to EXTRACT EXTXXX ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 14727, SCN 3388.1470752302 (14552819951150), RBA 429154320 Redo Thread 2, Redo Log Sequence Number 10195, SCN 3388.1471271618 (14552820470466), RBA 327736336 ------------------------------------------------------------ XID: 7.8.447821 ------>這就是事務的id。 Items: 268257 ------->注意這個數字，當send extxxx, showtrans再次執行一遍時，該值在不斷減小，這說明extxxx進程在干活。 Extract: EXTXXX Redo Thread: 1 Start Time: 2015-11-24:02:00:13 SCN: 3388.1470752302 (14552819951150) Redo Seq: 14727 Redo RBA: 429154320 Status: Running --->>>>>>額外注意：Select * from gv$transaction where xidusn=7 and XIDSLOT =8 and XIDSQN =447821;居然查不到記錄。 --->>>>>>額外注意：死事務查詢（如下）也查詢不到死事務： --->>>>>> select ktuxeusn USN, ktuxeslt Slot, ktuxesqn Seq, ktuxesta State, ktuxesiz Undo --->>>>>> from x$ktuxe --->>>>>> where ktuxesta <> 'INACTIVE' and ktuxecfl like '%DEAD%' order by ktuxesiz asc; ------------------------------------------------------------ XID: 23.11.535573 Items: 0 Extract: EXTXXX Redo Thread: 2 Start Time: 2015-11-24:08:37:32 SCN: 3388.1475780146 (14552824978994) Redo Seq: 10215 Redo RBA: 189050896 Status: Running ~~~ 最后，有人會問,你這樣跳過事務，那復制就不完整了啊。其實，針對這一點，我認為復制還是完整的（即：數據復制是完整的） ~~~ 1. Select * from gv$transaction where xidusn=7 and XIDSLOT =8 and XIDSQN =447821;居然查不到記錄。 ~~~ 從這一點來說，2個db實例中均沒有此事務的記錄。 ---引出了另外一點，db實例中都沒有該事務，你用ogg命令的查詢為啥能查到？---我猜測是ogg的命令可能借助了OGG的BR。 ~~~ 2.如下命令的結果 GGSCI (hostdb2) 1> send extxxx, status Sending STATUS request to EXTRACT EXTXXX ... EXTRACT EXTXXX (PID 23683) Current status: Recovery complete: Processing data with empty data queue--->注意此處的空隊列。 Current read positions: Redo thread #: 1 Sequence #: 14736 RBA: 119375680 Timestamp: 2015-11-24 04:34:52.000000 SCN: 3388.1471781460 Redo thread #: 2 Sequence #: 10214 RBA: 381925240 Timestamp: 2015-11-24 05:00:17.000000 SCN: 3388.1471790456 Current write position: Sequence #: 268963 RBA: 5568905 Timestamp: 2015-11-26 09:20:12.756297 Extract Trail: /u02/ggs/dirdat/aa ~~~