Which statement is true about the compression algorithms that RMAN can use?
A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression
algorithm.
B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression
algorithm.
C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than
the BZIP2 compression algorithm.
D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
Answer: A
有种说法:默认的压缩是 BZIP2。另外一种支持的压缩方式是 ZLIB。相比前者, ZLIB 压缩率不高,不过处理速度快。
但我查到的现象不一样
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM ' BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFORCL.ORA'; # default
文档中
Basic Compression Option
You can configure the basic compression algorithm, which does not require the Advanced Compression Option, with the following syntax:
Advanced Compression Option
If you have enabled the Oracle Database 11g Release 2 Advanced Compression Option, you can choose from the following compression levels:
Compression Level | Performance Benefits and Trade-Offs |
---|---|
HIGH | Best suited for backups over slower networks where the limiting factor is network speed. |
MEDIUM | Recommended for most environments. Good combination of compression ratios and speed. |
LOW | Least effect on backup throughput. |
The compression ratio generally increases from low to high, with a trade-off of potentially consuming more CPU resources.
Because the performance of the various compression levels depends on the nature of the data in the database, network configuration, system resources and the type of computer system and its capabilities, Oracle cannot document universally applicable performance statistics. Which level is best for your environment depends on how balanced your system is regarding bandwidth into the CPU and the actual speed of the CPU. It is highly recommended that you run tests with the different compression levels on the data in your environment. Choosing a compression level based on your environment, network traffic characteristics (workload), and data set is the only way to ensure that the backup set compression level can satisfy your organization's performance requirements and applicable service level agreements.
SQL> select * from v$version where rownum <=1;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
1 row selected