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

Thread: rman list/report

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    7
    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


    XDBA

  2. #2
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    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;

    Thanks.

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