Thanks for the question, Shahbaz.
Asked: April 22, 2017 - 7:22 pm UTC
Last updated: May 11, 2017 - 11:20 am UTC
Version: 11g release 2
Viewed 1000+ times
You Asked
Dear Sir,
I recover my database from my backup files manually by simple copy paste command in redhat linux.
Now my database is opening till mount stage only.
Whenever i try to come in open stage it shows an error of to use resetlogs or noresetlogs,
when i gave resetlogs it says database needs media recovery,
after giving recover database using backup controlfile it shows an error of datafile which is named as unnamed00015 and saying to rename to correct file( error no- ORA-01111, ORA-01110, ORA-01157)
how to correct the data file name and open my database normally?
i am the only one using this database.
your help will be much appreciated.
Thanks and Regards
Shahbaz
and Connor said...
You should be able to do:
alter database create datafile 15 as '/disk/path/real_datafile_name.dbf';
recover database using backup controlfile;
alter database open resetlogs;
I say *should* because we didnt get a lot of information to work with here.
Is this answer out of date? If it is, please let us know via a Comment