Re: regenerate control file?

In article <32545668.59E_at_trw.com>, <theodore.do_at_trw.com> writes:
> Path:

news.ou.edu!news.nodak.edu!netnews1.nwnet.net!netnews.nwnet.net!news.sprintlink net!news-chi-13.sprintlink.net!news.up.net!news.mtu.edu!msunews!harbinger.cc.m onash.edu.au!news.mira.net.au!inquo!news.uoregon.edu!arclight.uoregon.edu!enews sgi.com!news.sgi.com!news.msfc.nasa.gov!elroy.jpl.nasa.gov!news.trw.com!wassup sp.trw.com!mailsrv1.is.trw.com!usenet
> From: Ted Do <theodore.do_at_trw.com>
> Newsgroups: comp.databases.oracle
> Subject: Re: regenerate control file?
> Date: Thu, 03 Oct 1996 17:12:24 -0700
> Organization: TRW Information Technology Services
> Lines: 39
> Message-ID: <32545668.59E_at_trw.com>
> References: <324FD563.23DA_at_rst.inri.com> <324FF500.83A_at_magi.com>
> NNTP-Posting-Host: tdo.ora.is.trw.com
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Mailer: Mozilla 2.01 (Win95; I)
> To: Michael Abbey <msabbey_at_magi.com>
>
> 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 =
> =============================================
>
You don't need to insult people...But if some one was helpful they could send an example of a control file dumped to trace. and let joe try and find all the pieces

startup nomount
CREATE CONTROLFILE REUSE set DATABASE "XXXX" RESETLOGS NOARCHIVELOG

    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 30
    MAXINSTANCES 8
    MAXLOGHISTORY 800
LOGFILE

  GROUP 1 '/usr01/home/oracle/dbs/log1.dbf'  SIZE 10M,
  GROUP 2 '/usr20//redo/log2.dbf'  SIZE 10M,
  GROUP 3 '/usr21//redo/log3.dbf'  SIZE 10M

  '/usr21/dbf/syst.dbf',
  '/usr21/dbf/rbs.dbf',
  '/usr20/dbf/temp1.dbf',
  '/usr20/dbf/tool.dbf',                                                       
  '/usr20/dbf/usrcrft.dbf',
  '/usr20/dbf/ts_fnd_use1.dbf',
  '/usr20/dbf/ts_fnd_use2.dbf',
  '/usr21/dbf/its_fnd_use1.dbf',
  '/usr21/dbf/its_fnd_use2.dbf',

ALTER DATABASE OPEN resetlogs;
:q
dafismir.jccbi.gov> Received on Fri Oct 04 1996 - 00:00:00 CEST