Online recovery of user tables using flashback table
First Claim
Patent Images
1. A method comprising:
- in response to a flashback request, generating a flashback operation and restoring a database object to a state as of a flashback time by reversing the changes introduced into the database object after the flashback time specified in the flashback request.
1 Assignment
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
35 Claims
-
1. A method comprising:
in response to a flashback request, generating a flashback operation and restoring a database object to a state as of a flashback time by reversing the changes introduced into the database object after the flashback time specified in the flashback request. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 23, 24, 25)
-
22. An apparatus comprising:
means for generating a flashback operation in response to a flashback request, and means for restoring a database object to a state as of a flashback time by reversing the changes introduced into the database object after the flashback time specified in the flashback request. - View Dependent Claims (30, 31)
-
26. The apparatus comprising:
flashback module to restore a database object to a state as of a specified flashback time in response to a flashback request by identifying blocks of the database object that were changed since the flashback time;
identifying transactions that changed the blocks;
identifying undo records and restoring the database object to a state as of the flashback time utilizing the undo records.- View Dependent Claims (27, 28, 29)
-
32. An article of manufacture comprising:
-
a computer-readable medium having stored therein instructions which, when executed by a processor, cause a processing system to perform a method comprising;
generating a flashback operation in response to a flashback request and restoring a database object to a state as of a specified flashback time by reversing the changes introduced into the database object after a flashback time specified in the flashback request.
-
-
33. The article of manufacture comprising a computer-readable medium having stored therein instructions which, when executed by a processor cause a processing system to perform a method wherein the database object is a table.
-
34. The article of manufacture comprising a computer-readable medium having stored therein instructions which, when executed by a processor cause a processing system to perform a method wherein the flashback time is a wall clock time.
-
35. The article of manufacture comprising a computer-readable medium having stored therein instructions which, when executed by a processor cause a processing system to perform a method wherein the flashback time is a system commit number.
Specification