Database Backup

Oracle Data Pump Export Schema with expdp Command Guide Oracle Data Pump's expdp utility lets you take a fast, flexible logical backup of any schema in your Oracle database. This post breaks down a simple schema-level export command, explains each parameter, and shows you how to run it safely. What This Command Does …

Oracle expdp Schema Export Using Data Pump Oracle Data Pump's expdp utility lets you export a full database schema — including tables, indexes, constraints, and data — into a portable dump file. This guide breaks down the single-line command that does exactly that for the andy schema. Purpose of This Command The goal …

Export an Oracle Database from a Point in Time Using FLASHBACK_TIME The Oracle exp utility supports a FLASHBACK_TIME parameter that lets a database administrator export a full database with all data consistent to a single point in time. This is critical for large, active databases where export duration may span minutes …

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 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 Restore Database Validate - Check Backup Integrity The RESTORE DATABASE VALIDATE command is one of the most critical proactive health check operations in Oracle Recovery Manager (RMAN) that allows database administrators to verify backup integrity without performing an actual restore operation. This command …

Oracle RMAN Delete Obsolete - Remove Unneeded Backups The DELETE OBSOLETE command in Oracle RMAN (Recovery Manager) is a powerful maintenance tool that automatically removes backup files that are no longer needed for database recovery. This command helps database administrators manage storage space by deleting backups …

Oracle RMAN Report Obsolete Command The REPORT OBSOLETE command in Oracle Recovery Manager (RMAN) helps database administrators identify backup files that are no longer required for recovery operations. This command compares existing backups against your configured retention policy and marks outdated backups as …