
Protecting Oracle Database Appliance - Tape Backup with Oracle Secure Backup
26
# echo 1 > /proc/scsi/sg/allow_dio
# touch /usr/local/oracle/backup/device/enable_dio
Note: The /proc/scsi/sg/allow_dio file does not survive reboots. Setup an /etc/rc#.d script to ensure it gets set
during boot.
Hardware Compression
By default most tape drives have compression enabled, and it is recommended to compress at the tape drive level.
You can experiment with compression using RMAN, but if you opt to enable compression at a different layer of
the backup architecture you must disable tape drive compression to avoid doubling compression, which can result
in larger backups and slower transfer rates.
The table below shows the transfer rates achieved in the test environments following tuning.
TABLE 2.PERFORMANCE STATISTICS ORACLE DATABASE
APPLIANCE V1 (TESTS RUN ON X4170 M2 MEDIA SERVER)
AVERAGE BACKUP TRANSFER RATE PER TAPE DRIVE
WITH HARDWARE COMPRESSION
TABLE 3.PERFORMANCE STATISTICS ORACLE DATABASE
APPLIANCE X3-2 (TESTS RUN ON X3-2 MEDIA SERVER)
AVERAGE BACKUP TRANSFER RATE PER TAPE DRIVE
WITH HARDWARE COMPRESSION
Note1: GbE not tested on Oracle Database Appliance X3-2 as it was verified on Oracle Database V1 that RMAN
can easily saturate a GbE connection.
Note2: The limiting factor on a GbE interface with this configuration is the interface, not the tape drives. Each
node can send up to 120Mbs per second through an interface (bond is active-passive), but the Master/Media can
only consume 120MBs total as that is the capacity of the interface. If active-active bonding is configured, and/or
more NICs or multiple Medias Servers are used, higher rates could be achieved, as the tape drives were not
saturated.
Note3: All tests were run using the Bare Metal configuration (vs. Virtualized). Additionally, on Oracle Database
Appliance X3-2 tests only one storage module was used.
Conclusion
In conclusion, Oracle StorageTek tape products offer cost effective data protection for the Oracle Database
Appliance and, when combined with Oracle Secure Backup, provide an end to end solution fully supported by one
vendor – Oracle.
Commentaires sur ces manuels