removing backupsets from the catalog "ORACLE 9I"

Posted on 2007-10-19
Last Modified: 2009-07-29
Oracle 9i Rman Recovery Catalog cleanup
If I issue the the commands listed below to remove backupsets that have been deleted from disk and is no longer needed in the Recovery Catalog, will the system remove the backupsets from the catalog or will the system mark the backupsets with a status of "DELETE" and then I will have to run prgrmanc.sql to remove from the catalog.

RMAN> allocate channel for delete type disk;
2> delete noprompt force backup of database completed before '01-OCT-2006';
3> delete expired backup of archivelog until time '01-OCT-2006';
4> release channel;
5> print database;

Also Please explain the process?

Question by:dedean01
    1 Comment
    LVL 11

    Accepted Solution

    In releases prior to Oracle9i, RMAN sometimes updated the status of records to DELETED in the recovery catalog rather than removing the records altogether. In Oracle9i, RMAN always removes the catalog record rather than marking it as DELETED. Hence, catalog records should only be marked with status DELETED if the catalog has been upgraded or the catalog was resynchronized from a backup control file. You can remove all repository records of backups and copies with status DELETED using the prgrmanc.sql script, which is located in an operating system specific location ($ORACLE_HOME/rdbms/admin on UNIX).

    See url for details:

    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.

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    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

    14 Experts available now in Live!

    Get 1:1 Help Now