Oracle Backup Compression
Hello All,
We need to take compress onilne oracle backup. our symantec tech-suppport said that , compression is not possible for oracle through netbackup.
Kindly share your views on the same.
Thanks,
Sagar
If, and only IF, the backup is going straight to LTO5 tape media, then...
1) RMAN pre-compression, before the backup data hits NetBackup, should not be a problem.
2) RMAN pre-compression could (should) be a good thing for LAN backup traffic data volumes, in that less data will be transferred, and so the backup should complete sooner - but only as long as the client (the Oracle server) is not overly stressed (by having to perform compression on the database side), and can thus sustain a decent rate of traffic (see next point).
3) Going direct to tape, should be okay - as long as the client can sustain a transfer rate higher than the minimum 'streaming rate' of the tape drive.
4) Going direct to tape with pre-compressed RMAN data will not yield any compression at the LTO5 tape head - i.e. if the Oracle client sends 2TB of data, then 2TB of tape will be used.
HTH.