Complete Guide to Oracle Database Patching: CPU, PSU, and Bug Fix Patches What is Oracle Patching? Patching is a crucial process in Oracle Database Management , where software updates are applied to fix bugs, security vulnerabilities, and performance issues . Oracle releases patches regularly to enhance the database's stability and security. Why is Patching Important? Fixes known bugs that affect database performance. Addresses security vulnerabilities to protect against cyber threats. Ensures better stability and database uptime. Required for Oracle Support compliance . How Oracle Database Patching Works Oracle Database is written in Java and is used to store and manage large amounts of data. Patching is performed at the Oracle Software level rather than the database level. For example, after upgrading Oracle Database from 12c to 19c , a job that used to run for 2 hours started taking 8 hours . Upon contacting Oracle Support, it was identified as a bug, and they recommended ...
Posts
How to Perform Point-in-Time Recovery in Oracle Database Introduction Point-in-Time Recovery (PITR) in Oracle Database is a crucial process that allows administrators to restore data to a specific moment, preventing data loss in case of accidental deletions or corruption. This guide will walk you through restoring an Oracle database using RMAN (Recovery Manager) with incremental backups and archive logs . Step 1: Taking a Level-0 Backup Before performing PITR, we first take a Level-0 (Full) Backup of the database using RMAN. Checking the Initial Row Count We start by checking the total number of records in the U1.T3 table: SELECT COUNT(*) FROM U1.T3; Total records: 6 Executing Level-0 Backup The following RMAN script performs the Level-0 backup: RUN { ALLOCATE CHANNEL ch11 TYPE DISK MAXPIECESIZE 20G; ALLOCATE CHANNEL ch12 TYPE DISK MAXPIECESIZE 20G; ALLOCATE CHANNEL ch13 TYPE DISK MAXPIECESIZE 20G; BACKUP FORMAT '/data/rman/%d_D_%T_%u_s%s_p%p' INCREMENTAL ...
Oracle Database Restoration Process: Step-by-Step Guide Restoring an Oracle database is a crucial skill for Database Administrators (DBAs). This step-by-step guide will show you how to restore an Oracle database using RMAN (Recovery Manager), covering SPFILE, Control File, Data Files, and Archive Logs. What is Oracle Database Restoration? Database restoration is the process of recovering lost, corrupted, or dropped database components from a backup. This is essential for disaster recovery, ensuring minimal downtime and data integrity. Essential Files Required for Restoration Before starting, ensure you have a backup of these critical files: ✅ SP File (Server Parameter File) ✅ Control File ✅ Data Files ✅ Archive Log Files ⚠️ Pro Tip: Before taking a backup, always check the available free space in the backup location. If needed, manually delete old backups instead of using the DELETE BACKUP command, as it might remove all backups, including recent ones. Step 1: Taking a Backup Using R...
🛠️ Understanding Obsolete Backups in Oracle RMAN In Oracle RMAN (Recovery Manager) , managing obsolete backups is crucial for storage optimization and database performance . In this post, we'll explore: ✅ What are obsolete backups ? ✅ The difference between recovery window and redundancy . ✅ How to identify and delete obsolete backups efficiently. 📌 What Are Obsolete Backups in RMAN? An obsolete backup is any backup older than the defined retention policy . These backups are no longer needed for recovery and can be deleted to free up space. 🔍 How Are Backups Marked as Obsolete? RMAN classifies backups as obsolete based on: 1️ ⃣ Recovery Window Policy (Time-Based) 2️ ⃣ Redundancy Policy (Count-Based) Let’s break them down: ⏳ Recovery Window in RMAN A recovery window specifies how many days of backups should be retained. Any backups older than this window are marked as obsolete . 📌 Example : If the recovery window is set to 7 days , RMAN keeps...
How to Delete RMAN Backups in Oracle: Step-by-Step Guide Managing Oracle RMAN backups effectively is essential for optimizing storage space and database performance . In this guide, we will explore how to delete RMAN backups , understand the role of the control file , and handle expired backups properly. 🗑 ️ How to Delete Backups in Oracle RMAN? To delete backups, follow these steps: 1️ ⃣ Deleting Backups Using RMAN (Recommended Method) ✅ First, connect to RMAN: rman traget / ✅ To delete all backups in a specific location: Delete backup; This command removes all backups from the physical storage and updates the control file accordingly. Deleting Backups Using Linux rm Command (Manual Method) Instead of using RMAN, you can delete backup files manually from the operating system: cd /your/backup/location rm -rf * or rm -rf filename. Here in this case, used only filename. 🚨 Warning : This method does not update the control file , so Oracle still thin...
Difference Between Differential and Incremental Backups: A Comprehensive Guide In the world of data management, backup strategies are critical to ensuring data safety and quick recovery. Two of the most commonly used backup methods are Differential Backups and Incremental Backups . While both are designed to save time and storage, they work in fundamentally different ways. In this blog post, we’ll break down the differences between these two backup types, explain how they work, and help you decide which one is best for your needs. What is a Full Backup? Before diving into differential and incremental backups, it’s important to understand the foundation: Full Backups . A Full Backup (Level 0) is a complete copy of all data at a specific point in time. It serves as the baseline for all future backups. Example: On Sunday, you take a full backup of 100 GB. What is an Incremental Backup? Incremental backups a...