Oracle Scripts

Oracle Fast Recovery Area: Set DB Recovery File Dest and Size Purpose The Oracle Fast Recovery Area (FRA) is a disk location where Oracle keeps files related to backup and recovery. Two dynamic initialization parameters, db_recovery_file_dest and db_recovery_file_dest_size, control its location and its disk quota. …

Set Oracle Flashback Database Retention Target with ALTER SYSTEM Oracle Flashback Database lets you rewind your entire database to a past point in time without a full restore. The command ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET controls how far back in time that rewind can go. What This Command Does The …

How to Enable Oracle Database Flashback: Shutdown, Mount, and ALTER Commands Oracle Flashback Database is one of the most powerful data protection tools available to a DBA. This guide walks you through the four commands needed to turn on Oracle Flashback — from a clean shutdown to opening the database in flashback …

Monitor Oracle Data Pump Resumable Waits with DBA_RESUMABLE When you run a large Oracle Data Pump import (impdp), the job can fail mid-way if a tablespace runs out of space. Oracle's resumable import feature prevents this by suspending the job instead of failing it, giving you time to fix the problem and then letting …

Oracle Full Database Export Using a Named Pipe and Gzip Compression in KSH Exporting a full Oracle database can produce very large dump files. This script solves that problem by streaming the export directly through a Linux named pipe into gzip, compressing the output on the fly — without ever writing an uncompressed …

Oracle exp/imp Parameter File: Direct Path User-to-User Data Migration Using a parameter file (parfile) with Oracle's legacy exp and imp utilities is a clean, repeatable way to move schema data between users — especially when you need speed, control over what gets transferred, and a consistent log trail. This post …

Oracle Database Export and Import to Gzip Through a Named Pipe When you need to export a large Oracle database but do not have enough disk space for a full uncompressed dump file, piping the export directly through gzip using a Unix named pipe is a proven technique. This method compresses data on the fly, producing a …

Oracle RMAN Delete Obsolete Backups with Maintenance Channel Purpose The Oracle RMAN (Recovery Manager) commands shown in this script help database administrators manage backup storage by automatically removing old, unnecessary backup files. These commands allocate a maintenance channel for disk operations and delete …

LIST BACKUPSET OF DATABASE: Oracle RMAN Command Guide Purpose The LIST BACKUPSET OF DATABASE command in Oracle Recovery Manager (RMAN) displays detailed information about all backup sets that contain database datafiles. This command helps database administrators verify backup existence, check backup status, find backup …

Oracle RMAN Delete Expired Backup: Complete Guide to Repository Maintenance The DELETE EXPIRED BACKUP command in Oracle RMAN (Recovery Manager) removes expired backup records from the RMAN repository after they have been identified as inaccessible during a crosscheck operation. This command is essential for maintaining …