Re: start a crashed database?

Karsten

It appears you have lost a control file. Check in the file $ORACLE_HOME/dbs/initSID.ora for the locations of control files.
If you have more than 1 specified (I hope :-) ) then comment out the location of the one with the problem.
Try to start the database again.
If this is successful then shut the database down and copy the good control file to the location of the 'bad' one (assuming the disk it is located on is ok)
startup the database again.

If you only have one control file then : you need to find the location of all your data files and log files with this information you can now recreate the control file using 'CREATE CONTROLFILE' command
explained in the Administrator's Guide

Good Luck!

Alex

unity_ag_at_my-deja.com wrote in message <7mffq2$iun$1_at_nnrp1.deja.com>...
>Hi
>
>My oracle database crashed because of power
>failure. I have to start or to recover it. The
>following messages appear while starting up the
>database with the SVRMGRL of ORACLE.
>
>I try to start the database with the command
>"startup open" or "startup mount" the ORACLE
>instance started, the used space will be displayed
>and this error messages:
>ORA-00205: error in identifying control file
> '.../control01.ctl'
>ORA-07360: sfifi: stat error, unable to obtain
> information about file.
>
>What can I do to start or recover the database?
>What should I do to create new control files which
>allows to start the database?
>
>Please help to explain.
>
>Thanks
>
>Karsten Spangardt
>
>mailto:spangardt_at_unity.de
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jul 13 1999 - 09:40:16 CDT