为什么在备份过程中rman不使用unused block 压缩功能？来源于:Why is RMAN not using Unused Block Compression during backup? (文档 ID 798844.1)
适用于：Oracle Database – Enterprise Edition – Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]Information in this document applies to any platform.***Checked for relevance on 27-Nov-2013***
目标：在10.2版本时，并符合下面的所有条件的情况下，rman将会使用unused block 压缩功能：
The COMPATIBLE initialization parameter is set to 10.2There are currently no guaranteed restore points defined for the databaseThe datafile is locally managedThe datafile is being backed up to a backup set as part of a full backup or a level 0 incremental backupThe backup set is being created on disk or OSB backup to tape
Note:#i1015382.Oracle Database Backup and Recovery Reference11g Release 2 (11.2)Part Number E10643-04.BackupbackupTypeSpecNote:If COMPATIBLE is set to 10.2, then only tablespaces created with 10.2 compatibility will be optimized to exclude blocks that do not currently contain data. If COMPATIBLE is set to 11.0.0 or higher, however, then the first backup that produces backup sets after COMPATIBLE is set to 11.0.0 or higher will update the headers of all locally managed datafiles so that all locally managed datafiles can be optimized.
但是，下面的来自于v$backup_datafile的查询显示：在备份期间，所有的datafile 均是全部扫描（%READ 是100）
SQL> set lines 120SQL> select file# fno, used_change_tracking BCT,incremental_level INCR, datafile_blocks BLKS,block_size blksz, blocks_read READ,round((blocks_read/datafile_blocks) * 100,2) "%READ",blocks WRTN, round((blocks/datafile_blocks)*100,2) "%WRTN"from v$backup_datafilewhere completion_time betweento_date('25-jan-09 01:30:00', 'dd-mon-rr hh24:mi:ss') andto_date('26-jan-09 12:35:26', 'dd-mon-rr hh24:mi:ss') order by file#;—- Change the dates as necessary to encompass the backup start and end times– and check the %READ value for each datafile.—->将如上脚本的where条件修改一下，可以作为查询datafile 扫描率的一个常用脚本。
解决方案：unused block 压缩 对 10.2.0.1版本是不适用的。只有当在打10.2.0.2patch之后建立的tablespace 才能使用unused block 压缩
因此，对于如下情况的表空间，， 是不能使用unused block 压缩功能的：在10.2.0.2之前建立的表空间在compatible 被设置为10.2之前建立的表空间
The cause of this problem has been identified and verified in an ‘unpublished’ Bug 4720762 – Fixed in Product Version 11.0
有勇气并不表示恐惧不存在，而是敢面对恐惧克服恐惧
