Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ An Example of GoldenGate Extract Process Hang Problem Solving     - Linux RPM (Linux)

- C # using the HttpClient Note: Preheat the long connection (Programming)

- Linux Nginx installation and configuration instructions (Server)

- Advanced Linux security settings (Linux)

- Python 2.7.9 Installation on Linux CentOS 6.6 (Linux)

- Oracle lag () and lpad () function (Database)

- HttpClient Tutorial (Programming)

- C / C ++ various data types Conversion Summary (Programming)

- Three easy open source firewall on the Linux platform (Linux)

- Ten SCP transfer command example (Linux)

- MongoDB uses aggregate, group, match mysql achieve in having (count (1)> 1) features (Database)

- How to create a someone project on github (Linux)

- ImportTsv-HBase data import tool (Database)

- Performance Diagnosis of 60,000 milliseconds for Linux (Linux)

- Unable to start the network after restart clone a virtual machine (Linux)

- Oracle 12C RAC optimizer_adaptive_features cause of data into overtime (Database)

- Use virt-manager to create and manage virtual machines (Linux)

- Several reasons MySQL garbled (Database)

- Linux command Detailed chpasswd bulk edit user password (Linux)

- Python calls the API interface in several ways (Programming)

 
         
  An Example of GoldenGate Extract Process Hang Problem Solving
     
  Add Date : 2017-08-31      
         
       
         
  Has been running the normal extract process suddenly hang live, at first suspected is not found due to archiving, but a careful examination of the next, extract the required archives are still, but the log did not report any wrong. But will extract the process stopped, but also normal, without any mistakes or warning:

// ggserr.log
2015-05-25 11:03:27 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, elis.prm: Positioning to (Thread 1) Sequence 5824, RBA 290544656, SCN 1415.2504802626.
2005-05-25 11:03:27 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, elis.prm: Positioned to (Thread 1) Sequence 5824, RBA 290544656, SCN 1415.2504802626, May 20, 2015 4:50:25 PM.
2015-05-25 11:03:27 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, elis.prm: Positioning to (Thread 2) Sequence 4798, RBA 18781712, SCN 1415.2504799356.
2005-05-25 11:03:27 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, elis.prm: Positioned to (Thread 2) Sequence 4798, RBA 18781712, SCN 1415.2504799356, May 20, 2015 4:50:19 PM.
2015-05-25 11:03:27 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, elis.prm: EXTRACT ELIS started.

// extract rpt file of the process
2015-05-25 11:03:27 INFO OGG-00546 Default thread stack size: 196608.

2015-05-25 11:03:27 INFO OGG-00547 Increasing thread stack size from 196608 to 1048576.

2015-05-25 11:03:27 INFO OGG-01513 Positioning to (Thread 1) Sequence 5824, RBA 290544656, SCN 1415.2504802626.

2015-05-25 11:03:27 INFO OGG-01516 Positioned to (Thread 1) Sequence 5824, RBA 290544656, SCN 1415.2504802626, May 20, 2015 4:50:25 PM.

2015-05-25 11:03:27 INFO OGG-01513 Positioning to (Thread 2) Sequence 4798, RBA 18781712, SCN 1415.2504799356.

2015-05-25 11:03:27 INFO OGG-01516 Positioned to (Thread 2) Sequence 4798, RBA 18781712, SCN 1415.2504799356, May 20, 2015 4:50:19 PM.

2015-05-25 11:03:27 INFO OGG-01517 Position of first record processed for Thread 1, Sequence 5824, RBA 290544656, SCN 1415.2504802623, May 20, 2015 4:50:25 PM.

2015-05-25 11:03:27 INFO OGG-01644 BOUNDED RECOVERY: COMPLETE: for object pool 1: p33619994_Redo Thread 1 at SeqNo: 5824, RBA: 290545168, SCN: 1415.2504802626 (6079883526466), Thread:

2015-05-25 11:03:27 INFO OGG-01055 Recovery initialization completed for target file / ogg / ggate / data / dirext / lis / ea002534, at RBA 1109.

2015-05-25 11:03:27 INFO OGG-01478 Output file / ogg / ggate / data / dirext / lis / ea is using format RELEASE 11.2.

2015-05-25 11:03:27 INFO OGG-01517 Position of first record processed for Thread 2, Sequence 4798, RBA 18781712, SCN 1415.2504799356, May 20, 2015 4:50:19 PM.

2015-05-25 11:03:27 INFO OGG-01026 Rolling over remote file / ogg / ggate / data / dirext / lis / ea002534.

2015-05-25 11:03:27 INFO OGG-01053 Recovery completed for target file / ogg / ggate / data / dirext / lis / ea002535, at RBA 1109.

2015-05-25 11:03:27 INFO OGG-01057 Recovery completed for all targets.
From the log, extract process is no problem, but the extract process is actually not running properly:


GGSCI (hxddlis01) 8> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
JAGENT RUNNING
EXTRACT RUNNING ELIS 96:14:58 00:00:04
EXTRACT RUNNING PL2IS 00:00:00 00:00:00
EXTRACT RUNNING PLIS 00:00:00 00:00:09
Extract the process of growing lag, and the trail file is no longer growing. This is really people confused. Let's take a look at the current system operating environment:


GoldenGate: 11.2.1.0.27
Database: 11.2.0.3 Two-node RAC with ASM
OS: AIX 6.1
Then search Oracle Support to find an article 1432994.1, and the situation is somewhat similar. In our environment is the use of DBLOGREADER, but the difference is DBLOGREADERBUFSIZE has been configured to 1M:


...
TRANLOGOPTIONS BUFSIZE 1048576
TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE 1048576
--TRANLOGOPTIONS _NOREADAHEAD ANY
EXTTRAIL / ogg / ggate / data / dirext / lis / ea
...
This is the maximum configuration under AIX. Is the value is too big reason? So try to change the value of the 512K:


...
TRANLOGOPTIONS BUFSIZE 1048576
TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE 524288
--TRANLOGOPTIONS _NOREADAHEAD ANY
EXTTRAIL / ogg / ggate / data / dirext / lis / ea
...
Then restart the extract process, the result is normal. Estimated use DBLOGREADER still have a lot of bugs.
     
         
       
         
  More:      
 
- Linux network security probing tools Hping2 (Linux)
- map and hash_map STL containers (Programming)
- Python 2.7 installed on CentOS 6.5 (Linux)
- Iptables use examples (Linux)
- You really do need to know a variety of programming languages (Programming)
- Ubuntu How to mount iso file (Linux)
- Vim useful plugin: EasyGrep (Linux)
- Nmcli based network management command-line tool (Linux)
- Linux System Getting Started Learning: From VirtualBox from the client host access NAT (Linux)
- 14 useful example Linux Sort command (Linux)
- mydumper installation error process (Database)
- Oracle to start to solve the error ORA-27102 (Database)
- to compile FFmpeg In Ubuntu (Linux)
- Linux Firewall IPCop Profile (Linux)
- C language binary tree (Programming)
- C ++ type conversion and RTTI (Programming)
- How to view the Linux graphics hardware information (Linux)
- Analysis of Java reflection mechanism (Programming)
- Setting CentOS firewall open port (Linux)
- Linux virtual machine settings network, hostname ssh access (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.