Recovering offline dropped datafile - Very Very Urgent [message #115210] |
Fri, 08 April 2005 03:08 |
srix5
Messages: 11 Registered: March 2005 Location: Bangalore
|
Junior Member |
|
|
Hi All,
My Oracle Database (8.1.7) is running in NOARCHIVELOG mode under unix.
To recover some space in filesystem i offline dropped some datafiles belongs to a tablespace. Also i deleted from the os also. Eventhouhg I offline dropped those files, oracle still asking for that particular datafiles. I don't know why...? Now I need those datafiles. I don't have backup of that particular datafiles.
I tried to recreate the datafile using ALTER DATABASE CREATE DATAFILE <FILENAME> AS <FILENAME> command. This command recreated the datafile. But i found its status as RECOVER. So, i tried to recover the same. Oracle is asking for some arch19.dbf for recovering which is never created (arch19.DBF). I tried with both AUTO and CANCEL options. But it is not recovering as my database is in NOARCHIVELOG mode.
Is there any possibilities to recover this datafile...?
- Sridhar Krishnan.
|
|
|
|