對一段Oracle GoldenGate （OGG） 傳輸進程日誌（.rpt檔案）的解釋

標籤：goldengate   datapump   

本文為原創，轉載請註明出處。

說明：

/u02/ggs/dirdat/sb為源頭抽取進程形成的trail檔案名稱

/u02/ggs/dirdat/tb為源頭傳輸進程往目的端傳輸，在目的端形成的trail檔案名稱。

2014-08-01 13:51:11  INFO    OGG-01026  Rolling over remote file /u02/ggs/dirdat/tb001540.--->這個Rolling over 就是傳輸進程正在向目的端傳輸trail檔案，在目的端形成的trail檔案名稱為tb001540（當然，熟悉OGG的人都知道，在目的端上還有server進程，負責在目的端寫入源頭傳輸進程傳輸過來的trail檔案。這裡不描述server進程）Switching to next trail file /u02/ggs/dirdat/sb005614 at 2014-08-01 13:58:01 due to EOF, with current RBA 49999629Opened trail file /u02/ggs/dirdat/sb005614 at 2014-08-01 13:58:01Switching to next trail file /u02/ggs/dirdat/sb005615 at 2014-08-01 14:04:37 due to EOF, with current RBA 49999885Opened trail file /u02/ggs/dirdat/sb005615 at 2014-08-01 14:04:37Switching to next trail file /u02/ggs/dirdat/sb005616 at 2014-08-01 14:11:10 due to EOF, with current RBA 49999729Opened trail file /u02/ggs/dirdat/sb005616 at 2014-08-01 14:11:10Switching to next trail file /u02/ggs/dirdat/sb005617 at 2014-08-01 14:18:09 due to EOF, with current RBA 49999971Opened trail file /u02/ggs/dirdat/sb005617 at 2014-08-01 14:18:09--->以上四組Switching to next trail file 就是傳輸進程在檢索源頭trail檔案（sb005614到sb005617）。也許有人會問，還要檢索幹啥，其實，OGG靈活就靈活在這裡，用一句話來概括：抽取的table未必都傳輸，傳輸的table未必都應用。

2014-08-01 14:24:46  INFO    OGG-01026  Rolling over remote file /u02/ggs/dirdat/tb001541.Switching to next trail file /u02/ggs/dirdat/sb005618 at 2014-08-01 14:25:42 due to EOF, with current RBA 49999853Opened trail file /u02/ggs/dirdat/sb005618 at 2014-08-01 14:25:42