Online Recovery of User Tables Using Flashback Table
First Claim
Patent Images
1. A computer-implemented method comprising:
- receiving a request to restore a database object to a state as of an earlier point in time;
using a processor to restore the database object to the earlier point in time by reversing changes introduced into the database object after the earlier point in time; and
displaying the database object restored to the earlier point in time on a display device or storing the database object restored to the earlier point in time in a data structure on a computer readable medium.
0 Assignments
0 Petitions
Accused Products
Abstract
A method and apparatus for updating databases are disclosed. In response to a flashback request, a database object is restored to a state as of a specified flashback time. The changes introduced into the database object are reversed in a sequence starting with a change introduced into the database object immediately before issuance of the flashback request and ending with a change introduced into the database object immediately after the specified flashback time.
87 Citations
31 Claims
-
1. A computer-implemented method comprising:
-
receiving a request to restore a database object to a state as of an earlier point in time; using a processor to restore the database object to the earlier point in time by reversing changes introduced into the database object after the earlier point in time; and displaying the database object restored to the earlier point in time on a display device or storing the database object restored to the earlier point in time in a data structure on a computer readable medium. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. An apparatus comprising:
-
means for receiving a request to restore a database object to a state as of an earlier point in time; and means for using a processor to restore the database object to the earlier point in time by reversing changes introduced into the database object after the earlier point in time. - View Dependent Claims (19, 20, 21, 22, 23, 24)
-
-
25. An article of manufacture comprising computer program code which can be executed to perform a process, the process comprising:
-
receiving a request to restore a database object to a state as of an earlier point in time; and using a processor to restore the database object to the earlier point in time by reversing changes introduced into the database object after the earlier point in time. - View Dependent Claims (26, 27, 28, 29, 30, 31)
-
Specification