Oracle Backup

Run a Consistent Export with expdp FLASHBACK_TIME Purpose A schema export reads many tables over a span of time, and for schemas where rows in one table reference rows in another, you usually want every table in the dump to reflect the same moment. Community Data Pump documentation puts it directly: expdp exports are …

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 …

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 …

How to Disable and Enable Oracle Archive Log Destinations Purpose Coordinating redo shipping around a standby maintenance window is an operational task every Data Guard DBA runs into: the standby is about to go down for patching, storage work, or a network change, and the primary database needs to keep generating and …