Control Files: Contents, Multiplexing and Backup

Oracle DBA Certification 10 min min read Updated: Nov 16, 2026 Intermediate
Control Files: Contents, Multiplexing and Backup
Intermediate Topic 6 of 6

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 storesWhy
Database name and creation timeIdentity
Names and locations of datafiles and redo logsSo Oracle knows what to open
Current log sequence and checkpoint (SCN)To know where recovery starts
RMAN backup historySo 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.

  1. Shut down: SHUTDOWN IMMEDIATE
  2. Copy an existing control file to the new location with an OS command.
  3. 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

SituationWhat to do
One copy lost, another is fineShut down, copy a good one over the missing one, start again
All copies lostRestore 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.

Get Newsletter

Subscibe to our newsletter and we will notify you about the newest updates on Edugators