揭祕ORACLE備份之－－邏輯備份（EXPDP）
EXPDP（資料泵）是邏輯備份的一種，是通過PL/SQL語句運算元據庫，必須在服務端執行。
從ORACLE 10g開始提供。
[root@dg ~(23:29:45)]# su - oracle
[oracle@dg ~(23:30:59)]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 28 23:31:06 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-- 檢視目錄
23:31:06 SYS@wailon>select * from all_directories;
OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
------------------------------------------------------------------------------------------------------------------------
SYS ORACLE_OCM_CONFIG_DIR
/u01/app/oracle/product/11.2.0/dbhome_1/ccr/state
SYS DATA_PUMP_DIR
/u01/app/oracle/admin/wailon/dpdump/
SYS XMLDIR
/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/xml
SYS GGS_DDL_TRACE
/u01/app/oracle/diag/rdbms/wailon/wailon/trace
-- 建立備份目錄
23:31:15 SYS@wailon>create directory backup_dir as '/home/oracle/dbbackup';
Directory created.
-- 授權目錄讀寫許可權給SCOTT
23:32:11 SYS@wailon>grant read,write on directory backup_dir to scott;
Grant succeeded.
23:32:32 SYS@wailon>select privilege,table_name from dba_tab_privs where grantee='SCOTT';
PRIVILEGE TABLE_NAME
---------------------------------------- ------------------------------
WRITE BACKUP_DIR
READ BACKUP_DIR
2 rows selected.
23:33:04 SYS@wailon>host
[oracle@dg ~(23:34:11)]$ cd dbbackup/
-- 備份表結構等，不包括資料
[oracle@dg dbbackup(23:36:24)]$ more expdp-metadata.par
userid=scott/tiger
directory=backup_dir
tables=emp
dumpfile=emp-metadata.dmp
logfile=emp-metadata.log
content=metadata_only
job_name=expdp-metadata
[oracle@dg dbbackup(23:36:27)]$ expdp parfile=expdp-metadata.par
Export: Release 11.2.0.3.0 - Production on Sat Sep 28 23:36:42 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."expdp-metadata": scott/******** parfile=expdp-metadata.par
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "SCOTT"."expdp-metadata" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.expdp-metadata is:
/home/oracle/dbbackup/emp-metadata.dmp
Job "SCOTT"."expdp-metadata" successfully completed at 23:37:24
-- 只備份表資料，不備份結構
[oracle@dg dbbackup(23:37:53)]$more expdp-data.par
userid=scott/tiger
directory=backup_dir
tables=emp
dumpfile=emp-data.dmp
logfile=emp-data.log
content=data_only
job_name=expdp-data
[oracle@dg dbbackup(23:38:53)]$ expdp parfile=expdp-data.par
Export: Release 11.2.0.3.0 - Production on Sat Sep 28 23:38:59 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."expdp-data": scott/******** parfile=expdp-data.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
. . exported "SCOTT"."EMP" 8.640 KB 18 rows
Master table "SCOTT"."expdp-data" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.expdp-data is:
/home/oracle/dbbackup/emp-data.dmp
Job "SCOTT"."expdp-data" successfully completed at 23:39:08
-- 備份表結構及資料
[oracle@dg dbbackup(23:39:41)]$ more expdp-all.par
userid=scott/tiger
directory=backup_dir
tables=emp
dumpfile=emp-all.dmp
logfile=emp-all.log
content=all
job_name=expdp-all
[oracle@dg dbbackup(23:39:41)]$ expdp parfile=expdp-all.par
Export: Release 11.2.0.3.0 - Production on Sat Sep 28 23:40:15 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."expdp-all": scott/******** parfile=expdp-all.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."EMP" 8.640 KB 18 rows
Master table "SCOTT"."expdp-all" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.expdp-all is:
/home/oracle/dbbackup/emp-all.dmp
Job "SCOTT"."expdp-all" successfully completed at 23:40:31
-- 備份當前連線使用者所有資料
[oracle@dg dbbackup(23:40:37)]$more expdp-user.par
userid=scott/tiger
directory=backup_dir
dumpfile=expdp-scott.dmp
logfile=expdp-scott.log
content=all
job_name=expdp-scott
[oracle@dg dbbackup(23:43:02)]$ expdp parfile=expdp-user.par
Export: Release 11.2.0.3.0 - Production on Sat Sep 28 23:43:11 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."expdp-scott": scott/******** parfile=expdp-user.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 49.12 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."TAB_DR" 38.00 MB 1194928 rows
. . exported "SCOTT"."GGS_DDL_HIST" 909.7 KB 462 rows
. . exported "SCOTT"."GGS_MARKER" 352.6 KB 359 rows
. . exported "SCOTT"."CHECKPOINT" 10.26 KB 2 rows
. . exported "SCOTT"."DEPT" 5.984 KB 6 rows
. . exported "SCOTT"."EMP" 8.640 KB 18 rows
. . exported "SCOTT"."EMPLOYEE" 5.460 KB 1 rows
. . exported "SCOTT"."GGS_DDL_HIST_ALT" 6.648 KB 25 rows
. . exported "SCOTT"."GGS_SETUP" 5.546 KB 6 rows
. . exported "SCOTT"."SALGRADE" 5.859 KB 5 rows
. . exported "SCOTT"."SQLLDR" 7.710 KB 31 rows
. . exported "SCOTT"."TAB_OGG_DLL" 5.445 KB 2 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
. . exported "SCOTT"."CHECKPOINT_LOX" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_COLUMNS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_LOG_GROUPS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_OBJECTS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_PARTITIONS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_PRIMARY_KEYS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_RULES" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_RULES_LOG" 0 KB 0 rows
Master table "SCOTT"."expdp-scott" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.expdp-scott is:
/home/oracle/dbbackup/expdp-scott.dmp
Job "SCOTT"."expdp-scott" successfully completed at 23:44:28
-- 並行備份指定使用者的所有資料
[oracle@dg dbbackup(23:46:23)]$ more expdp-scott.par
userid=scott/tiger
directory=backup_dir
dumpfile=expdp-scott1.dmp
logfile=expdp-scott1.log
content=all
parallel=2
schemas=scott
job_name=expdp-scott1
[oracle@dg dbbackup(23:46:32)]$ expdp parfile=expdp-scott.par
Export: Release 11.2.0.3.0 - Production on Sat Sep 28 23:46:51 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."expdp-scott1": scott/******** parfile=expdp-scott.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 50.18 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."TAB_DR" 38.00 MB 1194928 rows
. . exported "SCOTT"."GGS_DDL_HIST" 1.111 MB 576 rows
. . exported "SCOTT"."GGS_MARKER" 395.6 KB 387 rows
. . exported "SCOTT"."CHECKPOINT" 10.26 KB 2 rows
. . exported "SCOTT"."DEPT" 5.984 KB 6 rows
. . exported "SCOTT"."EMP" 8.640 KB 18 rows
. . exported "SCOTT"."EMPLOYEE" 5.460 KB 1 rows
. . exported "SCOTT"."GGS_DDL_HIST_ALT" 6.742 KB 28 rows
. . exported "SCOTT"."GGS_SETUP" 5.546 KB 6 rows
. . exported "SCOTT"."SALGRADE" 5.859 KB 5 rows
. . exported "SCOTT"."SQLLDR" 7.710 KB 31 rows
. . exported "SCOTT"."TAB_OGG_DLL" 5.445 KB 2 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
. . exported "SCOTT"."CHECKPOINT_LOX" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_COLUMNS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_LOG_GROUPS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_OBJECTS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_PARTITIONS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_PRIMARY_KEYS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_RULES" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_RULES_LOG" 0 KB 0 rows
Master table "SCOTT"."expdp-scott1" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.expdp-scott1 is:
/home/oracle/dbbackup/expdp-scott1.dmp
Job "SCOTT"."expdp-scott1" successfully completed at 23:47:55
-- 測試EXPDP的INCLUDE及EXCLUDE
[oracle@dg dbbackup(23:55:19)]$ more expdp2.par
cuserid=scott/tiger
directory=backup_dir
dumpfile=expdp-scott2.dmp
logfile=expdp-scott2.log
content=all
include=table:"in('DEPT','EMP')"
include=table:"like 'SAL%'"
exclude=function,procedure,table:"='BONUS'"
job_name=expdp-scott2
[oracle@dg dbbackup(23:56:19)]$ expdp parfile=expdp2.par
Export: Release 11.2.0.3.0 - Production on Sat Sep 28 23:55:23 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
UDE-00011: parameter include is incompatible with parameter exclude
-- INCLUDE和EXCLUDE不能同時使用
[oracle@dg dbbackup(23:57:19)]$ more expdp2.par
cuserid=scott/tiger
directory=backup_dir
dumpfile=expdp-scott2.dmp
logfile=expdp-scott2.log
content=all
include=table:"in('DEPT','EMP')"
include=table:"like 'SAL%'"
#exclude=function,procedure,table:"='BONUS'"
job_name=expdp-scott2
[oracle@dg dbbackup(23:58:19)]$ expdp parfile=expdp2.par
Export: Release 11.2.0.3.0 - Production on Sat Sep 28 23:57:27 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."expdp-scott2": scott/******** parfile=expdp2.par
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
ORA-39168: Object path TABLE was not found.
ORA-31655: no data or metadata objects selected for job
Job "SCOTT"."expdp-scott2" completed with 2 error(s) at 23:57:37
-- 只能使用一個INCLUDE引數
[oracle@dg dbbackup(23:58:54)]$ more expdp2.par
userid=scott/tiger
directory=backup_dir
dumpfile=expdp-scott2.dmp
logfile=expdp-scott2.log
content=all
include=table:"in('DEPT','EMP')"
#exclude=function,procedure,table:"='BONUS'"
job_name=expdp-scott2
Export: Release 11.2.0.3.0 - Production on Sat Sep 28 23:58:59 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."expdp-scott2": scott/******** parfile=expdp2.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 128 KB
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."DEPT" 5.984 KB 6 rows
. . exported "SCOTT"."EMP" 8.640 KB 18 rows
Master table "SCOTT"."expdp-scott2" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.expdp-scott2 is:
/home/oracle/dbbackup/expdp-scott2.dmp
Job "SCOTT"."expdp-scott2" successfully completed at 23:59:26
-- EXCLUDE操作,以下引數不備份FUNCTION,PROCEDURE以及BONUS表
[oracle@dg dbbackup(00:00:11)]$more expdp3.par
userid=scott/tiger
directory=backup_dir
dumpfile=expdp-scott3.dmp
logfile=expdp-scott3.log
content=all
exclude=function,procedure,table:"='BONUS'"
job_name=expdp-scott3
[oracle@dg dbbackup(00:00:11)]$ expdp parfile=expdp3.par
Export: Release 11.2.0.3.0 - Production on Sun Sep 29 00:00:41 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."expdp-scott3": scott/******** parfile=expdp3.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 54.56 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."TAB_DR" 38.00 MB 1194928 rows
. . exported "SCOTT"."GGS_DDL_HIST" 2.900 MB 1488 rows
. . exported "SCOTT"."GGS_MARKER" 766.8 KB 615 rows
. . exported "SCOTT"."CHECKPOINT" 10.26 KB 2 rows
. . exported "SCOTT"."DEPT" 5.984 KB 6 rows
. . exported "SCOTT"."EMP" 8.640 KB 18 rows
. . exported "SCOTT"."EMPLOYEE" 5.460 KB 1 rows
. . exported "SCOTT"."GGS_DDL_HIST_ALT" 7.539 KB 52 rows
. . exported "SCOTT"."GGS_SETUP" 5.546 KB 6 rows
. . exported "SCOTT"."SALGRADE" 5.859 KB 5 rows
. . exported "SCOTT"."SQLLDR" 7.710 KB 31 rows
. . exported "SCOTT"."TAB_OGG_DLL" 5.445 KB 2 rows
. . exported "SCOTT"."CHECKPOINT_LOX" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_COLUMNS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_LOG_GROUPS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_OBJECTS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_PARTITIONS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_PRIMARY_KEYS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_RULES" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_RULES_LOG" 0 KB 0 rows
Master table "SCOTT"."expdp-scott3" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.expdp-scott3 is:
/home/oracle/dbbackup/expdp-scott3.dmp
Job "SCOTT"."expdp-scott3" successfully completed at 00:01:55
-- EXCLUDE操作,以下引數不備份FUNCTION,PROCEDURE和以TAB開頭的表
[oracle@dg dbbackup(00:03:19)]$ more expdp4.par
cuserid=scott/tiger
directory=backup_dir
dumpfile=expdp-scott4.dmp
logfile=expdp-scott4.log
content=all
exclude=function,procedure,table:"like 'TAB%'"
job_name=expdp-scott4
Export: Release 11.2.0.3.0 - Production on Sun Sep 29 00:03:32 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."expdp-scott4": scott/******** parfile=expdp4.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 9.5 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."GGS_DDL_HIST" 3.123 MB 1602 rows
. . exported "SCOTT"."GGS_MARKER" 809.8 KB 643 rows
. . exported "SCOTT"."CHECKPOINT" 10.26 KB 2 rows
. . exported "SCOTT"."DEPT" 5.984 KB 6 rows
. . exported "SCOTT"."EMP" 8.640 KB 18 rows
. . exported "SCOTT"."EMPLOYEE" 5.460 KB 1 rows
. . exported "SCOTT"."GGS_DDL_HIST_ALT" 7.640 KB 55 rows
. . exported "SCOTT"."GGS_SETUP" 5.546 KB 6 rows
. . exported "SCOTT"."SALGRADE" 5.859 KB 5 rows
. . exported "SCOTT"."SQLLDR" 7.710 KB 31 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
. . exported "SCOTT"."CHECKPOINT_LOX" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_COLUMNS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_LOG_GROUPS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_OBJECTS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_PARTITIONS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_PRIMARY_KEYS" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_RULES" 0 KB 0 rows
. . exported "SCOTT"."GGS_DDL_RULES_LOG" 0 KB 0 rows
Master table "SCOTT"."expdp-scott4" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.expdp-scott4 is:
/home/oracle/dbbackup/expdp-scott4.dmp
Job "SCOTT"."expdp-scott4" successfully completed at 00:04:29
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/429786/viewspace-776536/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 揭祕ORACLE備份之－－邏輯備份（EXP）Oracle
- Oracle 邏輯備份之EXPDP精講Oracle
- Oracle 邏輯備份 expdp/impdpOracle
- 揭祕ORACLE備份之－－冷備份（也叫離線備份）Oracle
- 揭祕ORACLE備份之－－熱備份（也叫聯機備份）Oracle
- 揭祕ORACLE備份之----RMAN之二（備份方式）Oracle
- expdp 邏輯備份指令碼指令碼
- Windows邏輯備份-EXPDP(保留5天內邏輯備份)批處理指令碼Windows指令碼
- Oracle裡邏輯備份、物理備份、Rman備份的區別Oracle
- 揭祕ORACLE備份之----RMAN之五（CATALOG）Oracle
- oracle邏輯備份之--資料泵Oracle
- ORACLE備份和恢復 - 邏輯備份 exp/impOracle
- Oracle邏輯備份指令碼Oracle指令碼
- 揭祕ORACLE備份之----RMAN之四（塊跟蹤）Oracle
- Oracle資料庫的邏輯備份工具-expdp資料泵Oracle資料庫
- 邏輯備份--mysqldumpMySql
- 揭祕ORACLE備份之----RMAN之一（引數配置）Oracle
- Mysql備份與恢復(2)---邏輯備份MySql
- mysql 邏輯備份 （mysqldump）MySql
- mysql的邏輯備份MySql
- MongoDB 邏輯備份工具mongodumpMongoDB
- MySql邏輯備份恢復MySql
- openGauss-邏輯備份
- ORACLE資料庫的邏輯備份(轉)Oracle資料庫
- Oracle主備架構下的邏輯備份考慮Oracle架構
- 使用crontab和expdp實現資料庫定期邏輯備份資料庫
- 邏輯備份全庫或者邏輯備份多個使用者的資料
- windows下exp邏輯備份並且定期維護備份Windows
- 物理備份是以block來區別邏輯備份的(os block或oracle block) ？BloCOracle
- Oracle physical standby中的邏輯備份（exp命令）Oracle
- 資料庫邏輯備份(轉)資料庫
- oracle資料泵備份（Expdp命令）Oracle
- 認識資料庫物理備份和邏輯備份區別資料庫
- Oracle邏輯備份與恢復選項說明Oracle
- WINDOWS下部署ORACLE邏輯匯出備份指令碼WindowsOracle指令碼
- oracle資料庫備份之exp增量備份Oracle資料庫
- oracle之rman備份Oracle
- MySQL備份與恢復——基於MyDumper/MyLoader 邏輯備份恢復MySql