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