Data Pump Export (hereinafter referred to as Export for ease of reading) is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the same system or it can be moved to another system and loaded there.

The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The files are written in a proprietary, binary format. During an import operation, the Data Pump Import utility uses these files to locate each database object in the dump file set.

Export backup in Oracle database the Dump file name will include date and time

For Single user

exp scott/tiger file= scott_bk_`date +%b_%d_%y_%H_%M_%S.`dmp log= scott_bk_`date +%b_%d_%y_%H_%M_%S.`log statistics=none compress=y

For full database backup

exp system/passwd file= full_domdb_bk_`date +%b_%d_%y_%H_%M_%S.`dmp log= full_domdb_bk_`date +%b_%d_%y_%H_%M_%S.`log statistics=none full=y compress=y

See example for single user scott

[oracle@dom backup]$ exp scott/tiger file= scott_bk_`date +%b_%d_%y_%H_%M_%S.`dmp log= scott_bk_`date +%b_%d_%y_%H_%M_%S.`log statistics=none
Export: Release - Production on Mon Oct 1 21:46:16 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table EMP_MV 6 rows exported
. . exporting table REPLICA 3 rows exported
. . exporting table SALGRADE 5 rows exported
. . exporting table V_USERS 6 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@dom backup]$ ls -rlt
-rw-r--r-- 1 oracle oinstall 1718 Oct 1 21:46 scott_bk_Oct_01_12_21_46_16.log
-rw-r--r-- 1 oracle oinstall 24576 Oct 1 21:46 scott_bk_Oct_01_12_21_46_16.dmp

Oracle 12c

expdp hr/hr directory=backup dumpfile=dbbkpfull_"%date:~7,2%%date:~4,2%%date:~10,4%".dmp logfile=dbbkpfull_"%date:~7,2%%date:~4,2%%date:~10,4%".log

file names are

[oracle@dom backup]$ ls

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.