oracle 数据泵压缩比率,【EXPDP】11g版本EXPDP 的COMPRESSION参数压缩比堪比“gzip -9”...

只提供METADATA_ONLY和NONE两个选项，基本上没有提供压缩功能。3.使用11g EXPDP工具的四个压缩参数分别生成四个dump文件1)使用ALL参数secooler@secDB /expdp$ expdp sec/sec dumpfile=sec_ALL.dmp logfile=sec_ALL.log tables=t directory=dump_dir compression=ALLExport: Release 11.2.0.1.0 - Production on Sat Mar 20 22:48:52 2010Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing optionsStarting "SEC"."SYS_EXPORT_TABLE_01":  sec/******** dumpfile=sec_ALL.dmp logfile=sec_ALL.log tables=t directory=dump_dir compression=ALLEstimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 136 MBProcessing object type TABLE_EXPORT/TABLE/TABLE. . exported "SEC"."T"                                   14.26 MB 1155520 rowsMaster table "SEC"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded******************************************************************************Dump file set for SEC.SYS_EXPORT_TABLE_01 is:/expdp/sec_ALL.dmpJob "SEC"."SYS_EXPORT_TABLE_01" successfully completed at 22:49:082)使用DATA_ONLY参数secooler@secDB /expdp$ expdp sec/sec dumpfile=sec_DATA_ONLY.dmp logfile=sec_DATA_ONLY.log tables=t directory=dump_dir compression=DATA_ONLYExport: Release 11.2.0.1.0 - Production on Sat Mar 20 22:49:32 2010Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing optionsStarting "SEC"."SYS_EXPORT_TABLE_01":  sec/******** dumpfile=sec_DATA_ONLY.dmp logfile=sec_DATA_ONLY.log tables=t directory=dump_dir compression=DATA_ONLYEstimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 136 MBProcessing object type TABLE_EXPORT/TABLE/TABLE. . exported "SEC"."T"                                   14.26 MB 1155520 rowsMaster table "SEC"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded******************************************************************************Dump file set for SEC.SYS_EXPORT_TABLE_01 is:/expdp/sec_DATA_ONLY.dmpJob "SEC"."SYS_EXPORT_TABLE_01" successfully completed at 22:49:483)使用METADATA_ONLY参数secooler@secDB /expdp$ expdp sec/sec dumpfile=sec_METADATA_ONLY.dmp logfile=sec_METADATA_ONLY.log tables=t directory=dump_dir compression=METADATA_ONLYExport: Release 11.2.0.1.0 - Production on Sat Mar 20 22:50:16 2010Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing optionsStarting "SEC"."SYS_EXPORT_TABLE_01":  sec/******** dumpfile=sec_METADATA_ONLY.dmp logfile=sec_METADATA_ONLY.log tables=t directory=dump_dir compression=METADATA_ONLYEstimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 136 MBProcessing object type TABLE_EXPORT/TABLE/TABLE. . exported "SEC"."T"                                   111.7 MB 1155520 rowsMaster table "SEC"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded******************************************************************************Dump file set for SEC.SYS_EXPORT_TABLE_01 is:/expdp/sec_METADATA_ONLY.dmpJob "SEC"."SYS_EXPORT_TABLE_01" successfully completed at 22:50:274)使用NONE参数secooler@secDB /expdp$ expdp sec/sec dumpfile=sec_NONE.dmp logfile=sec_NONE.log tables=t directory=dump_dir compression=NONEExport: Release 11.2.0.1.0 - Production on Sat Mar 20 22:50:43 2010Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing optionsStarting "SEC"."SYS_EXPORT_TABLE_01":  sec/******** dumpfile=sec_NONE.dmp logfile=sec_NONE.log tables=t directory=dump_dir compression=NONEEstimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 136 MBProcessing object type TABLE_EXPORT/TABLE/TABLE. . exported "SEC"."T"                                   111.7 MB 1155520 rowsMaster table "SEC"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded******************************************************************************Dump file set for SEC.SYS_EXPORT_TABLE_01 is:/expdp/sec_NONE.dmpJob "SEC"."SYS_EXPORT_TABLE_01" successfully completed at 22:50:534.比较生成的四个dump文件大小secooler@secDB /expdp$ du -sm sec*.dmp15      sec_ALL.dmp15      sec_DATA_ONLY.dmp112     sec_METADATA_ONLY.dmp112     sec_NONE.dmpsecooler@secDB /expdp$ du -sb sec*.dmp14987264        sec_ALL.dmp14987264        sec_DATA_ONLY.dmp117223424       sec_METADATA_ONLY.dmp117223424       sec_NONE.dmp实验表明，使用ALL参数和DATA_ONLY参数生成的备份文件基本一样大；使用METADATA_ONLY参数与NONE参数效果一样。使用压缩与不进行压缩的比率是：15/112约等于1/7！这才是真正的压缩。5.使用“gzip -9”对未压缩的备份文件进行压缩，做一下比较secooler@secDB /expdp$ gzip -9 sec_NONE.dmpsecooler@secDB /expdp$ du -sm sec*dmp*15      sec_ALL.dmp15      sec_DATA_ONLY.dmp112     sec_METADATA_ONLY.dmp15      sec_NONE.dmp.gzsecooler@secDB /expdp$ du -sb sec*dmp*14987264        sec_ALL.dmp14987264        sec_DATA_ONLY.dmp117223424       sec_METADATA_ONLY.dmp14717055        sec_NONE.dmp.gz14987264与14717055的区别，相差甚微，基本相同，“gzip -9”稍胜一点点(也许在您的具体环境下“gzip -9”会逊色一点点)。6.小结Oracle 11g的EXPDP工具提供了真正意义上的“备份压缩”，这个技术在备份空间不足的情况下非常实用。Oracle在改进和优化中不断的前进，慢慢体会吧。Good luck.secooler10.03.20