Re: Deleting in RMAN

On 5 May 2005 08:24:15 -0700, amerar_at_iwc.net wrote:

>
>Hi,
>
>We are running RMAN in 8i (8.1.7.4). Is there a way to report on
>backups that are obsolete or not needed, and delete all of them in one
>command? Or, do I need to delete each piece individually?
>
>I see a lot of documentation on RMAN, but nothing that really tells me
>if there a command to do it all.
>
>Thanks,
>
>Arthur
>

Hi Arthur,

In 8i you need to delete them individually, yes.

In 9i and above it's as simple as e.g.

RMAN>delete obsolete recovery window of 7 days;

Deletes all backup pieces not needed for recovery within the last week.

RMAN is greatly enhanced in 9i, e.g. it gives you restartable backups, restartable restores, block media recovery and a more frindly syntax, just to mention a few things.

Another good reason to upgrade...

• Kenneth Koenraadt