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 …

If you are working with Oracle E-Business Suite and need to test whether the Workflow Notification Mailer is configured correctly, sending a test notification to a specific user is 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 …

In this blog we are going to discuss how we can restart the service of workflow email 1. Go to site map2. Click notification mailer3. Select Workflow Mailer Service 4. …

During configuration of a DR server, when i try to do telnet from primary to dr, the telnet utility is not working on primary, so this is the procedure to …

Learn step-by-step how to replace a corrupted or problematic undo tablespace in Oracle Database, including creating a new undo tablespace and updating the spfile safely Undo tablespaces are critical in …