General guidelines for using ZFS storage appliance for Exadata Backups

  • It is recommended to utilize ZFS storage compression (LZ4) to reduce the amount of space required to store backups of the Oracle database and also disable RMAN level compression to increase backup throughput and reduce CPU overhead on Exadata Machine.
  • It is recommended to utilize all Exadata nodes to maximize backup throughput for both Traditional and Image copy backups with using below set of recommended channels.

  • It is recommended to set following ZFS project/share attributes to achieve optimal performance for both Traditional and Image copy backups

Best Practices for Traditional RMAN Backup Strategy

Record Size 1M
Sync Write Throughput
Read Cache Do not use Cache devices
Compression LZ4

Best Practices for Incrementally Updated Backup Strategy

Record Size 32K
Sync Write Latency
Read Cache Default
Compression LZ4


  • It is recommended to create dedicated database services for backups across all Exadata nodes to achieve optional performance by paralleling workload to all nodes and availability in case of instance or node failure.

 Sample Script for Creating Services

srvctl add service -d proddb -r proddb1 -a proddb2 -s proddb_bkup1
srvctl start service -d proddb -s proddb_bkup1

srvctl add service -d proddb -r proddb2 -a proddb3 -s proddb_bkup2
srvctl start service -d proddb -s proddb_bkup2

srvctl add service -d proddb -r proddb3 -a proddb4 -s proddb_bkup3
srvctl start service -d proddb -s proddb_bkup3

srvctl add service -d proddb -r proddb4 -a proddb5 -s proddb_bkup4
srvctl start service -d proddb -s proddb_bkup4

srvctl add service -d proddb -r proddb5 -a proddb6 -s proddb_bkup5
srvctl start service -d proddb -s proddb_bkup5

srvctl add service -d proddb -r proddb6 -a proddb7 -s proddb_bkup6
srvctl start service -d proddb -s proddb_bkup6

srvctl add service -d proddb -r proddb7 -a proddb8 -s proddb_bkup7
srvctl start service -d proddb -s proddb_bkup7

srvctl add service -d proddb -r proddb8 -a proddb1 -s proddb_bkup8
srvctl start service -d proddb -s proddb_bkup8
  • It is recommended to use Oracle Direct NFS (dNFS) for all database and RMAN workloads when using Oracle ZFS Storage appliance with Exadata Machines. It reduces CPU utilization by bypassing the operating system and boots parallel I/O throughput by opening an individual connection for each database process.
  • It is recommended to set RMAN parameter section Size to 100G and filesperset to 1 to achieve optimal performance and throughput.