This discussion is archived
3 Replies Latest reply: Feb 5, 2013 7:13 PM by MKinnal RSS

Old Backup deletion

MKinnal Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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