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 in a database system to the earlier point in time by reversing changes introduced into the database object after the earlier point in time, in which dependencies between database objects are considered to avoid consistency violations when the database object is restored; 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 non-transitory 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.
-
Citations
34 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 in a database system to the earlier point in time by reversing changes introduced into the database object after the earlier point in time, in which dependencies between database objects are considered to avoid consistency violations when the database object is restored; 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 non-transitory computer readable medium. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. An apparatus comprising:
-
a processor to; receive a request to restore a database object to a state as of an earlier point in time; and restore the database object in a database system to the earlier point in time by reversing changes introduced into the database object after the earlier point in time, in which dependencies between database objects are considered to avoid consistency violations when the database object is restored. - View Dependent Claims (20, 21, 22, 23, 24, 25, 26)
-
-
27. An article of manufacture comprising a non-transitory computer-readable memory or storage medium having stored therein instructions which, when executed by a processor to perform a process, causes a processing system to perform the process comprising:
-
receiving a request to restore a database object to a state as of an earlier point in time; and restoring the database object in a database system to the earlier point in time by reversing changes introduced into the database object after the earlier point in time, in which dependencies between database objects are considered to avoid consistency violations when the database object is restored. - View Dependent Claims (28, 29, 30, 31, 32, 33, 34)
-
Specification