← 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