Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: start a crashed database?

Re: start a crashed database?

From: Rob Calfee <trace_at_primenet.com>
Date: Tue, 13 Jul 1999 16:46:05 GMT
Message-ID: <378b6d37.9384456@news.primenet.com>


Good Point Pete.

On Tue, 13 Jul 1999 09:45:44 -0700, Pete Sharman <psharman_at_us.oracle.com> wrote:

>This is a multi-part message in MIME format.
>--------------04241022BE6D2C213F7E48A4
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>There may be a more straight forward answer than the other two posters
>have suggested (both are equally valid, though). Before looking for a
>lost control file, is the startup normally done with a parameter file
>that is NOT in the default location? If you don't specify the
>non-default location with the pfile= syntax, and there is no parameter
>file in the default location, Oracle will attempt to start with default
>values for many parameters, including control_files. See if you have a
>scripted startup that says startup pfile=/some_other_location/init.ora
>and use that.
>
>HTH.
>
>Pete
>
>unity_ag_at_my-deja.com wrote:
>
>> 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.
>
>--
>Regards
>
>Pete
>
>
>--------------04241022BE6D2C213F7E48A4
>Content-Type: text/x-vcard; charset=us-ascii;
> name="psharman.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Pete Sharman
>Content-Disposition: attachment;
> filename="psharman.vcf"
>
>begin:vcard
>n:Sharman;Peter
>tel;fax:+1.650.633.1669
>tel;work:+1.650.607.0109
>x-mozilla-html:FALSE
>url:http://www.oracle.com
>org:Oracle University, Consulting and Vertical Education;Oracle Corporation
>adr:;;500 Oracle Parkway M/S OPL-B1024;Redwood Shores;California;94065;USA
>version:2.1
>email;internet:psharman_at_us.oracle.com
>title:Project Manager
>note;quoted-printable:=0D=0A=0D=0A **** The statements and opinions expressed here are my **** =0D=0A **** own and do not necessarily represent those of **** =0D=0A **** Oracle Corporation. =20 ****=0D=0A=0D=0A"Controlling application developers is like herding cats." =0D=0AKevin Loney, ORACLE DBA Handbook =0D=0A=0D=0A"Oh no it's not! It's much harder than that!" =0D=0ABruce Pihlamae, long term ORACLE DBA
>x-mozilla-cpt:;-1
>fn:Pete Sharman
>end:vcard
>
>--------------04241022BE6D2C213F7E48A4--
>

Rob Calfee
DBA
rcalfee_at_incsystem.com Received on Tue Jul 13 1999 - 11:46:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US