Glen schrieb:
> 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.
One beginners mistake is to have not enough space in the control file.
Does the parameter "control_file_record_keep_time" ring a bell?
Lots of Greetings!
Volker
--
For email replies, please substitute the obvious.
Received on Tue Nov 14 2006 - 10:08:27 CST
