Re: getting RMAN to mark and delete obsolete

Glen wrote:
> DB is 9.2.0.7
>
> I am having a couple of RMAN issues on one database, the most pressing
> being it is not marking or deleting old backups.
>
> I've set up 2 RMAN jobs in OEM, a weekly job to run on sunday night to
> do an incremental level 0 backup, and a job to run every other day of
> the week to do an incremental level 1. Archive logs are deleted after
> they have been backed up twice and older than 7 days. Retention policy
> was set to a recovery window of 3 days.
>
> Today I noticed a couple of things, the first being the jobs are not
> showing up in the history tab in OEM, checking the server itself I see
> that they have been running as backups are in the backup directory
> specified, they are just not being recorded in OEM.
>
> The second thing I noticed is that old backups are not being deleted. So
> I logged into RMAN on the server itself, run a crosscheck database
> command, do a list of backups, and it shows backups back to the date Nov
> 5th (today is the 14th) There are RMAN backups in the directory going
> back to Oct 22. When I run a "delete obsolete" or "delete obsolete
> recovery window of 7 days;" it returns a message that there are no
> obsolete backups. I've changed the retention setting to 2 or 3 days, and
> still getting the same message when trying to delete the old backups.
>
> I suppose I could just use the OS to delete the old backups, but I want
> to find out why RMAN is not doing what(I think) is it being told to do.
>
> I must be missing something here, but what?
>
> tia

Connect to the RMAN repository and type:

show all;

Then post what RMAN reports.

David Fitzjarrell Received on Tue Nov 14 2006 - 09:56:42 CST