Home Database Mysql Tutorial 对一段OracleGoldenGate(OGG)传输进程日志(.rpt文件)的解释

对一段OracleGoldenGate(OGG)传输进程日志(.rpt文件)的解释

Jun 07, 2016 pm 03:59 PM
ogg transmission process

本文为原创,转载请注明出处。 说明: /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/tb0

本文为原创,转载请注明出处。

说明:

/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 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 2014-08-01 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 2014-08-01 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 2014-08-01 14:18:09 due to EOF, with current RBA 49999971
Opened trail file /u02/ggs/dirdat/sb005617 at 2014-08-01 14:18:09
--->以上四组Switching to next trail file 就是传输进程在检索源头trail文件(sb005614到sb005617)。也许有人会问,还要检索干啥,其实,OGG灵活就灵活在这里,用一句话来概括:抽取的table未必都传输,传输的table未必都应用。
Copy after login
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 49999853
Opened trail file /u02/ggs/dirdat/sb005618 at 2014-08-01 14:25:42
Copy after login
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Explain what the explorer.exe process is Explain what the explorer.exe process is Feb 18, 2024 pm 12:11 PM

What process is explorer.exe? When we use the Windows operating system, we often hear the term "explorer.exe". So, are you curious about what this process is? In this article, we will explain in detail what process explorer.exe is and its functions and effects. First of all, explorer.exe is a key process of the Windows operating system. It is responsible for managing and controlling Windows Explorer (Window

What is the process of com surrogate? What is the process of com surrogate? Sep 14, 2022 pm 02:56 PM

"com surrogate" is the process of "C:\Windows\System32\dllhost.exe"; when this process occurs, it usually means that the "COM+" component stops working. This process takes up a lot of space and even does not respond directly. This is because the computer is loading the file icon. Sometimes a problem occurs, causing the computer to become stuck. You can solve the stuck problem in the computer properties settings.

What kind of process is ccsvchst.exe? What kind of process is ccsvchst.exe? Feb 19, 2024 pm 11:33 PM

ccsvchst.exe is a common process file that is part of the Symantec Endpoint Protection (SEP) software, and SEP is an endpoint protection solution developed by the well-known network security company Symantec. As part of the software, ccsvchst.exe is responsible for managing and monitoring SEP-related processes. First, let’s take a look at SymantecEndpointProtection(

How to properly kill zombie processes in Linux How to properly kill zombie processes in Linux Feb 19, 2024 am 10:40 AM

In Linux systems, zombie processes are special processes that have been terminated but still remain in the system. Although zombie processes do not consume many resources, if there are too many, they may cause system resource exhaustion. This article will introduce how to correctly remove zombie processes to ensure the normal operation of the system. 1Linux zombie process After the child process completes its task, if the parent process does not check the status in time, the child process will become a zombie process. The child process is waiting for confirmation from the parent process, and the system will not recycle it until it is completed. Otherwise, the zombie process will continue to hang in the system. To check whether there are zombie processes in the system, you can run the command top to view all running processes and possible zombie processes. The result of the ‘top’ command can be seen from the figure above in Linux.

Detailed explanation of Linux process priority adjustment method Detailed explanation of Linux process priority adjustment method Mar 15, 2024 am 08:39 AM

Detailed explanation of the Linux process priority adjustment method. In the Linux system, the priority of a process determines its execution order and resource allocation in the system. Reasonably adjusting the priority of the process can improve the performance and efficiency of the system. This article will introduce in detail how to adjust the priority of the process in Linux and provide specific code examples. 1. Overview of process priority In the Linux system, each process has a priority associated with it. The priority range is generally -20 to 19, where -20 represents the highest priority and 19 represents

How to stop Task Manager process updates and kill tasks more easily in Windows 11 How to stop Task Manager process updates and kill tasks more easily in Windows 11 Aug 20, 2023 am 11:05 AM

How to Pause Task Manager Process Updates in Windows 11 and Windows 10 Press CTRL+Window Key+Delete to open Task Manager. By default, Task Manager will open the Processes window. As you can see here, all the apps are endlessly moving around and it can be hard to point them down when you want to select them. So, press CTRL and hold it, this will pause the task manager. You can still select apps and even scroll down, but you must hold down the CTRL button at all times.

Why do processes in Linux sleep? Why do processes in Linux sleep? Mar 20, 2024 pm 02:09 PM

Why do processes in Linux sleep? In the Linux operating system, a process can become dormant due to a number of different reasons and conditions. When a process is in a dormant state, it means that the process is temporarily suspended and cannot continue execution until certain conditions are met before it can be awakened to continue execution. Next, we will introduce in detail several common situations when a process enters hibernation in Linux, and illustrate them with specific code examples. Waiting for I/O to complete: When a process initiates an I/O operation (such as reading

How to find the parent process ID (PPID) in Linux How to find the parent process ID (PPID) in Linux Mar 09, 2024 am 08:01 AM

In the Linux operating system, each running program is a process, and each process has a unique process identifier (PID). Similarly, each process will have a parent process, which is the process that created it. The identifier of the parent process is called the parent process ID (PPID). In this article, we will explore how to find the ID of a parent process in a Linux system and introduce some effective commands and tools to help you get detailed information about the relationship between processes. Basic commands to find parent process ID First, I will briefly introduce you to a few basic commands that can be used to view all processes running in the system and their parent process ID. Use the ps command to view process information. The ps command is a powerful tool that is used to report

See all articles