What can be done when I have all the datafiles with me, but still can't get Oracle to start? Is creating a new control file a solution to get my database working? Please advise. (The previous backup dmp file that I have is very old -- about two months old.)
I would try to start the database again. Then look in your Alert Log located in the directory specified by your BACKGROUND_DUMP_DEST parameter. This should give more details as to why your database could not start. It might even point to a trace file which can give further information.
Once you have more information, feel free to post to this forum again.
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