Post #306,993
4/8/09 1:27:05 PM
|
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....
|
Post #306,994
4/8/09 1:43:39 PM
|
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
|
Post #306,997
4/8/09 2:14:37 PM
|
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...
|
Post #306,999
4/8/09 2:15:26 PM
|
make copies before you do anything
|
Post #307,000
4/8/09 2:27:38 PM
|
Already done
|
Post #307,006
4/8/09 3:40:22 PM
|
File copies, not Oracle copies... you knew, but just in case
--
Drew
|
Post #307,008
4/8/09 3:43:51 PM
|
Aye, we knew... ;)
Still working on it?
|
Post #307,014
4/8/09 3:49:50 PM
|
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
|
Post #307,017
4/8/09 3:56:03 PM
|
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
|
Post #307,019
4/8/09 4:14:58 PM
|
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.
|
Post #307,027
4/8/09 6:29:20 PM
|
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
|