Recovered Records Should be up to date as when they were deleted.
Asked
Active
Viewed 558 times
0
-
What is the question? Do you want to recover deleted records after a commit? – Tunaki Feb 28 '15 at 09:32
-
Do you have flashback enabled, and were they deleted recently - within your flashback window? – Alex Poole Feb 28 '15 at 09:35
-
Yes. But records Should be up to date as when they were deleted. @Tunaki – Viplove Sharma Feb 28 '15 at 09:35
-
No flashback enabled.. @AlexPoole – Viplove Sharma Feb 28 '15 at 09:37
-
You're looking at a point-in-time recovery then, assuming you have proper backups and archived redo logs; but you'll lose changes after that point. There's no magic solution (without the magic of flashback). – Alex Poole Feb 28 '15 at 10:39
-
possible duplicate of [How to rollback my DB changes after a commit?](http://stackoverflow.com/questions/27309730/how-to-rollback-my-db-changes-after-a-commit) – Jon Heller Mar 01 '15 at 03:12
1 Answers
2
You could make use of the FLASHBACK QUERY.
I answered a similar question here https://stackoverflow.com/a/27309814/3989608
You could go back as far as depending on the settings of the UNDO_RETENTION parameter.
A quote from T.Kyte regarding flashback query:
flashback query has been enabled in the database for many many many years.
We call it Multi-versioning and it gives us our consistent read and non-blocking reads.That means -- you've been doing flashback query for years.
You do not need to "enable it", it is an intrisic feature/function of the database that you cannot in any way "disable"!
It is ALWAYS on.
Link from AskTom https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6135698985750
Community
- 1
- 1
Lalit Kumar B
- 47,486
- 13
- 97
- 124