http://www.dbasuppor....php/t-20763.html
recover database until time '2001-02-05:12:40:00'; time being before the delete
ya got archive logs?
http://www.dbasuppor....php/t-20763.html
recover database until time '2001-02-05:12:40:00'; time being before the delete |
|
|
I didn't want to say
for fear of unsupportably burning the dude in charge of that stuff, but...
when we put this particular system up, apparently they forgot to set up the archiving stuff... so we got nothin'. That's two people on the hot seat who are currently sweating profusely. Hence the dbf analysis tool requirement... we need to be able to go looking into the files for the deleted data; since the db hasn't been packed yet (or whatever they call that process in oracle land) we should be able to get a lot if not all of it back... just need the tools that will let us look into the file and tell us what's actually in there. |
|
|
Im sure there is a way to do a table scan
spool on
select * from tablename where "whatever the fuck they call it"=='DELETED' spool off. thanx, bill |
I have an emergency here
- (jake123)
- (10)
- April 8, 2009, 01:27:05 PM EDT
whoops, dunno how useful the following is
- (boxley)
- (6)
- April 8, 2009, 01:43:39 PM EDT
Thanks
- (jake123)
- (5)
- April 8, 2009, 02:14:37 PM EDT
make copies before you do anything
-NT
- (boxley)
- (4)
- April 8, 2009, 02:15:26 PM EDT
Already done
-NT
- (jake123)
- (3)
- April 8, 2009, 02:27:38 PM EDT
File copies, not Oracle copies... you knew, but just in case
-NT
- (drook)
- (2)
- April 8, 2009, 03:40:22 PM EDT
Aye, we knew... ;)
- (jake123)
- (1)
- April 8, 2009, 03:43:51 PM EDT
No, I got nothin'
- (drook)
- April 8, 2009, 03:49:50 PM EDT
ya got archive logs?
- (boxley)
- (2)
- April 8, 2009, 03:56:03 PM EDT
I didn't want to say
- (jake123)
- (1)
- April 8, 2009, 04:14:58 PM EDT
Im sure there is a way to do a table scan
- (boxley)
- April 8, 2009, 06:29:20 PM EDT