DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2000
    8.0.5 on Unix.

    I am running RMAN NOCATALOG, we run backup with level=0 (baseline, full) every monthend leve 1 every weekend and level 2 during weekday. when we issue

    list backupset of database;

    there are huge list of backup history listed. I try to use change backuppiece key validate, to remove those old history since it is useless (we only want keep the last month or two backup piece and history). the error is:

    RMAN-03022: compiling command: change
    RMAN-03026: error recovery releasing channel resources
    RMAN-00569: ================error message stack follows================
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: change
    RMAN-06038: recovery catalog package detected an error
    RMAN-20300: operation not supported without the recovery catalog
    RMAN-06092: error while looking up backup piece

    it only works with catalog!!!

    Does anyone know how to remove those old history useless piece?

    thanks in advance


  2. #2
    Join Date
    Feb 2000
    New York,U.S.A.
    You have to mark them individually as delete, then use the file in $ORACLE_HOME/rdbms/admin/, the file name is prgrmanc.sql. This file will remove all files marked as delete from your catalog. I find it very tedious and time-consumming. I'd like to find out who can do it more effectively.
    rman>allocate channel for maintenance type 'disk'
    2>change backupset xxx,xxx,xxx delete;
    rman>release channel;


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.