December 2002
Intermediate to advanced
928 pages
85h 29m
English
The control file contains essential information about the current state of the database. You should always back up your control file when you make a user-managed backup. You do this by executing the following command in SQL*Plus:
ALTER DATABASE BACKUP CONTROLFILE TO filename | TO TRACEYou can back up a control file in binary format to a binary location or to a trace file. Backing up the control file to a binary location includes more information and is the method recommended by Oracle. Backing up a control file to a trace file allows you to re-create the control file from the trace file with the CREATE CONTROLFILE command.