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..
Received on Wed Nov 15 2006 - 03:28:26 CST
