Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> case of MISSINGnnn datafile
List,
when alter database open, it gives
file '/sdfsdf/' need media recovery....so i offline the file using
alter database datafle .... offline drop;
but i cannot still open the db !! it returns the same erorr !! so i re-created the controlfile WITHOUT this file.. but the oracle returned file MISSINGnnnn please rename to correct name etc...error..
what to do ?
Help
7.3.4, noarchivelog Received on Thu Sep 28 2000 - 07:51:43 CDT
![]() |
![]() |