recover [message #56894] |
Sat, 03 May 2003 09:02 |
Abhi Malhotra
Messages: 2 Registered: May 2003
|
Junior Member |
|
|
hi ... Friend
I have a Question about database recovery ......
suppose cold backup has been taken on sunday ...
and monday i add a new tablespace
[[ did not take any backup of controlfile and datafile ]]
and tuesday i
drop this tablespace ...accedently ..
can i recover this tablespace ..
Regards ..
|
|
|
|
|
Re: recover [message #56898 is a reply to message #56895] |
Sun, 04 May 2003 03:41 |
oracle guy
Messages: 2 Registered: May 2003
|
Junior Member |
|
|
yes Friend ..
my db is in archivelog..
at sunday --- -- > ... cold backup
and after that i add a tablespace and
create a table with in it ...
after that drop the tablespace..
mean i did not take any backup of datafile and controlfile ... and now i have all the archivelogs..
and current controlfile .. with this tablespace entry ..
how i can recover my db
|
|
|
Re: recover [message #56899 is a reply to message #56898] |
Sun, 04 May 2003 09:56 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
Hi,
as u have all the archivelogs with u, I think u can issue a command something like
Alter database create datafile as 'Original datafile path'.
I am not sure of the syntax, Let us c if some one else can come out the syntax..
sai
|
|
|