This discussion is archived
1 2 Previous Next 17 Replies Latest reply: May 19, 2013 11:54 PM by MahirM.Quluzade Go to original post RSS
  • 15. Re: RMAN confusions
    MahirM.Quluzade Guru
    Currently Being Moderated
    yxes2013 wrote:
    Hi again,

    Supposing I will mixed the parameters you provided to my existing rman script like:
    run
    {
    ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT 'D:\rman_level0\%d_%T_%s_%t';
    ALLOCATE CHANNEL c2 DEVICE TYPE DISK FORMAT 'D:\rman_level0\%d_%T_%s_%t';
    ALLOCATE CHANNEL c3 DEVICE TYPE DISK FORMAT 'D:\rman_level0\%d_%T_%s_%t';
    ALLOCATE CHANNEL c4 DEVICE TYPE DISK FORMAT 'D:\rman_level0\%d_%T_%s_%t';
    CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
    BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL = 0 DATABASE PLUS ARCHIVELOG NOT BACKED UP 1 TIMES;
    SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    crosscheck archivelog all;
    delete noprompt expired archivelog all;
    }
    
    
    Would it be better ?
    
    Thanks...
    Hi,

    Looks good.

    You can call
        CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK; 
    1 time.
    Not need every time configure deletion policy. You can configure and remove this configure command from run block.

    Regards
    Mahir M. Quluzade
  • 16. Re: RMAN confusions
    yxes2013 Newbie
    Currently Being Moderated
    thanks :)
  • 17. Re: RMAN confusions
    MahirM.Quluzade Guru
    Currently Being Moderated
    You are welcome!
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points