Information about control file status and locations can be retrieved by querying the data dictionary.
• V$CONTROLFILE: Lists the name and status of all control files associated with the instance.
• V$PARAMETER: Lists status and location of all parameters.
• V$CONTROLFILE_RECORD_SECTION: Provides information about the control file record sections.
• SHOW PARAMETERS CONTROL_FILES: List the name, status, and location of the control files.