snippetMinor
How to recover deleted records with minimal downtime?
Viewed 0 times
downtimewithrecordsrecoverdeletedhowminimal
Problem
In an OLTP environment that cannot tolerate downtime, suppose if 100 records are deleted from a table, how do we recover them?
One way to recover the deleted records is to restore the database and/or tablespace then rollforward to point-in-time.
One way to recover the deleted records is to restore the database and/or tablespace then rollforward to point-in-time.
Solution
I believe DB2 Recovery Expert is the best option.
In the case of a dropped object, or recovery to a specific point in time, you should use the "Recovery" option. The "undo SQL" option performs Log Analysis, which only affects data, not structure.
Please check IBM's official webpage : DB2 Recovery Expert
In the case of a dropped object, or recovery to a specific point in time, you should use the "Recovery" option. The "undo SQL" option performs Log Analysis, which only affects data, not structure.
Please check IBM's official webpage : DB2 Recovery Expert
Context
StackExchange Database Administrators Q#141525, answer score: 4
Revisions (0)
No revisions yet.