Oracle Scripts

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 …

Oracle Resumable Import Parameters: Monitor and Manage 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 …

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 …

Oracle RMAN REPORT SCHEMA Command: Display Database Files Purpose The REPORT SCHEMA command is an essential Oracle RMAN (Recovery Manager) tool that displays comprehensive information about all database files in your Oracle database. This command provides database administrators with a quick view of the current …