Skip to main content

Posts

Oracle RMAN Duplicate: Active vs Backup-Based Guide

Introduction The RMAN DUPLICATE command is a built-in utility in Oracle that lets us create a copy of an existing database. It's commonly used for testing, reporting, or setting up a standby database for disaster recovery. Unlike manual duplication methods, RMAN simplifies the process by automatically handling tasks such as creating control files, assigning a new database identifier (DBID), and applying recovery to keep the cloned database consistent. In this article, we'll use the RMAN Duplicate utility for cloning and restoring a target database. Two Main Types of Duplication Active Duplication: This method copies the database directly from the running source database to the destination over the network. It doesn't rely on existing backups, and works well when the source database is accessible and network performance is sufficient. Backup-Based Duplication: This approach uses previously created RMAN backups (stored on disk or tape) to duplicate the database. It...

Apply RU Patch 19.30 on Oracle 19c GoldenGate

Introduction: In this article, we will demonstrate how to apply Oracle GoldenGate Release Update (RU) 19.30 (Patch 38781237) to an existing Oracle GoldenGate installation. We will cover the required prerequisites, installation procedure, and validation steps after the patch is applied. Prerequisites: Below are the minimum requirements. Downtime required at GoldenGate end for 60 mins. Also additional disk space required for patch & Binary backup. Download the RU Patch & required OPatch from below link. Oracle RU 19.30 Patch on GoldenGate 19c. Opatch Environment: Hostname delhi.oraeasy.com Golden Gate Version 19.1.0.0.4 Golden Gate Home /u01/app/gghome Now start the patching step by step: 1. Perform the prerequisite checks. [oracle@delhi ~]$ /u01/app/gghome/ggsci -v Oracle GoldenGate Command Interpreter for Oracle Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_19...

Oracle Database 26ai RAC Installation and Configuration Guide

Introduction: This article provides a step by step guide for installing Oracle Database 26ai RAC in a two node cluster environment. It covers essential prerequisites, Grid Infrastructure installation, ASM configuration, RAC database creation, and post-installation verification steps to help you successfully deploy and validate a functional Oracle RAC setup. Prerequisites: Below are the minimum requirements for Linux environment. For each node: OS - Linux 8/9 CPU - 2core RAM - 8GB SWAP - 8GB Disk space - 50GB (/u01) Must have root user or sudo access. Disable the firewall. 2 Network cards (NIC). For whole setup: Raw Disk storage - 80GB (For ASM disks) Grid and Database binary. Download here. Scenario: This setup is for learning and testing purposes only. So a lightweight Oracle RAC 26ai lab environment will be built using limited hardware resources. Each node will be configure...