need to recover database

[kburrows]

Hello Everyone,

A sql statement was run about 1 hour ago (how can I tell exactly when it was run?). I need to undo that statement or recover to the point just before that statement was run. I am running 8.0.5 in archivelog mode. What would be the best way to go about this. I am new so please be specific.

Thanks
Kathy

[marist89]

restore your last complete backup and use an incomplete recovery until 1 minute before your sqlstatement was run.

[kburrows]

Thank You,

That was the option I was looking at, but have never done before. Problem I am concerned with is that the time is approximately. Is there a way to tell exactly when that statement was executed, I want to get as close as possible?

[sreddy]

log Miner is an option to undo that statement if you are familiar with that option. You need 8i database to do that.