Re: crosscheck backup and obsolete

From: <>
Date: Wed, 20 Feb 2008 21:55:35 +0100
Message-ID: <>

Comments embedded

On Wed, 20 Feb 2008 11:52:09 -0800 (PST), Ben <> wrote:

> EE & rman
>If I issue
>rman>report obsolete
>I get a listing of around 100 old archivelogs that were backed up 4
>years ago and no longer exist. I have tried to delete obsolete, but I
>get an error saying there is a mismatch and to crosscheck to fix the
>I run a crosscheck on backup, backupset, archivelog all and still
>doesn't work when I try to delete obsolete.

as expected.
After a crosscheck the command is
delete expired

Delete obsolete expects the backups still to be there. If you expect them not to be there
delete force obsolete.
Warning: this will remove the backuppiece from the catalog/controlfile without warning, even if its there but inaccessible.
>I issued a
>crosscheck backuppiece 1805, 1806;
>delete expired;
>and it works.
>now how can i get around listing out each individual backuppiece

You don't need to.
crosscheck backup of archivelog all

Apart from that: the only thing you need to do is just a little bit of doc reading.
Something most people like to avoid at all cost.

Sybrand Bakker
Senior Oracle DBA
Received on Wed Feb 20 2008 - 14:55:35 CST

Original text of this message