Oracle 12c利用資料泵DataPump進行OracleDatabase Backup

標籤：

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 NOSQL> alter session set container=pdbcis;Session altered.

3、建立DataPump使用者

SQL> grant dba to dp identified by dp;Grant succeeded.

4、建立Database Backup目錄

[[email protected] ~]$ 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、匯出

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

列印的結果

[[email protected] ~]$ expdp dp/dp@pdbcis directory=datapump_backup  dumpfile=xxcis.dmp  logfile=xxcis.log  schemas=xxcisExport: Release 12.1.0.2.0 - Production on Tue Jan 5 11:51:27 2016Copyright (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 ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsStarting "DP"."SYS_EXPORT_SCHEMA_01":  dp/********@pdbcis directory=datapump_backup dumpfile=xxcis.dmp logfile=xxcis.log schemas=xxcisEstimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 21.56 MBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/TABLESPACE_QUOTAProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSProcessing 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 rowsMaster table "DP"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded******************************************************************************Dump file set for DP.SYS_EXPORT_SCHEMA_01 is:  /home/oracle/pdbcis_bak/xxcis.dmpJob "DP"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Jan 5 11:52:31 2016 elapsed 0 00:00:52

Oracle 12c利用資料泵DataPump進行OracleDatabase Backup