2 Replies Latest reply: Nov 26, 2012 1:51 PM by efierro RSS

    how to keep archivelog number of 15 in rman redundancy 2 days

    975800
      hi.. all

      i'm oracle engeener in korea.

      i have a question....

      my company using to rman backup eveyday and using script. (cron)

      sciprt detail is

      run {
      backup database;
      backup archivelog all;
      ...
      ...
      delete obsolete redundancy 2;
      ...
      ...
      }
      ------------------------------------------------------------------------
      IN RMAN
      CONFIGURATION RMAN .... REDUNDANCY 2;
      CONFIGURATION ...
      CONFIGURATION ...
      CONFIGURATION delete archivelog policy to none;
      #################################

      my issue is

      i wnat have a archivelog 15 numbers after start sciprt, but archivelog're deleted that reason redundancy 2 in rman policy.

      so i change to script and rman configure, change to method, backup archivelog all ... keep ~ until 'sysdate-15' in rman script. ... but this method failed
      i change to sciprt and rman configure, change to methed, from redundany 2 to windows 2. but faild

      all methed're archivelog deleted in configuration rman policy.

      how can i reramin to archivelog 15 numbers in oracle that rman policy is backup and delete options.

      help me....ㅜㅜ

      ps)
      english is very difficulte... in my life
        • 1. Re: how to keep archivelog number of 15 in rman redundancy 2 days
          mseberg
          Hello;

          This would work for that
          echo "Starting RMAN..."
          $ORACLE_HOME/bin/rman target / catalog <catalog_user>/<password>@<catalog_db> << EOF
          
          run 
          { 
          allocate channel d1 type disk;
          allocate channel d2 type disk;
          allocate channel d3 type disk;
          backup full as compressed backupset   
          database plus archivelog;
          release channel d1;
          release channel d2;
          release channel d3;
          
          }
          
          
          
          
          delete noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-15';
          
          
          DELETE noprompt BACKUP COMPLETED BEFORE 'SYSDATE-3' DEVICE TYPE DISK;
          
          
          exit
          
          
          EOF
          
          echo `date`
          #
          echo
          echo 'RMAN Full Complete'
          Best Regards

          mseberg
          • 2. Re: how to keep archivelog number of 15 in rman redundancy 2 days
            efierro
            Post the entire rman scripts, dots don't help.
            Don't do delete obsolete..., that tells rman to delete all backups that are not required to go back a certain period of time (window) or backups older than the number of retained ones (redundancy).
            You can manage your deletions with until 'sysdate-N' as someone recommended above.