If you have a valid SPFile, the database should start with
startup;
If you have pfile (this is the text one), use
startup pfile='c:\blahblah.ora';
When you are connected to the database, you cna create pfile form spfile
using
create pfile from spfile;

Rgds,
Yavor

Almyeed wrote:

> Hi All, Iam having oracle9i on winnt platform today when i shutdown my
> instance & tried to restart it i found that my pfile is missing but my
> spfile is intact. iam not able to start my database & i don't have backup
> of my pfile..... please help me starting the database its very
> urgent..... Thanks & Regards
> Almyeed
Oracle LazyDBA home page