control file size - control_file_record_keep_time

From: CRISLER, JON A (ATTCORP) <"CRISLER,>
Date: Mon, 18 Apr 2011 21:14:01 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD302195B_at_MISOUT7MSGUSR9D.ITServices.sbc.com>

control_file_record_keep_time=7 (default) control_file_record_keep_time=30

We typically increase this value on 10g and 11g databases in order to track RMAN and Data Guard info for longer periods than the default, which is 7 days. I normally set it to 30,60 sometimes 90 days. We do not use an RMAN catalog for many databases (that's another long story but we are stuck with it).

Is there any downside to increasing this value ?

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 18 2011 - 16:14:01 CDT