Backing Up Control Files

Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files. You have two options:

• Back up the control file to a binary file (duplicate of existing control file) using the following statement:

  ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/control.bkp';
  

• Produce SQL statements that can later be used to re-create your control file:

  ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
  

  This command writes a SQL script to a trace file where it can be captured and edited to reproduce the control file. View the alert log to determine the name and location of the trace file.

  See Also:

  • Oracle Database Backup and Recovery User's Guide for more information on backing up your control files

  • "Viewing the Alert Log"