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

If you have a backup of the old alert.log file, the modified init.ora parameters are in it.

HTH
Matthias Hoys Received on Mon Aug 01 2005 - 10:20:05 CDT