Non-Compressed Backup and Compressed Backup in RMAN

---

Non-Compressed Backup :-

• Command:

  CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;

• Characteristics:

• Backup Time: Typically faster as there’s no additional processing for compression.

• Backup Size: Approximately the same as the database size since there is no compression applied.

• Resource Usage: Minimal CPU overhead, as no compression is applied.

• Use Case: Suitable when storage space is abundant and the primary concern is minimizing backup time.

---

Compressed Backup:-

• Command:

  CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;

• Characteristics:

• Backup Time: Slower compared to non-compressed backups because the data undergoes compression.

• Backup Size: Significantly smaller than the database size, depending on the compressibility of the data.

• Resource Usage: Higher CPU and memory usage during the backup process due to compression.

• Use Case: Ideal when storage space is limited, especially for large databases. Useful for databases with high redundancy or sparse data.