Backing Up Control Files

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

1. 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';
   

2. 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 the database trace file where it can be captured and edited to reproduce the control file.

   See Also:

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