Installation/Configurations19c

Oracle Database RMAN Backup & Recovery – Step by Step Guide Introduction:This guide provides a practical, step-by-step approach to configuring RMAN backups in Oracle Database. Prerequisites:– Oracle Database 19c installed– …

Copy Password File from Primary to Standby ASM   Recently, while working on an Oracle 19c Data Guard environment, I came across a requirement where the password file from the …

Complete Step-by-Step Guide to Convert Physical Standby to Snapshot Standby   Introduction Recently, I had to work on a requirement where the standby database needed to be opened in read-write …

Oracle RAC Architecture Explained (19c & 23ai) – Complete DBA Guide   Introduction Oracle Corporation Real Application Clusters (RAC) is a core technology for high availability and scalability. Unlike traditional …

How to Move SPFILE from ASM to File System   Recently, I faced a requirement where I had to move the Oracle database SPFILE from ASM to the file system, …

Recovery and Restore of Oracle Muti-tenant Environment Scenario: In this scenario we have full backup of entire container and we want to perform point-in-time recovery (PITR) of the entire container …

 Scenario: In this scenario we have full backup of entire container and we want to restore the entire container on different location or directory structure than production.    NOTE: The …

Ensuring the preservation of organizational data and preventing data loss is one of the primary responsibilities of a Database Administrator (DBA). This responsibility often takes precedence over any other tasks …

Configuring Oracle Data Guard Broker for High Availability   How I recently standardized an existing Primary/Standby setup using Broker (DGMGRL) for simpler HA operations. In one of my recent HA/DR …

Check Directories ==================   SQL> desc DBA_DIRECTORIES;   SQL> select * from dba_directories where directory_name=’DATA_PUMP_DIR’;   =================================================================== Change datapump directory ===================================================================   SQL> CREATE OR REPLACE DIRECTORY “DATA_PUMP_DIR” as ‘/app/oracle/product/11.2.0/dbhome_1/rdbms/log/’; …