Explanation of a piece of Oracle GoldenGate (OGG) Transfer Process log (. rpt file), goldengate. rpt

Explanation of a piece of Oracle GoldenGate (OGG) Transfer Process log (. rpt file), goldengate. rpt

This article is original. For more information, see the source.

Note:

/U02/ggs/dirdat/sb is the name of the trail file formed by the source extraction process.

/U02/ggs/dirdat/tb is the file name of the trail file formed by the source transmission process to the target.

13:51:11 INFO OGG-01026 Rolling over remote file/u02/ggs/dirdat/tb001540. ---> This Rolling over is the transfer process is transmitting the trail file to the destination, the name of the trail file formed on the target end is tb001540 (of course, anyone familiar with OGG knows that there are also server processes on the target end, responsible for writing the trail files transmitted by the source transmission process to the target end. The server process is not described here) Switching to next trail file/u02/ggs/dirdat/sb005614 at 13:58:01 due to EOF, with current RBA 49999629 Opened trail file/u02/ggs/dirdat/sb005614 at 2014-08-01 13: 58: 01 Switching to next trail file/u02/ggs/dirdat/sb005615 at 14:04:37 due to EOF, with current RBA 49999885 Opened trail file/u02/ggs/dirdat/sb005615 at 2014-08-01 14: 04: 37 Switching to next trail file /U02/ggs/dirdat/sb005616 at 14:11:10 due to EOF, with current RBA 49999729 Opened trail file/u02/ggs/dirdat/sb005616 at 2014-08-01 14: 11: 10 Switching to next trail file/u02/ggs/dirdat/sb005617 at 14:18:09 due to EOF, with current RBA 49999971 Opened trail file/u02/ggs/dirdat/sb005617 at 14:18:09 ---> the above four groups of Switching to next trail files are the source trail files retrieved by the transmission process (sb005614 to sb0056) 17 ). Some may ask what to do with retrieval. In fact, OGG is flexible and flexible here. In a word, the extracted table may not all be transmitted, and the transmitted table may not all be applied.

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