Oracle 12c利用数据泵DataPump进行Oracle数据库备份

1、查看数据库版本

SQL> select version from v$instance;

VERSION
-----------------
12.1.0.2.0

2、sysdba用户登录sqlplus

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBCIS                         READ WRITE NO
         4 PDBIDB                         READ WRITE NO
SQL> alter session set container=pdbcis;

Session altered.

3、创建DataPump用户

SQL> grant dba to dp identified by dp;

Grant succeeded.

4、创建数据库备份目录

[oracle@cis ~]$ mkdir -p /home/oracle/pdbcis_bak

创建备份目录

SQL>  create or replace directory datapump_backup  as '/home/oracle/pdbcis_bak';

Directory created.

5、授权用户导出目录操作权限

SQL> grant read,write on directory datapump_backup to dp;

Grant succeeded.

6、导出

[oracle@cis ~]$ expdp dp/dp@pdbcis directory=datapump_backup  dumpfile=xxcis.dmp  logfile=xxcis.log  schemas=xxcis

打印的结果

[oracle@cis ~]$ expdp dp/dp@pdbcis directory=datapump_backup  dumpfile=xxcis.dmp  logfile=xxcis.log  schemas=xxcis

Export: Release 12.1.0.2.0 - Production on Tue Jan 5 11:51:27 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "DP"."SYS_EXPORT_SCHEMA_01":  dp/********@pdbcis directory=datapump_backup dumpfile=xxcis.dmp logfile=xxcis.log schemas=xxcis
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 21.56 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
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
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
. . exported "XXCIS"."BRIEF"                             5.249 MB   68245 rows
. . exported "XXCIS"."COREOPERATIONLOGS"                 2.561 MB   10037 rows
. . exported "XXCIS"."CUSTOMSCOMPLEX"                    1.666 MB   13171 rows
. . exported "XXCIS"."GTSCUSDATA"                        1.442 MB    4940 rows
. . exported "XXCIS"."DECLAREELEMENTS"                   13.09 KB      35 rows
. . exported "XXCIS"."TAXCODE"                           455.9 KB    6524 rows
. . exported "XXCIS"."GBTOBIG"                           204.3 KB    2609 rows
. . exported "XXCIS"."SAICCODE"                          237.4 KB    3236 rows
. . exported "XXCIS"."STSCODE"                           218.2 KB    3232 rows
. . exported "XXCIS"."PORTLIN"                           165.5 KB    2679 rows
. . exported "XXCIS"."COREACLUSERPERMISSION"             90.63 KB     464 rows
. . exported "XXCIS"."CUSTOMS"                           59.72 KB    1044 rows
. . exported "XXCIS"."DATAIMPORTFIELDSETUP"              54.57 KB     158 rows
. . exported "XXCIS"."DISTRICT"                          55.17 KB     879 rows
. . exported "XXCIS"."RENDERCOLUMNDATA"                  58.37 KB     258 rows
. . exported "XXCIS"."AGENTCORP"                             0 KB       0 rows
. . exported "XXCIS"."APPLICATIONMODE"                   7.046 KB       4 rows
. . exported "XXCIS"."BALANCEMODE"                       7.242 KB       9 rows
. . exported "XXCIS"."BARGAINTYPE"                       7.578 KB       5 rows
. . exported "XXCIS"."BROKERCORP"                        24.33 KB       2 rows
. . exported "XXCIS"."CODRIVER"                              0 KB       0 rows
. . exported "XXCIS"."COMPANY"                           24.44 KB       1 rows
. . exported "XXCIS"."COMSGPARAM"                        17.89 KB      10 rows
. . exported "XXCIS"."CONTAMODEL"                        7.015 KB       4 rows
. . exported "XXCIS"."CONTASIZE"                         6.906 KB       2 rows
. . exported "XXCIS"."COREACLGROUP"                          0 KB       0 rows
. . exported "XXCIS"."COREACLGROUPUSER"                      0 KB       0 rows
. . exported "XXCIS"."COREACLUSER"                       15.12 KB       3 rows
. . exported "XXCIS"."COTYPE"                            7.218 KB       9 rows
. . exported "XXCIS"."COUNTRY"                           23.46 KB     243 rows
. . exported "XXCIS"."CURR"                              8.609 KB      25 rows
. . exported "XXCIS"."CURRRATE"                              0 KB       0 rows
. . exported "XXCIS"."CUSTOMSBASEVERSION"                14.32 KB      39 rows
. . exported "XXCIS"."DEDUC"                             17.89 KB     103 rows
. . exported "XXCIS"."GTSAPPLYBILLHEAD"                      0 KB       0 rows
. . exported "XXCIS"."GTSDECBASEPARAMETERS"              29.83 KB       1 rows
. . exported "XXCIS"."GTSDECHEAD"                        62.75 KB       2 rows
. . exported "XXCIS"."GTSDECHEADPARAMETERS"              21.55 KB       3 rows
. . exported "XXCIS"."GTSDECITEM"                        30.06 KB       2 rows
. . exported "XXCIS"."GTSDECRPTTEMPLATE"                 12.58 KB       4 rows
. . exported "XXCIS"."INVCLASS"                          7.171 KB       7 rows
. . exported "XXCIS"."LEVYKIND"                          8.562 KB      35 rows
. . exported "XXCIS"."LEVYMODE"                          7.242 KB       9 rows
. . exported "XXCIS"."LICENSEDOCU"                       12.82 KB      42 rows
. . exported "XXCIS"."LICENSENOTE"                       16.41 KB      87 rows
. . exported "XXCIS"."MACHININGTYPE"                     8.859 KB      44 rows
. . exported "XXCIS"."MATERIAL"                              0 KB       0 rows
. . exported "XXCIS"."PAYERTYPE"                         6.921 KB       2 rows
. . exported "XXCIS"."PAYMODE"                           7.023 KB       4 rows
. . exported "XXCIS"."PAYTYPE"                           7.054 KB       5 rows
. . exported "XXCIS"."PISESPSERVER"                      12.57 KB       2 rows
. . exported "XXCIS"."PISSYNCACLUSER"                    15.42 KB       3 rows
. . exported "XXCIS"."PORTINTERNAL"                      7.085 KB       5 rows
. . exported "XXCIS"."PREDOCK"                           14.78 KB      99 rows
. . exported "XXCIS"."REDDEP"                            30.07 KB     374 rows
. . exported "XXCIS"."SRTJZX"                            8.515 KB      12 rows
. . exported "XXCIS"."SRTTJ"                             12.96 KB      58 rows
. . exported "XXCIS"."TRADE"                             15.74 KB      92 rows
. . exported "XXCIS"."TRADEMARK"                         12.64 KB      39 rows
. . exported "XXCIS"."TRANSAC"                           7.078 KB       6 rows
. . exported "XXCIS"."TRANSF"                              7.5 KB      14 rows
. . exported "XXCIS"."UNIT"                              13.61 KB     123 rows
. . exported "XXCIS"."USES"                              7.367 KB      11 rows
. . exported "XXCIS"."WRAP"                              7.125 KB       7 rows
. . exported "XXCIS"."COBOMEXG"                              0 KB       0 rows
. . exported "XXCIS"."COBOMIMG"                              0 KB       0 rows
. . exported "XXCIS"."COBOMVERSION"                          0 KB       0 rows
. . exported "XXCIS"."COMPLEX"                               0 KB       0 rows
. . exported "XXCIS"."CONTACTTYPE"                           0 KB       0 rows
. . exported "XXCIS"."COREACLGROUPPERMISSION"                0 KB       0 rows
. . exported "XXCIS"."COUNIT"                                0 KB       0 rows
. . exported "XXCIS"."CURRENCY"                              0 KB       0 rows
. . exported "XXCIS"."CURRRATEMAINTAIN"                      0 KB       0 rows
. . exported "XXCIS"."DECLARANT"                             0 KB       0 rows
. . exported "XXCIS"."ESPAUTHORITYBROKERCORP"                0 KB       0 rows
. . exported "XXCIS"."ESPAUTHORITYBROKERCORPITEM"            0 KB       0 rows
. . exported "XXCIS"."EXPORTINVOICE"                         0 KB       0 rows
. . exported "XXCIS"."FETCHINMODE"                           0 KB       0 rows
. . exported "XXCIS"."GOODS"                                 0 KB       0 rows
. . exported "XXCIS"."GTSAPPLYBILLITEM"                      0 KB       0 rows
. . exported "XXCIS"."GTSAPPLYBILLITEM2GTSDECITEM"           0 KB       0 rows
. . exported "XXCIS"."GTSDECATTACHBILL"                      0 KB       0 rows
. . exported "XXCIS"."GTSDECCONTAINER"                       0 KB       0 rows
. . exported "XXCIS"."GTSDECHEADDEL"                         0 KB       0 rows
. . exported "XXCIS"."GTSDECMESSAGESEND"                     0 KB       0 rows
. . exported "XXCIS"."GTSDECPRINTPARAMETERS"                 0 KB       0 rows
. . exported "XXCIS"."GTSDECRECEIPTRESULT"                   0 KB       0 rows
. . exported "XXCIS"."GTSDECSUPPLEMENTLIST"                  0 KB       0 rows
. . exported "XXCIS"."GTSEXPORTINVOICE"                      0 KB       0 rows
. . exported "XXCIS"."GTSMERGER"                             0 KB       0 rows
. . exported "XXCIS"."INVESTMODE"                            0 KB       0 rows
. . exported "XXCIS"."MERGERCOLUMNORDER"                     0 KB       0 rows
. . exported "XXCIS"."OPINION"                               0 KB       0 rows
. . exported "XXCIS"."PISSYNCAGENTCORP"                      0 KB       0 rows
. . exported "XXCIS"."QUERYCONDITIONASSIST"                  0 KB       0 rows
. . exported "XXCIS"."SCMCOC"                                0 KB       0 rows
. . exported "XXCIS"."STOCK"                                 0 KB       0 rows
. . exported "XXCIS"."TAXREBATEREPORT"                       0 KB       0 rows
. . exported "XXCIS"."TAXREFUNDRATE"                         0 KB       0 rows
. . exported "XXCIS"."TOWNSHIP"                              0 KB       0 rows
Master table "DP"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for DP.SYS_EXPORT_SCHEMA_01 is:
  /home/oracle/pdbcis_bak/xxcis.dmp
Job "DP"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Jan 5 11:52:31 2016 elapsed 0 00:00:52

posted on 2016-01-05 11:58  小强斋太  阅读(3546)  评论(0编辑  收藏  举报

导航