Ensure that you run it in your test environment before using. Login to GGSCI At EOF, no more records to process: This means there is no lag. Lets clarify, that these parameters affect the Extract and Replicat processes. Learn how your comment data is processed. Process ID 31578 Golden Gate User : OGGADMIN Also, we use the TRANLOGOPTIONS EXCLUDEUSER OGGADM1 command to exclude transactions in the extract process if the listed user performs DML statements.

The following virtualized instances are built on the Nitro System and are recommended for GoldenGate hubs: C5, M5, R5, R5b, T3 and z1d. We can also use the GGSCI command VIEW GGSEVT as well. In this post, we created an active/passive GoldenGate hub environment. Amazon Inspector is an automated security assessment service that helps improve the security and compliance of applications deployed on AWS. Flashback Restore on Two Node RAC Servers, Oracle to Oracle GoldenGate Unidirectional Replication, MySQL to Oracle Heterogeneous Replication, Oracle to MySQL Heterogeneous Replication, Usage of HandleCollisions and No HandleCollisions, IgnoreDelete and IgnoreUpdate parameters in GG, Add new table to existing GoldenGate Replication, https://www.linkedin.com/company/ktexperts/, How to Transfer EC2 Instance to another AWS account in AWS, https://www.youtube.com/watch?v=kzqFBMFlzRI, Controlfile Multiplexing and De-Multiplexing In Oracle12c, Installation and Configuration of GoldenGate 19C on Oracle RAC, 12c NON-CONTAINER DATABASE TO 19c PLUGGABLE DATABASE, Shell script to alert us when specified background process exceeds limit. He works in the Worldwide Public Sector (WWPS) organization. Trending is based off of the highest score sort and falls back to it if no posts are trending. You can determine GoldenGate latency via the Oracle database (GV$% views) or via GGSCI. How APIs can take the pain out of legacy system headaches (Ep. For this reason rethink your archive log retention policy to prevent unnecessary restores. Transfer dump to target server, 11. In addition to this, the extract is executed in a source system or in a descending database or, if preferred, in both of them. If the minimum memory requirement for GoldenGate is not met, when a GoldenGate process starts, the process abends and errors may not be logged. High availability and business continuity. Stop the first GoldenGate EC2 instance (GG1) via the, Issue additional DML statements (inserts, updates, deletes) against the. After performing an assessment, Amazon Inspector produces a detailed list of security findings prioritized by level of severity. Share your knowledge.

Validate the DML statements in Steps 7 and 8 are synchronized in both databases. ALTER TABLE SOURCE.DASANI ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS; select * from dba_directories where DIRECTORY_NAME='DATA_PUMP_DIR'; expdp \'/ as sysdba\' directory=data_pump_dir dumpfile=source_dasani.dmp logfile=source_dasani.log tables=source.dasani flashback_scn=, . SCN 1.3015880562 (7310847858), Trail Name Seqno RBA Max MB Trail Type, /u01/app/oracle/product/12.1.2/oggcore_1/dirdat/l1 0 29590434 100 EXTTRAIL. You can see from this output that Golden Gate is reading from the redo log sequence number 111888. If youhave 10 records inserted into the source table but only 9 in target, there must be something wrong. A value of zero (0) causes a message to be forced to the specified frequency, with the parameters LAGREPORTMINUTES or LAGREPORTHOURS . Data in transit should also be encrypted to the RDS for Oracle instances. To get only only statistics from one table use, GGSCI (source server) 12> stats extvmed1 totalsonly VMEDDEV.TABLENAME, To get an overall summary use the following command. Now, to determine a threshold of delay, We must use the parameters LAGINFOSECONDS , LAFINFOMINUTES or, , LAGINFOHPURS . He is focused on migrating Oracle workloads to AWS. Of course, one of the things that Pandora FMS can control is the hard disks of your computers. There're differences between adminclient and ggsci, you may take a look. It is very important to keep in mind that the INFO command returns delay statistics. In this post, we show you how to configure a high availability GoldenGate environment to replicate data between two Amazon Relational Database Service (Amazon RDS) for Oracle instances. Sequence #: 0 For more information, see Configuring Conflict Detection and Resolution. You should set up three inbound rules for the EC2 instance. For security purposes, make sure the HOSM (execution) role used is following the least privilege design. Capture current SCN

