Re: How to rebuild Init file

"Maxim Demenko" <mdemenko_at_arcor.de> wrote in message news:42ee33a6$0$6976$9b4e6d93_at_newsread2.arcor-online.net...
> yoyo schrieb:
> > Hello,
> > this may sound very silly, but I need to ask anyway, because I spent 1/2
> > day already trying to figure it out, mabey I'm missing something basic.
> > I have an Oralce 8.1.7 database on AIX. It was backed up regurlary, but
> > in my silliness, I never backed up the init.ora file for it.
> > Well, the drive it was on crapped out, and upon replacment, my database
> > (of course) wound't start, no init file. Is there an easy way to rebuild
> > this file? I tried a generic OOB init file, but it doesn't work (didn't
> > think it would).
> > It's not a super important database, we mostly use DB2 now, this was
> > just left over from years ago and get's used only occasionally now, it's
> > not big at all.
> > Any help is appreciated.
> > Thanks
> > Ken
>
> Things, you should know about your database are:
> sid, database name, location of controlfiles and block size (there is
> only 5 possibilites, you can try all of them if you don't know it)
> Also ( is not a requirement , but is more comfortable )
> background_dump_dest can be set to avoid default destination
> You can try to start your instance with only that parameters and do
> tail -f alert_<SID>.log
> So, you will just see, if oracle complains about some parameter and
> correct them if needed.
>
> Best regards
>
> Maxim

Search your alert log for startup entries. You'll find all your non-default init.ora parameters there.

Look for something that kinda resembles this: Starting up ORACLE RDBMS Version: 8.1.5.0.0. System parameters with non-default values:

  processes                = 50
  shared_pool_size         = 52428800
  java_pool_size           = 20971520

I hope you didn't loose your alert log as well. :-D

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.