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.
Oracle RMAN incremental to MSDP very slow
We are running RMAN backups to MSDP. The fulls and archive backups are very fast and dedupicate pretty well using filesperset 1. When the incremental backups run, it can take as much as 9 minutes to back up a 288k file, which makes no sense. It looks like bptm is waiting on something, but I cannot understand what it could be. Oracle is 10G, changed block tracking is enabled. The DBAs set filesperst to a higher number, and its faster, but it hardly deduplicates, so that's not gong to work. Anyone else see anything like this? I don't think its due to deduplication - it seems to be something on the oracle side. All the other jobs that run against the MSDP run very well. The behavior is the same using client side dedupe and server side dedupe. Master and Media are on 7.5.0.4 Oracle boxes are on 7.1.0.4 due to an old kernel they run.
question about how to get data about tape library on media (NetBackup)
I found this request "SELECT DiskPerTapeReadBytesPerSec, DiskPerTapeWriteBytesPerSec, Frequency_PerfTime, Name, Timestamp_PerfTime FROM Win32_PerfRawData_TapePerf_NetBackupDiskPerTape" on one of the old forums, but as far as I understand it does not work at this time. Having looked through all the documentation I did not find at the remembrance of this I would like to understand how you get data about tape lib for example for veritas NetBacup OpsCenter. Whether is possible to get this information from command line? Thanks =)
