Re: Lost Control Files

Do a STARTUP MOUNT.
Then issue a create controlfile statement with all the appropriate parameters.

In the future you may want to issue the following statement anytime you make a change to the database:
alter database backup controlfile to trace noresetlogs;

It generates the create controlfile statement in a trace file in the user dump destination directory.
Alan Brown wrote in message <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 Mon Jun 08 1998 - 19:12:07 CDT