Re: start a crashed database?

Good point - forgot about that 1

startup pfile= location of ini file

Alex

Doug Cowles wrote in message <378D6F28.F328B04_at_bigfoot.com>...
>How can you change the default location for init file? On our systems
>it's in $ORACLE_HOME/rbs I think.. is that default? AIX 4.2 Oracle 8.0.5
>
>- Dc.
>
>Pete Sharman wrote:
>
>> 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
>>
>> -----------------------------------------------------------------------
-
>>
>> Pete Sharman <psharman_at_us.oracle.com>
>> Project Manager
>> Oracle University, Consulting and Vertical Education
>> Oracle Corporation
>>
>> Pete Sharman
>> Project Manager
>> Oracle University, Consulting and Vertical Education
>> Oracle Corporation
>> 500 Oracle Parkway M/S OPL-B1024

`JÇ
>> Redwood Shores

Ê
>> California



>> 94065
>> USA
>> **** The statements and opinions expressed here are my **** **** own
and do not necessarily represent those of **** **** Oracle Corporation. **** "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA
>> Additional Information:
>> Last Name Sharman
>> First Name Peter
>> Version 2.1
>
>
>
Received on Thu Jul 15 1999 - 05:18:12 CDT