Re: Database Cannot Start

Sim Thiam Soon 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?

Sim,

To recover from a lost control file as you have described, copy one of the remaining valid control files over the “bad” control file and start the database. A corrupt control file should not require a database rebuild ( Personal oracle excluded )

If you have had this problem three (3) times before I suggest you should investigate why you are loosing control files.

PS try not to believe the first thing Oracle support tell you.

Gary Piper

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ Gary Piper ( gpiper_at_ozemail.com.au )
http://www.ozemail.com.au/~gpiper/

Phone  : 61-3-9827-4276
Fax    : 61-3-9827-4917
Mobile : 0419-352-584 ( International 61-419-352-584 )
----------------------------------------------------------------------