Posts by Naveen Kandasamy

Copying Table Data from Source to Destination in SQL Server

Purpose and Scope  This document describes the procedure to copy table data from a source server to a destination server using the SQL Server Import and Export Wizard. This method is commonly used for…

Read More

Oracle GoldenGate Installation on Linux 

Oracle GoldenGate Installation on Linux  Introduction  Oracle GoldenGate is a real-time data integration and replication tool that enables reliable, secure, and high-performance data movement across heterogeneous systems. It is widely used for real-time reporting,…

Read More

Dataguard manual switchover

Introduction      Oracle Data Guard plays a pivotal role in ensuring business continuity by maintaining synchronized standby databases that can seamlessly take over when the primary database is unavailable. Among its…

Read More

DATAGAURD BROKER CONFIGURATION 

DATAGAURD BROKER CONFIGURATION  Introduction: Oracle Data Guard Broker is a management framework that automates and simplifies the configuration, monitoring, and administration of Oracle Data Guard environments. It provides a centralized…

Read More

SYSTEM TABLESPACE RECOVERY USING RMAN

Introduction: The SYSTEM tablespace is a critical component of the Oracle database, containing essential metadata and data dictionary objects necessary for database operation. If the SYSTEM tablespace becomes corrupted or…

Read More

POSTGRES DATABASE INSTALLATION ON WINDOWS

INTRODUCTION                 PostgreSQL is a powerful, open-source relational database management system (RDBMS) known for its advanced features, extensibility, and strong standards compliance. It supports both SQL for relational queries and…

Read More