Joords Oracle DBA blog

Why do we have to use  NORIGISTER  for GoldenGate Downstream mining setup?

Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. It allows you to interactively or batch execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion, and command recall for a feature-rich experience,  all while also supporting your previously written SQL*Plus scripts

Database Cloning; Done in minutes and with minimal storage usage Database Thin Cloning with Copy-On-Write   Based on Network File System (NFS)   Preferable using Direct NFS (dNFS) clients to the database Copy-on-Write (COW) Technology  Clones use read-only image copies of data-files as source     Read Only Databases    Snapshot method    RMAN copy Backup  Only modified blocks are written to dNFS location  CloneDB, snapshot copy, Snap Clone Snap Manager Utility, Enterprise Manager

It is interested thought to make a single (Multitenant) database High Available inside  the  Oracle Cluster environment. In most cases we make Application High available by making a resource  without predefined Cluster Resource Types. Instead every time create a full stack of settings we have now created a predefined type in which we have set the predefined attributes for the cluster resource to handle on. We have created a type which can be used multiple times by different resources with the same fingerprint. Link:  Right Availability in RAC environment Playing with Oracleclusterware infrastructure components

Learn Oracle Goldengate Studio 12.2.1. By Oracle University Faster Goldengate Design and Deployments Getting Started: My First Goldengate Studio Solution by Oracle Learning Library

Presentation of Oracle Goldengate Veridata A Hands-On Lab from Oracle by Oracle fusion Middleware team

This blog reference to Oracle Goldengate Articles [ Ateam-Oracle].  Oracle GoldenGate provides real-time, log-based change data capture, and delivery between heterogeneous systems. Using this technology, it enables a cost-effective and low-impact real-time data integration and continuous availability solution. Oracle GoldenGate moves committed transactions with transaction integrity and minimal overhead on your existing infrastructure. The architecture supports multiple data replication topologies such as one-to-many, many-to-many, cascading, and bidirectional. Its wide variety of use cases includes real-time business intelligence; query offloading; zero-downtime upgrades and migrations; and active-active databases for data distribution, data synchronization, and high availability