在跟客户进行交流的时候,客户提出有一套数据库只有40G的大小,但是通过RMAN备份出来的文件有80GB,使用expdp导出来的DUMP文件小于40GB,感觉有些诧异,RMAN不是只备份有数据的数据块吗?怎么备份也不应该超过40GB啊,难道跟高水位线有关?带着这些疑问通过在MOS上查阅了一些文章,发现确实有出现RMAN备份文件远大于数据库所占用空间的问题出现的可能性。
首先要明白RMAN的压缩类型:
By default RMAN has three types of compression :
1. Null compression
2. Unused block compression
3. Binary compression<<<< 这是我们最常用到的压缩类型,backup as compressed backupset ....
Till Oracle Version 10.1 only 'Null' compression is done by default but from Oracle Version 10.2 'Null' and 'unused block' compression is done. The types of compression are done automatically, no special command is required.
'Null' and 'unused block' compression are filtering which blocks are send to the backups. 'Binary' compression is an additional compression on the blocks send to t