DBA NAVIGATOR

🧼 Cleaning Up Inactive Patches in Oracle RAC In Oracle RAC environments, patches accumulate over time, many of which become inactive due to rollback, superseding, or failed attempts. These inactive patches can clutter the patch inventory, slow down operations, and introduce inconsistencies across nodes. This post explains how to clean them up safely using opatch util deleteinactivepatches , and why it's essential to run this under both Grid Infrastructure and Oracle RDBMS users . $ORACLE_HOME/OPatch/opatch util deleteinactivepatches -silent 🔍 What Does This Command Do? This command removes all inactive patches from the Oracle inventory. These include: Rolled-back patches Superseded interim or PSU patches Obsolete metadata left from earlier patch attempts It frees up space, reduces conflict risk, and improves future patching performance. The -silent flag allows it to run without user input. ⚙️ Importance in RAC Setup Oracle RAC requires consistent ...

🪄 Oracle GoldenGate: Overview, Architecture, and Silent Installation Oracle GoldenGate (OGG) is a real-time data replication and integration tool. It enables the replication of data across heterogeneous systems, ensuring high availability, disaster recovery, and data distribution for analytics or migration purposes. 📌 What is Oracle GoldenGate? Oracle GoldenGate captures transactional data changes from a source system and applies them to a target system in real-time. It supports unidirectional, bidirectional, and cascading replication setups. Real-time replication Heterogeneous platform support Low impact on source system 📤 Extract Process in GoldenGate Extract is a data capture process that reads changes from the source database. 🔹 Types of Extract Classic Extract: Reads redo/archived logs from Oracle database. Used in non-integrated mode. Integrated Extract: Uses Oracle Streams infrastructure for better performance and support of complex data types...