If you are missing your INIT.ORA configuration file and you have no backup, the only way to recover it is to manually re-create it. You can do this with any text editor on your system as this file is just a simple text file.
If you are using Oracle 9i or higher and using RMAN for your backups, then I suggest converting the INIT.ORA to the new SPFILE.ORA configuration file. RMAN can automatically back up this file for you, but cannot back up the INIT.ORA config file.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.