5 Replies Latest reply: Apr 30, 2012 12:01 PM by Shivananda Rao RSS

    delete archive logs from disk

    934107
      How do i delete the backup set copies of the archive logs, all my archives are written to asm and from there they are backed up to disk in the form of backup sets. the archive backup sets are not getting deleted from disk. how do i change the config to get them deleted??

      below is from show all rman config.
      CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
        • 1. Re: delete archive logs from disk
          Shivananda Rao
          Welcome to OTN !!

          Based on the retention policy you have, you can delete the backupsets from the disk. The backupsets do become obsolete once they are beyond the retention policy of the mentioned redundancy or recovery window you have set. You can later delete the obsolete backups.

          You can delete them using the below commands
          RMAN>crosscheck backup;
          RMAN>delete obsolete;
          If you consider you have received the answer to your question, then please consider closing the thread and keeping the forum clean.
          • 2. Re: delete archive logs from disk
            hitgon
            Hi,


            backup database compressed backupset plus archivelog delete input

            Regards
            Hitgon
            • 3. Re: delete archive logs from disk
              Karthik Chigururu
              The archive log deletion policy which you configured using "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;" deletes the archive logs from the asm(in your case) which were backed up 2 times to disk. It doesn't mean deleting the archive log backup sets.

              If you want to delete the backup sets, define the retention policy depending on your requirements and frequency of your full backups.
              • 4. Re: delete archive logs from disk
                934107
                Thank you for your inputs, will there be any rman configuration parameter to do this?? or I just should call this from any script??
                • 5. Re: delete archive logs from disk
                  Shivananda Rao
                  Hi,

                  you can invoke this in your backup script itself.

                  Example:
                  incremental level 0 backup script:

                  run
                  {
                  backup incremental level 0 database plus archivelog;
                  backup archivelog all delete input;
                  delete noprompt obsolete;
                  }