Control Files: Contents, Multiplexing and Backup
What is the Control File?
The control file is a small but vital binary file. It is the database's address book. Without it, Oracle cannot even mount the database.
| It stores | Why |
|---|---|
| Database name and creation time | Identity |
| Names and locations of datafiles and redo logs | So Oracle knows what to open |
| Current log sequence and checkpoint (SCN) | To know where recovery starts |
| RMAN backup history | So RMAN knows what is backed up |
See Your Control Files
sql
SELECT name FROM v$controlfile;
SHOW PARAMETER control_files
Multiplex: Keep More Than One Copy
Oracle keeps identical copies of the control file in different places. If one is lost, the others save you. Best practice is at least two copies, on different disks.
- Shut down:
SHUTDOWN IMMEDIATE - Copy an existing control file to the new location with an OS command.
- Edit the parameter, then start the database.
sql
-- 2. copy at the OS level
-- cp /u01/oradata/FREE/control01.ctl /u02/oradata/FREE/control02.ctl
-- 3. tell Oracle about both files
STARTUP NOMOUNT;
ALTER SYSTEM SET control_files =
'/u01/oradata/FREE/control01.ctl',
'/u02/oradata/FREE/control02.ctl' SCOPE = SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;
Back Up the Control File
sql
-- binary copy
ALTER DATABASE BACKUP CONTROLFILE TO '/backup/control_bkp.ctl';
-- a script that can recreate the control file
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
sql
-- RMAN: automatic backup after every backup
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
Best practice: Turn on CONTROLFILE AUTOBACKUP in RMAN. Then every backup also saves the control file and the SPFILE, which makes disaster recovery much easier.
If a Control File is Lost
| Situation | What to do |
|---|---|
| One copy lost, another is fine | Shut down, copy a good one over the missing one, start again |
| All copies lost | Restore from RMAN autobackup, or recreate using the TRACE script |
Why it matters: The control file changes constantly and is part of every recovery. Always include it in your backup plan.
Conclusion
The control file is the database's address book. Keep two or more copies on different disks and back it up every time.
Quick Summary: Multiplex control files and enable RMAN CONTROLFILE AUTOBACKUP.

