Protecting Oracle Databases with HCC Using Veritas NetBackup
As organizations continue to adopt Oracle Hybrid Columnar Compression (HCC) to achieve substantial data reduction and performance optimization for data warehousing workloads, it becomes increasingly critical to ensure robust protection strategies for these databases. Veritas NetBackup delivers comprehensive support for Oracle databases leveraging HCC, seamlessly integrating with Oracle Recovery Manager (RMAN) to enable high-performance, policy-driven backups that maintain data integrity across both HCC-enabled and non-HCC storage environments. NetBackup leverages RMAN’s block-level capabilities to perform efficient full and incremental backups of Oracle databases, including those utilizing HCC on Oracle-engineered systems like Exadata and ZFS Storage Appliances. Through tight RMAN integration, NetBackup preserves the compression format during backup, minimizing storage consumption and backup windows while supporting deduplication for further optimization. This allows database administrators to maintain their HCC benefits even in backup and recovery workflows, while centralizing control and reporting through NetBackup’s interface. In recovery scenarios, NetBackup supports full flexibility whether restoring to an HCC-capable system or to a non-HCC environment. When recovering to an HCC-compatible platform, the compressed data remains usable in its native format, preserving both performance and storage efficiency. If recovery is directed to a non-HCC destination—such as traditional file systems or third-party storage—the restore process completes successfully, but the data must be uncompressed before it can be accessed. Full guidance on these options is available in Oracle’s official documentation on restoring HCC tables. NetBackup ensures that backup and recovery operations remain consistent and reliable across both HCC and non-HCC environments.
BKF compression algorithm
I m using compression in my bkf file and some of data is compressed and some are not.The shown screen-shot is compressed data of jpg file, so can anyone help me to tell which format so i used to crop the bkf file data of image file. because http://laytongraphics.com/mtf/MTF_100a.PDF in this link compressed block start from FH block and also please tell me where to find a algoritm to decompress this data
Backup to Disk with Compression enabled is very slow ... any tuning options?
Hi, my backup is stable for the past month and i would like to enable compression for the backup to disc jobs. For most normal backup2disc jobs (Hyper-V, Exchange, SQL) the job rate ist about 28-34GB/min. If i enable compression for the same job, it slows down to 4-5GB/min. Where is the bottleneck, is it the Host or the Client System? Is there any option for tuning the compression method or the number of CPU´s that are used for compression? Thanks
Tape Capacity Exceeded When It Shouldn't Be
Hi, Having an issue with Backup Exec 15 where the backup job is exceeding tape capacity, but I don't know why. Each week we have a full backup of our data and system states. As shown in the attachments, this comes to about 4.85TB of space required. I have 4 LTO5 tapes in the unit allocated. These have a base capacity of 5.52TB with no compression. Yet, when the job runs it completely fills those tapes and I have to routinely add another spare tape into the mix, an LTO4. Even that almost gets filled up. Even without compression (which also isn't happening but I can't explain why) I should have more than enough space on the 4 x LTO5 tapes, yet it fills them up and still needs more. I should also mention, the tapes are put into scratch state before the job starts, there is no appending, only overwrite of blank tapes. Can anyone suggest why this might be happening or what I can do to troubleshoot? I receive no relevent errors or warnings which would explain this. Thank you.
Data to Tapes Not Compressed
I am using LTO6 tapes with the HPE MSL2024 tape library. I am sure the Hardware Compression has been enabled at the tape library level, but the data writing to the tapes does not seem to be compressed at all. Each tape shows Full when the usage reachs to 2.8TB which is just raw capacity. BTW, my NetBackup system is a NetBackup Appliance 5230. It looks like the hardware compression is disabled from the Appliance somewhere. Any idea would appreciated. Ross
