what value?

The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what
value? (Choose all that apply.)

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 oldest record 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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *