IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New I have an emergency here
Fortunately, I'm not the guy on the hot seat for this one...

He managed to delete a LOT of rows. They've been committed, and for reasons I can't fathom, there are no backups of the database.

Now, as far as I'm aware, the database hasn't been packed, so the data should be in there somewhere. However, I have no idea how to be able to get to it, outside of one of those extremely expensive tools like DUL or DUDE.

The database in question is Oracle 8.

If anybody knows of any way (or any tools) to be able to look at the actual database files and recover data out of them, I'd really appreciate it.

Oh yeah, and I'm so very very glad that I'm not the guy on the hot seat for this one....
New whoops, dunno how useful the following is
Hi ,
Suppose I deleted all rows of a table and committed it , say at 2PM.
How can I recover them so that it does not affect other connected users?
1. Use TSPITR ( table space point in time recovery)

2.Use conventional incremental export and then import (I personally think this is not correct , as doing an export now will not contain the rows ) .

3.Use flashback query to retrieve rows deleted

Please suggested two out of these there.
Report message to a moderator
Send a private message to this user
- Re: To recover deleted rows [message #357695 is a reply to message #357673 ] Thu, 06 November 2008 05:01 Go to previous message
Michel Cadot
Messages: 24859
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member

1, 3

Regards
Michel
New Thanks
Looks like that functionality is not supported by our version of oracle. Bleah.

Thanks for trying, though!

My boss is figuring out the file format now.... we'll see how well that goes. 'Course, if anybody else happens to know of any magic incantations, we'll give it a shot...
New make copies before you do anything
New Already done
New File copies, not Oracle copies... you knew, but just in case
--

Drew
New Aye, we knew... ;)
Still working on it?
New No, I got nothin'
I just know that in the midst of an "oh shit" moment it's easy to forget things that are normally obvious.
--

Drew
New 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
New 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.
New 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)
         whoops, dunno how useful the following is - (boxley) - (6)
             Thanks - (jake123) - (5)
                 make copies before you do anything -NT - (boxley) - (4)
                     Already done -NT - (jake123) - (3)
                         File copies, not Oracle copies... you knew, but just in case -NT - (drook) - (2)
                             Aye, we knew... ;) - (jake123) - (1)
                                 No, I got nothin' - (drook)
         ya got archive logs? - (boxley) - (2)
             I didn't want to say - (jake123) - (1)
                 Im sure there is a way to do a table scan - (boxley)

i only type in lowercase because i hate capitalism.
87 ms