Vitaliy Vorontsov wrote:
> RMAN doesn't allow you to delete backups older than 7 days, because
> records about backups have already been deleted from controlfile. So,
> you have a situation when datafiles physically present on your disk,
> but all records about them are cleared.
> You should delete the files by OS command.
>
> """Glen писал(а):
> """
>
>>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..
>
>
Agreed - but it is not even letting me delete backups < 7 days old,
which it should. Guess I'll go over the docs some more and see what I'm
missing here, may even put in a SR to see what they say (and get some of
my moneys worth..)
Received on Wed Nov 15 2006 - 09:01:49 CST
