| Recovering the db [message #62360] |
Fri, 16 July 2004 21:51  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi,
Someone accidently dropped of the datafile belonging to a tablespace from our development server. As its development so we dont have its backup and db is running in NoArchive log mode. How can i recover the db now, even if i lost the data pertaining to the missing datafile it doesnt matter, i just want to bring the db up.
If anyone could guide me for the same it will be very helpful for me.
Thanks in advance
Vivek
|
|
|
|
| Re: Recovering the db [message #62370 is a reply to message #62360] |
Sat, 17 July 2004 19:37  |
jack
Messages: 123
Registered: September 2000
|
Senior Member |
|
|
There is no way that you can recover the database. While if you just want to bring the db up. you can take the lost file off with command
alter database datafile 'xxxxxxxxxxxxx' offline;
when your db at mount stage. then open the database.
hope it can help you
|
|
|
|
| Re: Recovering the db [message #62380 is a reply to message #62370] |
Sun, 18 July 2004 21:50 |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Since the DB is running in noarchivelog mode so, "alter database datafile 'xxxxxxxxxxxxx' offline" this statement will not work instead of that you should use "alter database datafile 'xxxxxxxxxxxxx' offline drop" command to offline the datafile and open the DB.
Daljit Singh
|
|
|
|
| Re: Recovering the db [message #62428 is a reply to message #62380] |
Wed, 21 July 2004 06:51 |
Harish Shanbhag
Messages: 19
Registered: July 2004
|
Junior Member |
|
|
U can recover file by using OS system dependent recover tools.
U got to use this tool immediately.otherwise it will b overwritten
Environmnet used was windows, regarding Linux i dont
know.
When the file is delted in winOS, it still exists, until it is overwritten by new file. OS hides the data by masking.
i have used to recover my techicakl docu(.doc,txt) successfully.
but not oracle datafiles.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
