DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001


    Hi all,
    I am looking for a script to delete expired backups in RMAN.
    I have been looking at the process and commands to delete but it looks like you would need to delete piece by piece.

    I have this script below but it does not delete anything. It looks like you or some other process would need to "expire" the backup before you can delete. or the backup would need to have a status of "expired" first.

    allocate channel for maintenance type 'sbt_tape';
    crosscheck backup of database completed before 'SYSDATE-5';
    delete expired backup of database completed before 'SYSDATE-5';
    release channel;

    1/ how do I expire the backups I deem old?
    2/Can I expire and delete in one scripts?
    3/ Any sample script?

    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Feb 2001



    You didn't mention about your OS and Oracle version. If you are using Unix, you can find sample scripts in $ORACLE_HOME/rdbms/demo directory. Make a copy of rman1.sh script and modify it. It will check obsolete rman backups, create the cmd file and execute it.

    Let us know if you have any question.

    Good Luck!



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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.