Re: How to rebuild Init file

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 Received on Mon Aug 01 2005 - 09:32:51 CDT