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 11.2.0.1.0 - 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 11.2.0.1.0 - 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 DBBKPFULL_02072017.DMP dbbkpfull_02072017.log
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: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
