Multiple choice technology databases

Which two statments regarding the control file and Recover Manager are true ? (Choose two)

  1. The control file can grow in size.

  2. The control file can store RMAN scripts.

  3. CONTROL_FILE_RECORD_KEEP_TIME determine retention time for RMAN records.

  4. The RMAN catalog can exist solely in the control file of the target database.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

The CONTROL_FILE_RECORD_KEEP_TIME parameter indeed determines how long RMAN records are retained in the control file before they can be overwritten. RMAN can use the control file as its catalog repository instead of a separate recovery catalog database, though this has limitations like shorter retention and no stored scripts. The control file has a fixed size at creation and does not dynamically grow, and RMAN scripts are stored in the recovery catalog, not the control file.

Keep practicing — related questions