Thanks for the question, Gyan.
Asked: March 01, 2017 - 12:08 pm UTC
Last updated: March 02, 2017 - 5:15 am UTC
Version: 11.2.0.4
Viewed 1000+ times
You Asked
Unfortunately during the testing of spfile and pfile, I have deleted the both files spfile and pfile, now database does not start ?? How to solve this issue, please help me
and Connor said...
You can create the most basic of init.ora files to get your instance up and running, eg
For example, something like this:
control_files=("control01.ctl", "control02.ctl")
db_block_size=8192
db_name=mydb
diagnostic_dest=c:\oracle
undo_tablespace=UNDOTBS1
would probably be enough to get you up and running, as long as you know where your controlfiles are. If you look in your alert log from the last time your started up, it normally will list all of the important parameters that were used to start the instance, so this gives a good starting point.
If you dont have even that, you'd need to have an RMAN backup of your controlfile, because then you could do something like:
startup nomount
which just initiates the memory structures and then restore the controlfile from an RMAN backup.
Good luck !
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment