Oracle 12c leverages data pump datapump for Oracle database backup

1. View the database version

SQL>Select from v$instance; VERSION-----------------12.1. 0.2. 0

2, SYSDBA user login Sqlplus

Sql>show PDBs con_id con_nameOPENMODE RESTRICTED---------- ------------------------------ ---------- ----------         2Pdb$seedREAD  onlyNO3PdbcisREADWRITE NO4PdbidbREADWRITE NOSQL> AlterSessionSetContainer=Pdbcis; Session altered.

3. Create DataPump Users

SQL>Grant to by DP; Grant succeeded.

4. Create a Database backup directory

[[email protected] ~] - /Home/Oracle/Pdbcis_bak

Create a backup directory

SQL>  Createorreplace directory datapump_backup as  '  /home/oracle/pdbcis_bak';D irectory created.

5. Authorized user to export directory operation permission

SQL>grantread on to DP; Grant succeeded.

6. Export

[[email protected] ~]$ EXPDP DP/DP@pdbcis Directory=Datapump_ Backup  dumpfile=xxcis.dmp  logfile=xxcis.  Log  schemas=Xxcis

Results of printing

[[email protected] ~]$ EXPDP DP/Dp@pdbcisDirectory=Datapump_backup DumpFile=Xxcis.dmp logfile=Xxcis.LogSchemas=Xxcisexport:release12.1.0.2.0 -Production onTue Jan5  One:Wuyi: -  .Copyright (c)1982, the, Oracleand/orits affiliates. Allrights reserved. Connected to: OracleDatabase12c Enterprise Edition Release12.1.0.2.0 -64bitProduction withThe partitioning, OLAP, Advanced Analytics and RealApplication 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 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 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 rows. . Exported "Xxcis". " Currrate "0 KB 0 rows. . Exported "Xxcis". " Customsbaseversion "14.32 KB all 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 rows. . Exported "Xxcis". " Levymode "7.242 KB 9 rows. . Exported "Xxcis". " Licensedocu "12.82 KB in rows. . Exported "Xxcis". " Licensenote "16.41 KB. . Exported "Xxcis". " Machiningtype "8.859 KB 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 in the rows. . Exported "Xxcis". " REDDEP "30.07 KB 374 rows. . Exported "Xxcis". " Srtjzx "8.515 KB rows. . Exported "Xxcis". " SRTTJ "12.96 KB. . Exported "Xxcis". " Trade "15.74 KB with rows. . Exported "Xxcis". " Trademark "12.64 KB all rows. . Exported "Xxcis". " TRANSAC "7.078 KB 6 rows. . Exported "Xxcis". " Transf "7.5 KB rows. . Exported "Xxcis". " UNIT "13.61 KB 123 rows. . Exported "Xxcis". " USES "7.367 KB 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 elapsed 0 00:00:52 

Oracle 12c leverages data pump datapump for Oracle database backup