← Backup & Recovery
Oracle · Backup & Recovery
How to list Oracle controlfiles
List Oracle controlfile locations and status from V$CONTROLFILE.
Tested on11g12c18c19c21c23ai26ai
Controlfiles are the recovery-critical binary files that describe the database. This lists every controlfile path and its status. Verify all controlfile copies are on separate physical devices — losing all controlfiles at once forces manual recovery.
SET LINESIZE 100
COLUMN name FORMAT a80
SELECT name, status
FROM v$controlfile
ORDER BY name;backupcontrolfilev$controlfile