5 Replies Latest reply: Dec 6, 2012 5:15 PM by onedbguru RSS

    GZIP RMAN BACKUP

    mustuq81
      Dear All
      We are running Oracle 10g(10.2.0.4) on Solaris 10
      I want to gzip up my rman backups, which are to disk.
      How do I add the command to my script so after end of backup it starts gzipping it.
      Please find the script below

      export ORACLE_BASE=/app/oradataerp/oraprod
      export ORACLE_HOME=/app/oradataerp/oraprod/db/tech_st/10.2.0
      export ORACLE_SID=PROD
      export LD_LIBRARY_PATH=${ORACLE_HOME}/lib
      export PATH=${ORACLE_HOME}/bin:${ORACLE_HOME}/lib:${PATH}
      export DATE=`/usr/bin/date +%Y%m%d`
      rman target sys/***** nocatalog msglog /nfs-bkp-erp/PROD-ERP/PROD-DB/RMAN.${DATE}.log <<EOF
      crosscheck archivelog all;
      #backup database format '/nfs-bkp-erp/PROD-ERP/PROD-DB/PROD_t%t_s%s_p%p%c';
      #backup current controlfile format '/nfs-bkp-erp/PROD-ERP/PROD-DB/PROD_cntrl_t%t_s%s_p%p%c';
      #delete noprompt archivelog All complEted before 'SYSDATE-10';
      crosscheck backup;
      #delete expired archivelog all;
      delete obsolete;
      crosscheck backup;
      EXIT
      EOF;


      Regards
      Musaddaq