Re: regenerate control file?

Joseph Lee wrote:
>
> Is there a way to regenerate the control file without wiping out my
> datafiles? That is, without creating a new database?
>
> Let's say backup control files are damaged as well.
> --
>
> Joseph S. Lee INRI
> (703)715-9605 x214
> ------------------

There are two ways to do this ... with the SQL*Plus command CREATE CONTROLFILE or using the output created by the ALTER DATABASE BACKUP CONTROLFILE TO TRACE; statement. They are both well documented in the Server Administrator's Guide.

Michael

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################