Control File Maintenance - Exercise

Objective: Match Oracle AI Database 26ai control-file configuration, inspection, and protection concepts to their meanings.

Exercise Instructions

Match each numbered item in the left column to one lettered definition in the right column. The definitions are shuffled; items on the same row are not necessarily a match. Use each letter A through I exactly once.

Enter nine number-letter pairs in the response box, one per line, using the format 1-A. This is a format example, not an answer. Select View Solution to compare your response with the answer key.

Exercise Scoring

This exercise is unscored. Your response is displayed for comparison; it is not automatically graded. No database commands need to be executed.

Match the numbered items to the lettered definitions
Item	Definition
1. `CONTROL_FILES`	A. A command-line client for running SQL and administrative commands.
2. `V$CONTROLFILE`	B. A saved binary copy containing control-file metadata for a recovery procedure.
3. SPFILE	C. A view containing database identity and operating information, including `LOG_MODE`.
4. `V$SPPARAMETER`	D. Maintaining multiple current control-file copies, preferably on independent storage failure domains.
5. `V$DATABASE`	E. The initialization parameter that specifies the configured control-file paths.
6. Control-file multiplexing	F. Oracle-managed binary storage for persistent initialization parameter settings.
7. Binary control-file backup	G. A view reporting the configured control-file names and related information.
8. Control-file trace backup	H. A view describing stored server parameter file settings.
9. SQL*Plus	I. Text containing SQL that can be reviewed and adapted to reconstruct a control file.

Your matches

Enter one pair per line, for example 1-A. Include items 1 through 9.