Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ An Example of GoldenGate Extract Process Hang Problem Solving     - Linux dd command make U disk boot disk (Linux)

- Let Git variety of colors and custom log format output (Linux)

- About Linux operating system security (Linux)

- iTerm - let your command line can also be colorful (Linux)

- CentOS 6.4 (64bit) install Python 2.7.5 (Linux)

- Ubuntu download install and configure Plank Dock (Linux)

- Ubuntu Linux to create and increase the Swap partition tutorial (Linux)

- Install NetBeans IDE 8.0 on Ubuntu, Linux Mint, Elementary OS, and Debian (Linux)

- Seven kinds of NIC binding mode Detail (Linux)

- CoreOS quick installation to get started on a PC (Linux)

- Linux security configuration (Linux)

- IIS virtual host of safety knowledge (Linux)

- How to convert images, audio and video formats on Ubuntu (Linux)

- 22 Port weak passwords and SSH connection program of the Linux server (Linux)

- Vim useful plugin: vundle (Linux)

- Analysis: Little Notebook facing a major security threat secure online (Linux)

- Transfer MySQL database to MariaDB (Database)

- Java Prototype Pattern (Programming)

- Linux server operating system security configuration (Linux)

- PHP 7.0 Upgrade Notes (Linux)

 
         
  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:      
 
- HTTP and HTTPS request response process difference (Linux)
- Android Notification (Programming)
- Use DB2 federated access Oracle (Database)
- Ubuntu 12.04 64bit Install Source Insight 3.5 and create desktop icons (Linux)
- To teach you a trick to find the real IP address (Linux)
- Installation Elementary OS Freya to do some settings (Linux)
- Schema snapshot rollback (Database)
- Automatic and Manual Proxy Settings Switch GNOME Shell Extension Proxy Switcher Recommend (Linux)
- Docker study notes (Server)
- RHEL5 / 6 Installation Notes (Linux)
- Linux system monitoring, top command of the diagnostic tool Detailed (Linux)
- Linux Bash share tips for getting started (Linux)
- SELinux multi-level security (Linux)
- The Java development environment to build under Ubuntu 14.04 (Linux)
- CentOS 6.5 using Virtualenv under development environment to build Python3 (Linux)
- Vim copy and paste register (Linux)
- SUSE Linux network configuration and firewall configuration (Linux)
- PHP generates a random password several ways (Programming)
- Several SQL Server data migration / Export Import Practice (Database)
- Linux System Getting Started Learning: Disable HTTP forwarding wget in (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.