3 Replies Latest reply: Feb 5, 2013 9:13 PM by MKinnal RSS

    Old Backup deletion

    MKinnal
      Hi All,

      I want to delete my old dated backup files, but I am unable to do getting below statement.

      RMAN> delete backup tag HOT_DB_BK_LEVEL0;

      using target database control file instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=964 device type=DISK
      specification does not match any backup in the repository


      DB: 11.2.0
      OS: IBM AIX 6.0

      Please suggest me to delete my old backup files.

      /Manjunath
        • 1. Re: Old Backup deletion
          clementeOTN
          Hi Manjunath

          Looking at your command output
          - You are using controlfile
          -Your backups are in the server filesystem

          It seems like if this bakup isn't cataloged in your controlfile.
          You can see which backups are cataloged in your controlfile with rman command

          RMAN> LIST BACKUP;


          But at the end, if you have your backups in disk, you can simply delete with operating system commands it and resync the contents of the disk with the controlfile with command

          RMAN> CROSSCHECK BACKUP;

          Rman will loook at your backups and mark like EXPIRED if "Object is not found either in file system (for DISK) or in the media manager (for sbt)."
          After this, you just need to delete this backups from controlfile with

          RMAN> DELETE EXPIRED BACKUP;




          RMAN CROSSCHECK -> http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta015.htm
          RMAN DELETE -> http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint003.htm#i1008500
          • 2. Re: Old Backup deletion
            brunors
            Hi,

            RMAN> delete expired backup of database;
            using channel ORA_DISK_1

            List of Backup Pieces
            BP Key BS Key Pc# Cp# Status Device Type Piece Name

            See ; <http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint003.htm> and <http://www.orafaq.com/forum/t/87032/2>

            You can use too delete obsolete; It command delete all expired backup that are inside the retention policy.

            KInd regards.
            Bruno Reis.
            www.brunors.com
            • 3. Re: Old Backup deletion
              MKinnal
              Thanks for your reply..

              Issue has been resolved, below changes have been done.

              Actually all backup pieces are going to tape and I was executing the command without allocating the channel.
              I allocated the channel and now its recognizing the backup pieces.

              RUN
              {
              allocate channel ch00 type 'SBT_TAPE';
              delete expired backup;
              release channel ch00;
              }

              /Manjunath