The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all
that apply.)
A.
The initialization parameter should be set to 0 when the RMAN repository is being used.
B.
The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery
catalog only.
C.
The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file
or the recovery catalog.
D.
The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the
recovery catalog.
E.
The initialization parameter should never be set to 0 if you are using RMAN.
Explanation:
CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in
the control file can be reused. In the event a new record needs to be added to a reusable section and the oldestrecord has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections
never expand, and records are reused as needed.
If the number of reusable records in the control file exceeds the circular reuse record limit UB4MAXVAL, then
reusable records will be overwritten even if CONTROL_FILE_RECORD_KEEP_TIME has not elapsed.
UB4MAXVAL is defined in the oratypes.h header file, which is found in the public directory. Its value may vary
according to the operating system you are using.