user11979518 wrote:Copy the parameters from the alert.log , save it as a new init.ora and you are good to go.
I am running Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production on RHEL5.
I lost all my files under $ORACLE_HOME/dbs but my database is still up and running.
How can I recreate these files?
JohnWatson wrote:The Best Way to create missing pfile :) Thanks For Sharing
spool the result of this query to a new pfile:
select name||'='||value from v$parameter where isdefault = 'FALSE';
Oracle Certified Master DBA
Edited by: JohnWatson on Feb 27, 2013 12:11 PM
corrected the predicate in my query