By using the information commands in GGSCI: To see and analyse the processing information, use GGSCI. You can use the following OBEY file to start the bi-directional replication processes on the GoldenGate hub. Required fields are marked *. FROM V$LOGFILE A, V$LOG B Change), You are commenting using your Twitter account. We suggest only giving access to PutLogEvents to the EC2 instances. Map SOURCE.DASANI, target TARGET.DASANI, FILTER ( @GETENV('TRANSACTION', 'CSN') > 2298283); Map SOURCE.DASANI, target TARGET.DASANI, FILTER ( @GETENV('TRANSACTION', 'CSN') > 2298283); <-----. Golden Gate keeps its own sequence number as you can see the trail file is in sequence 0. Do not hesitate to send us your queries. To use the Oracle Secure Sockets Layer (SSL) option, add the Oracle SSL option to the option group associated with the Oracle instance. Find more information here: https://pandorafms.org. B.STATUS, For a static extraction of data records from a database and the loading of those records into a different database. GoldenGate knows which files were processed and trail files that have not been processed will not be purged. The higher level gg directory cant be symbolically linked. Click here to return to Amazon Web Services homepage, Amazon Relational Database Service (Amazon RDS) for Oracle, Oracle GoldenGate supports many different databases, create the Amazon RDS for Oracle instances, GoldenGate Software Command Interface (GGSCI), connect to the Amazon RDS for Oracle instance, GoldenGate automatic conflict detection and resolution, Configuring Conflict Detection and Resolution, Amazon Quantum Ledger Database (Amazon QLDB), Replicate between an on-premises instance and RDS instance, Replicate between an on-premises instance and EC2-hosted instance, Replicate between an EC2-hosted instance and RDS instance, Replicate between two EC2-hosted instances, The GoldenGate manager process consumes at least 75 MB of memory, Each GoldenGate extract process consumes at least 550 MB of memory, Each GoldenGate replicat process consumes at least 110 MB of memory. Find the run status of a particular process. Export Table using FLASHBACK_SCN All rights reserved. sequence# Oracle is processing. Create the first replicat parameter file for the first RDS for Oracle instance. In addition to this, in Pandora FMS you will be able to find valuable information on server monitoring. /oralogs/redo02.log111888 CURRENT NO Extract Trail: /u01/app/oracle/product/12.1.2/oggcore_1/dirdat/l1, Checking the Current Oracle Online Redo Log. How to check Golden Gate Lag or Syncing status? This post focuses on creating a high availability, bi-directional GoldenGate hub environment running on Amazon Elastic Compute Cloud (Amazon EC2) to replicate data between two RDS for Oracle instances. The info all GGSCI command gives us a good overview of the Golden Gates processes performance. In microservices architecture it shows graphical interface and graphical overview of OGG Performance. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Enter your email address to follow this blog and receive notifications of new posts by email. The Golden Gatestats command lists all the tables that have transactions. You can get the same information from the following command, GGSCI (source server) 13> Send extract extvmed1 status, Sending STATUS request to EXTRACT EXTVMED1 , EXTRACT EXTVMED1 (PID 31578) https://lnkd.in/gC7pfn2 FROM V$ARCHIVED_LOG We recommend using a GoldenGate credential store as an alternative to storing usernames and passwords in plain text parameter files. Verify Amazon EFS is mounted on the first GoldenGate EC2 instance (GG1). Amazon EFS file systems are elastic, and automatically grow and shrink as you add and remove files. If GoldenGate is not started within a specific period, the trail files that have not been fully processed will still reside in Amazon EFS. If the result of this command is 0, GoldenGate isnt running on the EC2 instance. Thanks for contributing an answer to Stack Overflow! Target Schema : TARGET. The symbolic links must only be created for the dir* directories shown in the preceding screenshot. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. 1.Information on all GoldenGate processes running on a system, 2. WhatsApp : +65-94693551 It is a OGG Management pack product and a separate licensed product. While every reasonable effort is made to ensure that the information provided on this blog is accurate, no guarantees for the currency or accuracy of information are made. Also alerts can be sent to stakeholders if the lag in Goldengate environments goes beyond agreed threshhold. Change). Asking for help, clarification, or responding to other answers. The following steps will briefly discuss the different commands we can use to monitor the GoldenGate environment and get statistics and reports on various This page consists of all the well-developed articles of the Technologies. Amazon EFS is required for this solution. Issue multiple DML statements (inserts, updates, deletes) against the hr.jobcode table on database two: Validate all modifications were properly synchronized between the databases. In this article we will discuss about how to monitor Oracle Goldengate environment. The GoldenGate admin user should have been created while installing Oracle GoldenGate. Additionally, the security group listed on the Amazon EFS Network tab should point to the security group of the GoldenGate EC2 instances. Current generation instance types, such as instances built on the AWS Nitro System, support hardware virtual machines (HVM). imported "TARGET". You can review these findings directly or as part of detailed assessment reports that are available via the Amazon Inspector console or API. The Data Pump proceeds to read this path and sends data operations, via the network to a remote path on the target, while the Pump adds storage flexibility and of course, it also serves to isolate the (primary) extraction process from the TCP / IP activity. There is a two-step process to create the required 15 symbolic links. Facebook:https://www.facebook.com/ktexperts/ https://docs.oracle.com/goldengate/m1221/gg-monitor/GMNCH/welcome.htm#GMNCH277. The MOS Doc ID is 1366597.1 and is titled How to Modify the Location for Subdirectories Created by CREATE SUBDIRS In GoldenGate?. Along with this architecture and before getting into Golden Gate monitoring, lets say that it can be configured for several purposes: B.SEQUENCE#, Also u can directly reach out to me via below methods: GoldenGate binaries reside on an Amazon Elastic Block Store (Amazon EBS) volume. At this point, GoldenGate isnt running on either EC2 instance. Pandora FMS is a flexible monitoring system, capable of monitoring devices, infrastructures, applications, services and business processes. 18. Estimation of the attenuation of two waves on a linear sensor array. Monitoring All Running Processes Oracle Goldengate Monitor - Its a separate licensed tool which falls under oracle management pack product list. Marvin Vinsonis an Oracle Database Specialist for AWS. rev2022.7.21.42635. Amazon Inspector automatically assesses applications for exposure, vulnerabilities, and deviations from best practices. You can accomplish this by using Amazon Inspector. RBA: 29592508 The third port range is for the 250 dynamic ports list. The security group source shouldnt use Classless Inter-Domain Routing (CIDR). Start the second GoldenGate EC2 instance (GG2), mount Amazon EFS, and start the GoldenGate processes (. This can be done with Oracle goldenGate (OGG) 11.1.1.0.x or higher. WHERESEQUENCE# = xxx; The sequence being read by Golden Gate. When a Data Pump is not used, Extract should proceed to send the data operations that have been captured to a remote path in the target. You can use OBEY to start the GoldenGate manager process and subsequent processes. Also, this command is less accurate than LAG and INFO. The alerts could be configured if any of the OGG process goes down or abended. 5. RBA: 371282432 SCN: 1.3015888404 NAME, You can configure this using the AUTORESTART parameter in the GoldenGate parameter file. To understand the current status of the Extract, you can add detail to the info GGSIC command asfollows: We can use the editor depending on operating system vi on Unix for example to view the ggserr.log file which is located at the top level GoldenGate software installation directory. GGSCI should have already been leveraged to issue the add trandata, add extract, add exttrail, register extract and add replicat commands. You must perform the GoldenGate installation on both EC2 instances. You can also configure GoldenGate automatic conflict detection and resolution (CDR) using the latest timestamp method. In case the delay exceeds the value specified with the parameter LAGCRITICAL, the Administrator will inform us that the delay is critical. You need to run the GoldenGate hub on EC2 instances. log. Go thru below blog written by me for heartbeat table: https://k21academy.com/oracle-goldengate-12c/the-heartbeat-table-of-oracle-goldengate-12-2/, For any query feel free to drop an emailashishagarwalag@gmail.comor whatsapp@, Like and subscribe:https://lnkd.in/gv5TSFP, To view or add a comment, sign in 10. This calculation includes one manager process, two extract processes, and two replicat processes. If the EC2 instance system status check isnt set to running, an SNS notification should be sent to the GoldenGate administrator to fail over the GoldenGate processes to the secondary EC2 instance. Pandora FMS Enterprise is capable of monitoring the most popular applications and databases. Obviously if the archivelog was no longer available on the server your extract process would abend. The RDS for Oracle instances should have Multi-AZ enabled to provide high availability for the RDS instances. It is provided for educational purposes only. To confirms that REPLICAT server has processed all logs from the data source at run-time. If for some reason thedata is notreplicating, check the trail file names or the databaseconnection to make sure theyre set up properly. You can use GoldenGate within an AWS Region or across multiple Regions. The following querywill do this for us. Difference between /usr/bin/strings and gstrings from binutils? You should run these commands using the operating system user that installs GoldenGate (typically named oracle). On the other hand, in order to establish a critical lag threshold and to force a warning message in the error log, when the threshold is reached, we must use the parameter LAGCRITICALSECONDS; LAGCRITICALMINUTES or, if preferred, LAGCRITICALHOURS . Oracle GoldenGate supports many different databases, including, but not limited to, Oracle, Amazon Aurora MySQL, Amazon Aurora PostgreSQL, Amazon RDS for Oracle, and Microsoft SQL Server. What are good particle dynamics ODEs for an introductory scientific computing course? These databases can reside on premises or in the cloud. Current write position: We have talked about the most important tools for Golden Gate monitoring, but if you want to check some other methods such as Volume Supervision Processing, the use of the Error Registry, the use of the Process Report, the use of the File Disposal, Maintenance of Discard Files, Use of System logs, Reconciliation of Time Differences, then click here to go to the Official Oracle page . Abogado y estudiante de astrobiologa, le apasiona la informtica, la lectura y la investigacin cientfica. To see which archive log file it was reading you could use the following query. Timestamp: 2014-11-12 09:10:35.051249 Heartbeat table allows for storing the current lag in OGG environment and also storing lag history. You can see how many inserts, updates and deletes have occurred on each table, there is a view of the total, daily and hourly statistics. Your email address will not be published. Parameter descriptions can be found in GoldenGate documentation. In addition to the databases being highly available, the database replication tool should be highly available. GGSCI source> view report dpvmed1 Import new table In the results you can see a column name "lag at chkpt" where you will see lag if there is issue in the sync. To avoid this and confirm that Extract is being recovered properly, we must use the SEND EXTRACT command with the STATUS option. For those readers who want to expand the information we have provided about Oracle GoldenGate, from Pandora FMS we recommend clicking on this link . The databases can be self-managed or a cloud managed service, such as Amazon Relational Database Service (Amazon RDS). If CPU utilization exceeds 80% or I/O throughput is throttled, consider changing the EC2 instance type, EBS volume type, or Provisioned IOPS setting. Restart Extract Database In Sync Monitoring: OGG is a replication tool. For extraction and replication of transactional operations of DML which stands for data manipulation language and changes in the data definition language or DDL (for compatible databases), in order to maintain an adequate data coherence of origin and destination. 14. EXTRACT RUNNING DPVMED1 00:00:00 00:00:07 For many of these use cases you can use database replication tools such as AWS Database Migration Service (AWS DMS) or Oracle GoldenGate. GGSCI (destination server) 1> stats repvmed1 totalsonly VMEDDEV.*. Oracle GoldenGate asynchronously replicates data between databases. Or if you have to monitor more than 100 devices you can also enjoy a 30 days FREE DEMO of Pandora FMS Enterprise. SELECT SEQUENCE#, * Current status: Recovery complete: At EOF, Current read position: Waiting for data to process: In the Extract, Extract process is waiting for the redo Its a way to achieve immortality. Remove the FILTER parameters replicat. Rodrigo Giraldo, redactor tcnico freelance. Use OBEY to process a file that contains a list of GoldenGate commands. Can a human colony be self-sustaining without sunlight using mushrooms? Forexample, in one-way replication, all the stats from the Extract and Replicate side should match. Verify Status The need to move data from one location to another in an asynchronous manner is a goal for many enterprises. Why had climate change not been proven beyond doubt for so long? Thank you, Save my name, email, and website in this browser for the next time I comment. Regarding DDL support, we know that certain capture or delivery configurations and topologies vary according to the type of database. You could then check ggserr for the lag reports. SELECT . 2014-11-12 08:51:01 Seqno 111888, RBA 360514560 Timestamp: 2014-11-12 09:10:37.000000 The second port is for the GoldenGate manager process. 2. I like to use the lag command, GGSCI (source server) 17> lag extract extvmed1. Thus, one of the following status annotations will appear, while we will be able to continue with the process as Extract changes its log reading position, during the recovery itself: The statistics of Lag show us the Oracle GoldenGate processes, follow the rhythms of the amount of data generated by commercial applications. INSERT INTO SOURCE.DASANI VALUES ('SOMU','DBA'); INSERT INTO SOURCE.DASANI VALUES ('ZABI','DBA'); INSERT INTO SOURCE.DASANI VALUES ('GIRI','BIGDATA'); Install Oracle Software in silent mode 11gR2, How to change SQL prompt to show connected user and database name, How to Recover Loss of DATA (Without a Backup! Now, to observe the delay statistics, we must use the LAG or SEND command in GGSCI. We have received the best reviews over time and the usage of this page has been increasingly drastic. Pleaseclick hereto subscribe for further updates. All production data should be encrypted at rest. Therefore, ensure that enough memory has been allocated using the following calculations: Therefore, to set up GoldenGate bi-directional replication on an EC2 instance, at least 1.4 GB of memory is required for GoldenGate. YouTube:https://www.youtube.com/c/ktexperts. You should run all DDL and DML statements using the hr Oracle database user. KT Experts is one enthusiastic knowledge-sharing platform. Symbolic links are supported for GoldenGate subdirectories. Your email address will not be published. Madrid. We can send REPLICAT a LOGEND check message to the process. In the data pump, Extract is waiting for the Extract trail files. For more information about required privileges, see Operating System Privileges. Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/, OGG How to Resync Tables / Schemas on Different SCN s in a Single Replicat (Doc ID 1339317.1), ADD NEW TABLE TO AN EXISTING EXTRACT, PUMP AND REPLICAT. How to Resolve DIA-48448: This command does not support multiple ADR homes. You should also set up CloudWatch alarms for AWS CloudTrail events. For instructions on installing and configuring the GoldenGate hubs, see Using Oracle GoldenGate with Amazon RDS. the network or disk I/O issues. GGSCI (source server) 14> stats dpvmed1 totalsonly VMEDDEV. Because the endpoint for the database instance remains the same after a failover, your application can resume database operation without the need for manual administrative intervention. /oralogs/redo03.log111886 INACTIVE YES. In addition to migrating data and keeping two or more databases in sync, you can use GoldenGate to upgrade to a new major version of Oracle. extract and replicat operations which are in progress. Find centralized, trusted content and collaborate around the technologies you use most. Get it here. The GoldenGate trail files are stored in Amazon EFS. This operating system user is not the root user and doesnt require root privileges. It has been tested internally, however, we do not guarantee that it will work for you. INSERT INTO SOURCE.DASANI VALUES ('CHITTI','MANAGER'); INSERT INTO SOURCE.DASANI VALUES ('SRINIVAS','LEAD'); It's sync now, next step we need to FILTER PARAMETER from Relicat, Map SOURCE.DASANI, target TARGET.DASANI; <-----. Redo thread #: 1 This architecture illustrates how to replicate two RDS for Oracle instances asynchronously and bi-directionally. However, because these files must be shared via Amazon EFS, you shouldnt run the create subdirs GGSCI command. 2022, Amazon Web Services, Inc. or its affiliates. You can login into the ggs utility and give, GGSCI> Info replicat (or) info all -> for all extracts/replicat status. 9. GoldenGate requires a port for the GoldenGate manager process and up to 250 dynamic ports for the process to assign to the GoldenGate collector and GoldenGate replicat processes. Call/whatsapp@+14168715708 How can I use parentheses when there are math parentheses inside? The following code is the OBEY GoldenGate startup script (startreplication.oby). We have to ensure that source and target databases are in sync. In case of an infrastructure failure, Amazon RDS performs an automatic failover to the standby database, so you can resume database operations as soon as the failover is complete. If not one of the processes (Extract, Datapump or Replicat) is the bottleneck and should be inestigated. If the active GoldenGate hub experiences an interruption or is inadvertently shut down, no transactions are omitted from the replication stream when the passive GoldenGate hub is activated. Required fields are marked *. Is it patent infringement to produce patented goods but take no compensation?

