Q
Problem solve Get help with specific problems with your technologies, process and projects.

Undoing accidental update after two days

Two days back I made an accidental update on a large table. What are the different ways to handle this type of situation if two or more days have passed?

I am using Oracle 9i R2. Two days back I made an accidental update on a large table. I tried to find all sorts of ways to undo this update. I tried FlashBack query but the unwanted changes persist. What are the different ways to handle this type of situation if two or more days have passed?
Flashback Query will only be able to go as far back as the number of seconds specified by the UNDO_RETENTION parameter. It is unlikely that you have configured UNDO_RETENTION for 48 hours. You have two options, both of which require archived redo logs. One, restore from a backup prior to the change and then roll forward to the point in time before the change occurred. This will result in incomplete recovery and you will lose all changes since that time. Two, use Oracle's Log Miner to read the archived redo logs for the SQL statements to UNDO the transaction. I would favor the second option in this case.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close