dbasamad – Page 2

Install Oracle GoldenGate 19c on Linux

By dbasamad in GoldenGate

In this article, I will demonstrate how to install Oracle GoldenGate 19c on Linux Server. We will follow these Steps:

GoldenGate Commands

By dbasamad in GoldenGate

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. Manager Commands:

Oct 26 2023

Recover a Table From a Drop/Truncate/Delete By RMAN

By dbasamad in Backup & Recovery, Oracle Database

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 …

Nov 13 2021

Improve Backup Performance – Change Tracking

By dbasamad in Backup & Recovery

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.

Oct 27 2021

Clone a Database User by Query

By dbasamad in Scripting

Script to pull/show a database user’s privileges or clone a user by query.

Oracle GolgeGate

By dbasamad in GoldenGate

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

Feb 18 2021

Create a Trace file for Control file

By dbasamad in Backup & Recovery

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.

Jan 16 2021

Create a filesystem on Linux

By dbasamad in Unix

In this article, I will show how to create a filesystem and mount it on Linux.

Nov 13 2020

Oracle Database Performance Issue Troubleshooting and Tuning Part – I

By dbasamad in Performance Tuning

“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 …

2 comments

Nov 07 2020

Restoring Corrupted Datafile Using RMAN in Oracle

By dbasamad in Backup & Recovery, OCM Preparation

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.

Mohammad Samad

Author's posts