Oracle-Backup
Oracle Data Pump: Create the DATA_PUMP_DIR Directory
Apr 11, 2026 / · 5 min read · Oracle Data Pump Database Administration Oracle Backup expdp impdp Directory Object SQL all_directories dba_directories v$parameter ·Oracle Data Pump: Create the DATA_PUMP_DIR Directory Before you can run any Oracle Data Pump export (expdp) or import (impdp) job, Oracle needs to know where to write and read dump files and log files on the server. You do this by creating a directory object inside the database that points to a real folder on the …
Read MoreOracle Flashback: Enable with Shutdown, Mount, ALTER
Mar 5, 2026 / · 5 min read · Oracle Flashback DBA Database-Recovery Oracle-Backup SQL Data-Protection Admin-Guide v$database ·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 …
Read MoreHow to Disable and Enable Oracle Archive Log Destinations
Nov 27, 2025 / · 3 min read · Oracle Database Data Guard Archive Log DBA Commands Database Administration Standby Database Oracle Backup Database Maintenance v$archive_dest ·How to Disable and Enable Oracle Archive Log Destinations Purpose The Oracle commands for disabling and enabling archive log destinations allow database administrators to control the availability of archive destinations without removing the configuration. These commands are commonly used in Oracle Data Guard …
Read More