In this article, I will demonstrate how to install Oracle GoldenGate 19c on Linux Server. We will follow these Steps:
- Download GoldenGate Binary
- Installation Pre-Task
- Installation with GUI Mode
Install Oracle GoldenGate 19c on Linux
GoldenGate Commands
Mostly, DBA configures and manages GoldenGate components by using GGSCI command-line Interface. GGSCI stands for GoldenGate Software Command Interface. It allows you to perform various tasks related to the administration and monitoring of Oracle GoldenGate components.
Help command use to get all available commands with details.
GGSCI> help
Manager Commands:
Continue readingOct 26 2023
Recover a Table From a Drop/Truncate/Delete By RMAN
User may drop or truncate a table or delete records accidently which need to recover. Even sometimes we may need to recover the data for a table for corrupted data. This is very difficult to restore the full DB if database size is huge like Terabytes. I will demonstrate with this Article how we can recover the single table from backup and archive log up-to point in time or SCN.
Continue readingNov 13 2021
Improve Backup Performance – Change Tracking
RMAN’s improvement in incremental backup performance is facilitated by its change tracking feature, which records altered blocks in a designated file. Enabling change tracking allows RMAN to efficiently identify changed blocks for incremental backups without the necessity of scanning every block in the datafile.
Continue readingOct 27 2021
Clone a Database User by Query
Script to pull/show a database user’s privileges or clone a user by query.
Continue readingOracle GolgeGate
Oracle GoldenGate is a comprehensive software solution provided by Oracle for real-time data integration and replication in heterogeneous IT environments. It enables the exchange and manipulation of data at the transaction level among multiple, diverse platforms across the enterprise
Continue readingFeb 18 2021
Create a Trace file for Control file
Sometimes DBA needs to create database creation script from existing database. Oracle provides the “alter database backup controlfile to trace” command to copy the create database syntax into a trace file.
Continue readingJan 16 2021
Create a filesystem on Linux
In this article, I will show how to create a filesystem and mount it on Linux.
Continue readingNov 13 2020
Oracle Database Performance Issue Troubleshooting and Tuning Part – I
“Database or query is performing very slow”. This is a very common complain for DBA. Database performance is an art as there is always have an option to tune. There is no limit to tuning the database performance but DBA need to meet the company’s threshold or SLA. There are lots of factors involved to get database response slow.
Continue readingNov 07 2020
Restoring Corrupted Datafile Using RMAN in Oracle
Datafile corrupt is a partial disaster in database. it will impact for all objects belonging the tablespace. In this case, DBA can either restore the problematic/corrupted datafile from backup.
Continue readingAbout Me
- Bachelor of Science in Computer Science, Dhaka, Bangladesh
- Master of Science in Data Warehousing & Data Mining, London, UK
- Master of Science in Computer Science, MIU, IA, USA
- Oracle Cloud Infrastructure Architect Professional
- Oracle OCP 9i-12c
- Oracle OCE RAC and GRID 11g
- Oracle OCS Security 11g
- Oracle PL/SQL OCA 10g
- Red Hat Enterprise Linux 6 RHCE
