Re: Lost Control Files

From: Amar Duggasani <aduggasani_at_talus.net>
Date: 3 Jun 1998 18:42:04 GMT
Message-ID: <01bd8f1f$b26714a0$090610ac@aduggasani.aeronomics.com>

Try the following. I accidentally deleted control files on my development instance sometime ago and recovered using the following method.

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "DBNAME" NORESETLOGS NOARCHIVELOG     MAXLOGFILES 50
    MAXLOGMEMBERS 3
    MAXDATAFILES 150
    MAXINSTANCES 1
    MAXLOGHISTORY 100
LOGFILE

  GROUP 1 'log1.log' SIZE xxxxM, -- correct size of the database here
  GROUP 2 'log2.log' size xxxxM,
  GROUP 3 'log3.log' size xxxxM

DATAFILE
  'data1.dbf', -- Specify all the datafiles that the database had   'data2.dbf',
  so on
;
# Recovery is required if any of the datafiles are restored backups, # or if the last shutdown was not normal or immediate. RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN; Good luck

Amar Duggasani

Alan Brown <AlanBrown_at_millstream.compulink.co.uk> wrote in article <01bd8f18$ecc4cef0$c50399c2_at_mill-nt-01>...
> Due to a series of errors, some on my part, our Oracle 7.3 database has
> been left without any control files (and no backups) and we obviously
> cannot re-start the instance.
>
> All of the datafiles are intact. Is there any way to re-create the
controls
> files ... please!
>
> Regards
>
> Alan
>
Received on Wed Jun 03 1998 - 13:42:04 CDT