Vitaliy Vorontsov wrote:
> Oracle stores information about RMAN backups in controlfile and RMAN
> catalog if it is used. So, parameter control_file_record_keep_time=7
> lets you to retain information about backups during last 7 days. If you
> make full backup every 7 days there is a situation when information
> about full backup made for example 8 days ago can be overriden and
> forced out from controlfile.
>
> You have two choices to fix this problem:
> 1. increase control_file_record_keep_time
> 2. use RMAN catalog for storing information that was aged out from
> controlfile.
>
> """Glen ΠΙΣΑΜ(Α):
> """
>
>>Volker Hetzer wrote:
>>
>>>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
>>
>>ah! cfrkt is set at 7, just reading up on it a bit now, although the
>>doc's are a tad confusing so far... do I increase the cfrkt to have a
>>larger recovery window?
>>
>>I'm thinking at the default cfrkt of 7 I should still be able to issue a
>>"delete obsolete recovery window of 3 days", correct? (I can't)
>
>
So - why is it not allowing me to delete backups older than 7 days?
I changed the cfrkt to 30, ran crosscheck backup, and still can't delete
the older backups, RMAN doesnt even see the oldest ones, and the ones it
does see that are older than the days I specify it wont mark as obsolete..
Received on Tue Nov 14 2006 - 13:10:27 CST
