The CREATE CONTROLFILE Command

It is possible to create a control file, not only at database creation time but also after the database is created and running. It can be created indirectly by using the BACKUP CONTROLFILE TO TRACE command or by the BACKUP CONTROLFILE command, or it can be created directly by the CREATE CONTROLFILE command.

The CREATE CONTROLFILE command allows you to create a control file from scratch. It is important that you have a complete detailed understanding of the database and its contents to use it correctly.

The CREATE CONTROLFILE command is used to re-create a control file whenever all viable copies of the existing control ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.