RMAN - If i issue a command 'change backupset 797426 delete;' i get an error as the backup set is not there

Posted on 2006-05-03
Last Modified: 2011-10-03
RMAN - If i issue a command 'change backupset 797426 delete;' i get an error as the backup set is not there;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 04/30/2006 22:11:48
RMAN-06160: no backup pieces found for backup set key: 797426

Recovery Manager complete.
 Tidy Backup Part 2 Failed !!

How can i deregister or remove this from the rman catalog;

Question by:hraja77
    LVL 47

    Expert Comment

    How to delete backup set from the catalog
    RMAN>list backup     – look for backup set (see BS key)
    RMAN>list incarnation;
    RMAN>delete backup set 235;
    LVL 1

    Author Comment

    Sorry schwertner - it still gives me the same error - i need to delete from tsm database and rman catalog but the backupset is not physically there ??

    LVL 4

    Accepted Solution

    Use CHANGE... KEEP or CHANGE... NOKEEP to specify whether a backup should be subject to the configured retention policy or kept until a different date or even indefinitely.

    The KEEP option exempts a backup from the current retention policy either indefinitely or until the specified UNTIL time. RMAN does not mark the files as obsolete even if they would be considered obsolete under the retention policy. Such backups are called long-term backups. CHANGE ... NOKEEP is used to undo the effects of CHANGE ... KEEP, so that the configured retention policy applies to the backup.

    For example, the following command blocks RMAN from considering backupsets with the tag 'year_end_2002' as obsolete under the retention policy:


    To allow backupsets with the tag year_end_2002 to be marked as obsolete based on the retention policy, use this command:


    If you want to prevent the use of a backup marked with KEEP in restore and recovery operations, then mark these backups as UNAVAILABLE. RMAN will not delete the records for these backups from the RMAN repository, but will not try to use them in restore and recovery until they are marked AVAILABLE again.

    Hope this will answer your query.

    Chetan Sachdeva

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now