Re: regenerate control file?

Michael Abbey wrote:
>
> 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.
>
> 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,

Unless I've misread Joseph's question. He basically stated that he can no longer bring up his database because his control file(s) is(are) gone including its backed up control file(s).

Therefore, everything you've suggested above is useless.

He can try to manually re-create the control file. This is not an easy task because he needs to remember a few important database facts such as the redolog info, the datafiles info, several MAX parameters, etc.

-Ted.

P.S. The bottom line is if you don't have a good backup control file,

     your database is history.

-- 
=============================================
= Theodore Do                               =
= Technical Consultant, UNIX/ORACLE         =
= TRW Information Technology Services       =
= theodore.do_at_trw.com                       =
=============================================