Link to home
Start Free TrialLog in
Avatar of dedean01
dedean01Flag for United States of America

asked on

removing backupsets from the catalog "ORACLE 9I"

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?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of mohammadzahid
mohammadzahid
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial