Re: RMAN CONTROL_FILE_RECORD_KEEP_TIME vs. Obsolete

On 31 Oct 2005 06:58:45 -0800, "Michael42" <melliott42_at_yahoo.com> wrote:

>Hello,
>
>In an Oracle9i environment on Sun Solaris 8, my RMAN environment is not
>using OMS yet (using the contol file). I am backing up to disk.
>
>Configuration:
>SPFILE: CONTROL_FILE_RECORD_KEEP_TIME=30
>RMAN: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
>
>If I perform a DELETE OBSOLETE does this delete the physical files
>based on my RETENTION POLICY and remove the entry from the control
>file?
>
>My thought is that if the entry in the control file is also removed
>what is the use of the CONTROL_FILE_RECORD_KEEP_TIME?
>
>Please help me understand this relationsip (yes I read the docs).
>
>
>Thanks,
>
>Michael42

controlfile_record_keep_time determines how long an entry is being kept in the controlfile. After control_file_record_keep_time your entry is deleted anyway.
So the size of your recovery window is being limited by control_file_record_keep_time.

--
Sybrand Bakker, Senior Oracle DBA