RE: How can we start the database if both the pfile an...
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 .
RE: How can we start the database if both the pfile an...
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
RE: How can we start the database if both the pfile and spfile is lost?
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.
RE: How can we start the database if both the pfile and spfile is lost?
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.
