1 2 Previous Next 18 Replies Latest reply on Oct 22, 2013 10:36 AM by Rizwan Shaukat

    RMAN backup scripts .....

    Rizwan Shaukat

      I have write the following scripts with respective frequencies: pls suggest about the scripts if any enhancement required.

       

      Thnx

       

      weekly

      ------

      Run

      {

      Allocate channel ch01 type disk maxpiecesize = 2g;

      Backup incremental level=0 format 'D:\rmanbK\Fullbackup\bk_u%u_s%s_p%p_t%t' database;

      sql 'alter system archive log current';

      backup archivelog all delete input format 'D:\rmanbK\Archive\arch-s%s-p%p-t%t';

      backup spfile format 'D:\rmanbK\Fullbackup\spfile_%d_%s_%T_dbid%I';

      Backup current controlfile format 'D:\rmanbK\Fullbackup\Ctrl_u%u_s%s_p%p_t%t';

      release channel ch01;

      }

       

       

       

       

       

       

       

       

      Daily

      -------

      Run

      {

      Allocate channel ch01 type disk maxpiecesize = 2g;

      sql 'alter system archive log current';

      Backup incremental level 1 cumulative database format 'D:\rmanbK\Incremental\Bk_%d_%s_%p_%T.bkp';

      backup spfile format 'D:\rmanbK\Fullbackup\spfile_%d_%s_%T_dbid%I';

      Backup current controlfile format 'D:\rmanbK\Fullbackup\Ctrl_u%u_s%s_p%p_t%t';

      release channel ch01;

      }

       

       

       

       

      1 hour

      ---------

      run {

      allocate channel c1 type disk format 'D:\rmanbK\Archive\ARCH_%d_%s_%p_%T.bkp' maxpiecesize 2g;

      backup ARCHIVELOG ALL DELETE INPUT;

      backup current controlfile;

      release channel c1;

      }

        1 2 Previous Next