Configuring compression for backups
Compression comes in handy as it enables us to reduce the storage space for the backups taken. However, compression is a double-edged sword. Where using it enables us to save storage space, it may also burn the CPU from an acceptable percentage to a very high value, based on many factors. Because RMAN has inbuilt compression, there shouldn't be a requirement to seek this feature from any third party tool(s).
RMAN offers various types of compression schemes with different kinds of compression ratios using different amounts of system resources. The available options for compression are as follows:
- None
- Basic
- Low
- Medium
- High
You can configure the default or basic compression mode using the CONFIGURE command:
RMAN> CONFIGURE ...Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
