Re: crosscheck backup and obsolete
Date: Thu, 21 Feb 2008 08:43:19 -0800 (PST)
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>
> >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
> >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
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