RMAN 10.2 "unused" block compression
539944Nov 1 2006 — edited Nov 2 2006Has anyone tested for the unused block compression. I realize the docs say it is the case now in 10.2 that rman only backs up currently used blocks, and not blocks that belonged to dropped or truncated tables. I can't proove it on my own system.
I tried...
1) creating a tbsp 100mb, with an 80mb table. Backed it up as a backupset
2) Dropped the 80mb table and purged it from the recyclebin. Backed it up as a backupset.
Both backupsets were the exact same size, indicating only that rman doesn't back up "never" used blocks.
I did the same test AS COMPRESSED BACKUPSET and got the same result, both were compressed but were of equal size.
Thanks,
A