• Home
  • mandygrewal Answers

Answered Questions

  • Feb 15 2006
    11:10 AM
    7609
    10

    How can we start the database if both the pfile and spfile is lost?
    • Naveen

    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

    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.