RECOVER A LOST DATAFILE WITHOUT USING RMAN [message #526912] |
Thu, 13 October 2011 12:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/ec51add3a4ee699f86b09f8725d4cecb?s=64&d=mm&r=g) |
inception
Messages: 7 Registered: October 2011
|
Junior Member |
|
|
I have no backup taken in my oracle server.
Today morning i created a data file and unknowingly deleted it.
Now i need to restore the datafile with its contents without using RMAN. Iam confused could anyone help me in figuring out.
|
|
|
|
|
|
|
|
|
|
|
|
Re: RECOVER A LOST DATAFILE WITHOUT USING RMAN [message #526926 is a reply to message #526925] |
Thu, 13 October 2011 13:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hi - as you are in archivelog mode, it is no big deal. You need to create a new datafile, based on the defnition of the existing (deleted) datafile, then recover it by applying all the archivelogs since it was first created.
The routine is described in te docs, but here it is:
shutdown immediate;
startup mount;
create datafile 'the datafile name' as 'the data file name';
recover datafile 'the datafile name';
[update: correction, the third command above should read
alter database create datafile 'the datafile name' as 'the data file name';
sorry about that.]
[Updated on: Thu, 13 October 2011 15:13] Report message to a moderator
|
|
|
|
|
|
|