Database-Backup

Oracle Data Pump Export Schema with expdp Command Guide Purpose Copying one user's tables, code and grants out of a database is a routine job: a refresh of a test system, a move to a new server, or a logical copy kept beside the physical backups. Oracle Data Pump Export (expdp) does this in schema mode. One short …

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 Purpose A backup that has never been read back is only a guess. The night you need it is the wrong time to learn that a backup piece is missing or a block inside it is damaged. The RESTORE DATABASE VALIDATE command in Oracle Recovery Manager (RMAN) closes …

Oracle RMAN Delete Obsolete - Remove Unneeded Backups Purpose A backup disk fills up slowly. Every night adds another set of backup files, and nobody removes the old ones. One morning the nightly backup fails because there is no space left. RMAN already knows which backups are no longer needed, but it does not remove …

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 …