Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

What is the Estimate Size of Incremental Backup Size and Compressed Backup Size for 750 GB DB?

Updated May 19, 2018

Hello Oracle Experts,
If db size is 750gb, what is the estimate size of incremental backup size and compressed backup size? If anyone knows then please explain the solution so that I can proceed accordingly.

Thanks in Advance!

Comments

16 Nov 2015 3:54 pm Rohit Mahajan

To estimate RMAN backup size, you need to estimate total segments size in database. For example if database size is 750 GB but you have only 100 GB data in it, then your backup size will depend on 100GB segment data only, not 750 GB datafile size. For compression also, you need to check what level of compression is configured. But if data segment size is 100GB, then normal backup size will be approx 80-95GB. If compression is used, then backup size should be not more than 15-20 GB.