rajat dey

• Feb 21st, 2006

 

I am not sure you can try this ... from your oracle main path in unix/linux/aix//sun environment copy init.ora file to pfile and edit it accordingly ,but you should have minimum idea about your system like controfile is residing . and then start the databse using from sqldbaor svrmgrl startup pfile=/path/ and then you create spfile from pfile ... i think it should work .

pankaj singh

• Apr 12th, 2006

 

if ur pfile and spfile both lost  then u can do one thing that check alert log file and check necessary parameter for pfile and take that necessary parameter from there and create pfile from that and u can start your database

mandygrewal

 Profile Answers by mandygrewal Questions by mandygrewal

• Jul 8th, 2008

 

could you please elaborate your answer.Alert log file contains all non default initializations  parameters. So how do we make pfile put of that?
Please answer in simple words.

g.mrunalini

 Profile Answers by g.mrunalini 

• Jul 26th, 2008

 

All the changes to the init.ora file is recorded in the alert.log file. So,go to the alert log file in bdump directory and delete the unnecessary parameters from the file and copy that file to the desired location and restart the database.

nagesh

• Jan 20th, 2012

 

We can get the pfile from the diagonostics_dest path, in this we select the appropriate parameters and then jst create a copy in $ORACLE_HOME/dbs location using another initdbname.ora
jst run it again its enough it works.

gopi

• Aug 8th, 2017

 

Check the alert log file, copy the pFile data and start the instance . suppose the data is not there in the alert log , we connect to RMAN and "startup nomount force;" and then we got some dummy pFile, modify accordingly for our requirements and then start instance with pFile or spFile