Re: crosscheck backup and obsolete

On Feb 20, 3:55 pm, sybra..._at_hccnet.nl wrote:
> Comments embedded
>
> On Wed, 20 Feb 2008 11:52:09 -0800 (PST), Ben <benal..._at_yahoo.com>
> wrote:
>
> >10.2.0.2 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
> >issue.
>
> >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
> use
> 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;
> >then
> >delete expired;
> >and it works.
>
> >now how can i get around listing out each individual backuppiece
> >number?
>
> You don't need to.
> crosscheck backup of archivelog all
> works.
>
> 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

thank you Sybrand, delete force obsolete worked. I take it that obsolete backups don't show when you use list backup? Received on Thu Feb 21 2008 - 10:43:19 CST