DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Rman not deleting obsolete backups

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    Rman not deleting obsolete backups

    Hi all

    I am trying tgo maintain my RMAN Catalog.
    My RMAN retention policy is set to recovery window of 28 days.

    RMAN> report obsolete;
    Report of obsolete backups and copies
    ( Shows a bunch of obsolete backups and copies dated from 18-JAN-15 to 22-JAN-15)

    I run the following command to delete the obsolete backups reported by RMAN.


    RMAN> delete obsolete;

    RMAN retention policy will be applied to the command
    RMAN retention policy is set to recovery window of 28 days
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=1892 device type=DISK
    Deleting the following obsolete backups and copies:
    ( Shows again a list of obsolete backups and copies dated from 18-JAN-15 to 22-JAN-15 to be deleted but infact are nor getting deleted)

    It might have something to do with "keep until time" BUT what can I do have RMAN deleting the obsolete backups?


    Please advise
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Quote Originally Posted by Ablakios View Post
    Hi all
    . . . E t c
    It might have something to do with "keep until time" BUT what can I do have RMAN deleting the obsolete backups?

    Please advise
    Thanks
    1) Remove physical backup files.
    2) Issue he following:
    Code:
    ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
    CROSSCHECK BACKUPSET DEVICE TYPE DISK;
    
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT OBSOLETE;
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Quote Originally Posted by LKBrwn_DBA View Post
    1) Remove physical backup files.
    2) Issue he following:
    Code:
    ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
    CROSSCHECK BACKUPSET DEVICE TYPE DISK;
    
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT OBSOLETE;

    Thank you very much LKBrwn_DBA
    I will try that
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width