V$CONTROLFILE
Data Dictionary ViewColumns ___________________________ STATUS NAME
Example:
SQL> SET LINESIZE 135
  SQL> SET PAGESIZE 9999
  SQL> COLUMN name FORMAT A45
  SQL> 
  SQL> SELECT
   2 name,
   3 LPAD(status, 7) status
   4 FROM v$controlfile
   5 ORDER BY name
   6 /
NAME                                          STATUS
  --------------------------------------------- -------
  M:\ORADATA\LIVE\CONTROL03.CTL
  T:\ORADATA\LIVE\CONTROL01.CTL
  T:\ORADATA\LIVE\CONTROL02.CTL
SQL>
Related: