Re: Database Cannot Start

Sim Thiam Soon <simts_at_swiftech.com.sg> wrote:
>Hello,
>
>We lost one of the system control file. This result in the database not
>able to startup after it was brought down. This problem occurs 3 times
>this year.
>
>Oracle helpdesk recommends to reinstall Oracle and create new databases.
>This results in the loss of all data. We have backup all system files as
>well as data files the day before.
>
>What is the best way to get the database up?
>
>Anyone can help?

HI there,

Since you have all data files intact, you can create a new control file at startup mount stage.

The above command will create a new control file for the database. After creating the file,you can multiplex the file and take a clean offline backup.

Regards

N.Prabhakar Received on Sat Nov 23 1996 - 00:00:00 CET