Forum Discussion

Sagar_Kolhe's avatar
10 years ago
Solved

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.