-
how to rollback the database
sir,
in my database, i made one mistake. unfortunately i hav updated 1000 records in that database. is it possible to restore that value into my database?
sir, i many so many queries in my database. then i didt save any transaction for that queries.
is it possible to restore?
regards
sanjeev
-
Sanjeev, you could do a point-in-time recovery if you have enabled archive logging for the database. If not, you would have to restore to a backup made before the update, assuming you have one.
The alternative is to simply reverse the update you committed, if that's possible. I say 'simply' hoping that it is a straightforward update - post back with further details and we'll try to help more. Best wishes.
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
1. Logminer
2. Flashback
3. TSPITR
Only you have archive log enabled
-
Re: how to rollback the database
Originally posted by sanjeev1983
sir,
in my database, i made one mistake. unfortunately i hav updated 1000 records in that database. is it possible to restore that value into my database?
sir, i many so many queries in my database. then i didt save any transaction for that queries.
is it possible to restore?
regards
sanjeev
post the db version dude - if you have 10g you can flashback
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|