This content has been marked as final. Show 3 replies
Do you have many empty blocks inside your 500GB database? 60GB seems very small to me also.
Can you post your backup script?
By running a level 0 you have the option of running a true incremental backup ( level 1 ) at any time. If you just run a backup RMAN will not be able to distinguish which blocks needed to be backed up during an incremental backup. So its not a bad idea. But I would worry something is wrong if my backup was so small.
rc_rman_backup_job_details should provide details of the correct size.
RMAN Backup Compression
Compression can be set as follows :
I would expect compression ratios to be 5.0 at the very best. Since yours are sky high you probably have an issue. You ratio appears to be around 8.3
RMAN> CONFIGURE COMPRESSION ALGORITHM ‘HIGH’; RMAN> CONFIGURE COMPRESSION ALGORITHM ‘MEDIUM’; RMAN> CONFIGURE COMPRESSION ALGORITHM ‘LOW’; RMAN> CONFIGURE COMPRESSION ALGORITHM ‘BASIC’;
Edited by: mseberg on Nov 26, 2012 11:15 AM
I advice you to take Inc 0 backups on every Monday, all other days take Inc 1. Also enable block_change_tracking, it's amazing thing.
You can consider incremental level 0 as a full backup with option to run incremental backups later. If you are not getting any errors during the rman backup then the 60G size should be correct and you are probably calculating the size of your database wrong, taking into account probably allocated empty data files or empty segments.