GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Memory Management

 Print  |  
Question:  How can we start the database if both the pfile and spfile is lost?



July 07, 2008 11:30:37 #4
 g.mrunalini   Member Since: February 2008    Total Comments: 8 

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.
     

 

Back To Question