Oracle 19c Point-in-Time Recovery (PITR) Using RMAN

What is Point-in-Time Recovery? Point-in-Time Recovery is a technique to restore a database to a specific moment in the past. Unlike complete recovery (which applies all redo/archived logs until the most recent commit), PITR deliberately stops recovery at a chosen point. Demo Scenario Let’s simulate a common situation: Step 1: Setup and Insert Data At […]

relink all With Grid Infrastructure and Oracle Homes

Linux patching (OS security updates, kernel upgrades, etc.) is a routine activity for system administrators. For Oracle RAC environments, DBAs must ensure pre-patching checks, safe shutdowns, and post-patch relinks are properly executed to avoid service disruption. 1. Why Pre-Patching Checks Are Critical Before handing over the server to the Linux team, DBAs must: These pre-checks […]