oracle备份statistcs,揭秘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* 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:15directory backup_dir as '/home/oracle/dbbackup';

Directory created.

-- 授权目录读写权限给SCOTT

23:32:11read,write on directory backup_dir to scott;

Grant succeeded.

23:32:32privilege,table_name from dba_tab_privs where grantee='SCOTT';

PRIVILEGE                                TABLE_NAME

---------------------------------------- ------------------------------

WRITE                                    BACKUP_DIR

READ                                     BACKUP_DIR

2 rows selected.

23:33:04

[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