For example, a CloudWatch alarm should be triggered when configuration changes occur on security groups. You can also encrypt Amazon RDS for Oracle with Oracle Advanced Security Option if Oracle Enterprise Edition is deployed. KTEXPERTSis always active on below social media platforms. For example. 2. The GoldenGate node or instance can fail due to inadvertently stopping a node or instance, inadvertently removing files from the GoldenGate home directory, the root file system reaches capacity, network access and connectivity problems, mistakenly killing a GoldenGate process, unknowingly unmounting an EBS volume, or other compute-related problems. The following code shows the commands to create the subdirectories. Recording the Lag Status in the ggserr.log File, To track the lagreport frequency in the Manager parameter file using LAGINFOandLAGREPORT parameters. B. Oracle Goldengate performance: This involves overall performance of OGG environment which involves lag,OGG Process status,Monitoring OGG Environment to ensure the processes are up and running. You must create the Amazon RDS for Oracle instances prior to creating the GoldenGate hubs. How to help player quickly make a decision when they have no way of knowing which option is best, Cannot handle OpenDirect push notification when iOS app is not launched. The lag may be Additionally, when a GoldenGate hub instance is started, Amazon EFS should be automatically mounted and the GoldenGate processes should be automatically started. Sending GETLAG request to EXTRACT EXTVMED1 Oracle Goldengate Veridata is a monitoring tool which is used to identify the data discrepancies between source and target. (LogOut/ Another method is found in a third-party capture module, which provides us with a communication layer that passes data and metadata from an external API to the Extraction API. However, all other database user DML statements against the source tables are replicated to the target database. If you see different numbers of operations, then there may be data lost or filtered in the process. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. GoldenGate shared files are stored on an Amazon Elastic File System (Amazon EFS) volume. It is an extraction group that is within the Oracle GoldenGate source configuration. The instances must have adequate CPU, memory, and storage to handle the anticipated replication volume. GoldenGate bi-directional replication can enable database migrations and database upgrades with near-zero downtime. In order to specify the interval in which the Administrator is verifying the delay of Extract and Replicat, we must use the parameter LAGREPORTMINUTES or LAGREPORTHOURS. 2019-04-24T01:10:39.386+0800 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rraj.prm: PROCESS ABENDING. Additionally, you should monitor the GoldenGate EC2 instances via Amazon CloudWatch and publish notifications via Amazon Simple Notification Service (Amazon SNS). Rajasekhar Amudala How do I (or can I) SELECT DISTINCT on multiple columns? https://www.linkedin.com/pulse/oracle-goldengate-veridata-ashish-agarwal/?articleId=6666035671544795136. To replicate a single table (jobcode) in a specific schema (hr) using GoldenGate bi-directional replication, refer to the following DDL statements and GoldenGate parameter files. So why wait? Checkpoint Lag 00:00:00 (updated 00:00:00 ago) Short satire about a comically upscaled spaceship. Posted by sandyhunt2013 in Golden Gate, Maintenance, Miscellaneous, Troubleshooting, Uncategorized, Golden Gate, Golden Gate Monitoring, sequence number. In order to minimize the latency between the source and destination databases. However, prior to starting the GoldenGate processes, make sure GoldenGate processes arent running on the other GoldenGate EC2 instance (passive). Manager is running (IP port golden.7809). (LogOut/ During normal operating procedures, the GoldenGate EC2 instance in Availability Zone 1 processes bi-directional replication between the two Oracle databases (Flow 1). This prevents continuous replication looping. To learn more, see our tips on writing great answers. It has a modular architecture, providing flexibility, while being able to extract and replicate selected data records, changes to DDL which stands for Data Definition Language and transactional changes. This is useful to see that the extract, datapump and replicate are in sync, GGSCI (source server) 13> stats extvmed1 totalsonly VMEDDEV. It syns target database with source database. Issue additional DML statements (inserts, updates, deletes) against the hr.jobcode table on database two: Validate that none of the modifications are synchronized. It turns out that the provider of the database, provides us with the components that, in turn, extract the data operations and proceeds to pass them to Extract. 8. After building OGG data synchronization, we'd like to make sure all EXTRACT log are applied to the REPLICAT database in Oracle GoldenGate. The following are the commands to see the process information: Important note: there are many other commands for Oracle GoldenGate monitoring. I'm trying below query to get the result but is there any other way possible to get real time golden gate syncing status? The following screenshot shows the required Amazon EFS file system associated with a GoldenGate high availability environment.