We lost both spfile and pfile ..How to start the DB?
can we start the DB using below process ....
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
Oracle Version 9i, OS Version :- solaris 5.9
Kindly suggest .....
Take another init.ora from another database that's the same release and has archiving on/off (depending on what it was for the database missing spfile/pfile). Change only the db_name, instance_name, archive_dest, background_dump, core_dump, user_dump, and control_files. The values should already be known, or can be easily found.
That's exactly what you do. The alert log is a backup of the non-default parameters set in your now-lost configuration files, so if you cut out the last record of them (a new list is generated at every startup, so you want the one generated by the last startup), and paste that into a text file called initXXX.ora, stored in ORACLE_HOME/dbs (or the Windows equivalent), where 'XXX' is your ORACLE_SID, you'll now have a new configuration file that is functionally-equivalent to the one you lost.
Then you can just 'create spfile from pfile' to re-create a lost spfile.
I'd say the advice you've also received to 'borrow another init.ora from another database' is likely to be a bad way to go. It assumes you've got multiple databases, for a start. And then it assumes that your other databases are configured similarly to the one you're having trouble with. Great news if so, but a big fat problem if not. The alert log is a much more sensible way to go, I think you'll find, and is guaranteed to get you functionally back to exactly where you used to be. Borrowing another database's init.ora only gets you functionally back to where that other database is at.