ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 揭秘ORACLE备份之--逻辑备份(EXPDP)

揭秘ORACLE备份之--逻辑备份(EXPDP)

Linux操作系统 作者:haiross 时间:2014-05-26 10:29:55 0 删除 编辑

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/28355782/viewspace-1169775/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-05-24

  • 博文量
    16
  • 访问量
    34491