Re: start a crashed database?

Doug

Slight typo there I think. The default is $ORACLE_HOME/dbs, not rbs.

I've found the easiest way to store the init file elsewhere is to use one of the least well recognized clauses in the init.ora file - ifile. With this, you can tell Oracle to load the values in another parameter file, so you can delete all the entries in the default location's init.ora and simply put the line ifile=/my_preferred_location_preferably_OFA_compliant/init.ora.

ifile can be really useful when it's used properly, and this is one of the things that makes it so useful.

HTH. Pete

Doug Cowles wrote:

> 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

--
Regards

Pete

Received on Thu Jul 15 1999 - 10:34:56 CDT