US5991772A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for restoring a portion of a database
Assignee: Oracle International Corp
•
Filing: 1997-10-31
•
Granted: 1999-11-23
•
Expires: 2017-10-31
Abstract
Abstract A method and system allows a part of a database to be restored using a subset of the backup files stored for a database. A working copy of the data dictionary of the database, which stores data definitions, is restored using the latest backup file stored not later than the point in time specified and the names of tablespaces related to the table names specified are identified using the data dictionary. The files storing the database tablespaces specified and those identified as related are identified for restoration along with the point in time specified, so that the backup files may be used to restore the files to the latest time prior to the point in time specified. The database data files are [restored, they] are rolled forward from the point in time of the backup files to the point in time specified, using transaction logs restored with the database data files and the restored working data dictionary is updated as described by the transaction logs. The working data dictionary is then spliced into the database data dictionary, and the database control file is adjusted to point to the restored database data files.
Inventors
- 👤 Cornelius G Doherty
- 👤 Gregory Pongracz
- 👤 William Bridge
- 👤 Juan R Loaiza
- 👤 Mark Ramacher
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 21:38
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/07; G06F11/14; G06F11/1446; G06F11/1471; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 38
Claim 1
Independent Claim
80 words
A method of recovering at least a portion of a database comprising at least one table, comprising: receiving at least one identifier corresponding to the at least one table; identifying at least one first file having an identifier and corresponding to the at least one identifier received; adding less than all of at least one of the first files identified into a second file; and copying at least one of the at least one file identifiers into a third file.
Claim 2
Independent Claim
80 words
A method of recovering at least a portion of a database comprising at least one table, comprising: receiving at least one identifier corresponding to the at least one table; identifying at least one first file having an identifier and corresponding to the at least one identifier received; adding less than all of at least one of the first files identified into a second file; and copying at least one of the at least one file identifiers into a third file.
Claim 3
Dependent Claim
13 words
The method of claim 1 wherein the second file comprises a data dictionary.
Claim 4
Dependent Claim
13 words
The method of claim 2 wherein the third file comprises a control file.
Claim 5
Dependent Claim
53 words
The method of claim 2 wherein at least one of the at least one identifiers received comprises a point in time, the method additionally comprising locating a version of the table representing the table not after the point in time and nearest to the point in time than other versions of the table.
Claim 6
Dependent Claim
22 words
The method of claim 4 additionally comprising updating the version of the table to represent the table at the point in time.
Claim 7
Dependent Claim
19 words
The method of claim 5 wherein the updating step comprises applying at least one recorded transaction to the table.
Claim 8
Dependent Claim
23 words
The method of claim 6 wherein the updating step additionally comprises undoing at least one transaction not committed at the point in time.
Claim 9
Dependent Claim
33 words
The method of claim 5 additionally comprising: identifying at least one related table related to the at least one table; and updating the at least one related table to the point in time.
Claim 10
Dependent Claim
13 words
The method of claim 2 additionally comprising identifying at least one related table.
Claim 11
Dependent Claim
27 words
The method of claim 9 wherein at least one of the at least one related table identified comprises a table used by the at least one table.
Claim 12
Dependent Claim
26 words
The method of claim 9 wherein at least one of the at least one related table identified comprises a table using the at least one table.
Claim 13
Dependent Claim
37 words
The method of claim 9 wherein at least one of the at least one related table identified comprises a table using the at least one table as one selected from an index and a foreign key constraint.
Claim 14
Dependent Claim
27 words
The method of claim 9 wherein the at least one related table is stored in a file with at least one of the at least one tables.
Claim 15
Dependent Claim
141 words
A computer program product comprising a computer useable medium having computer readable program code embodied therein for recovering at least a portion of a database comprising at least one table, the computer program product comprising: computer readable program code devices configured to cause a computer to receive at least one identifier corresponding to at the least one table; computer readable program code devices configured to cause a computer to identify at least one first file having an identifier and corresponding to the at least one identifier received; computer readable program code devices configured to cause a computer to add less than all of at least one of the first files identified into a second file; and computer readable program code devices configured to cause a computer to copy at least one the at least one file identifiers into a third file.
Claim 16
Dependent Claim
141 words
A computer program product comprising a computer useable medium having computer readable program code embodied therein for recovering at least a portion of a database comprising at least one table, the computer program product comprising: computer readable program code devices configured to cause a computer to receive at least one identifier corresponding to at the least one table; computer readable program code devices configured to cause a computer to identify at least one first file having an identifier and corresponding to the at least one identifier received; computer readable program code devices configured to cause a computer to add less than all of at least one of the first files identified into a second file; and computer readable program code devices configured to cause a computer to copy at least one the at least one file identifiers into a third file.
Claim 17
Dependent Claim
15 words
The computer program product of claim 14 wherein the second file comprises a data dictionary.
Claim 18
Dependent Claim
15 words
The computer program product of claim 15 wherein the third file comprises a control file.
Claim 19
Dependent Claim
68 words
The computer program product of claim 15 wherein at least one of the at least one identifiers received comprises a point in time, the computer program product additionally comprising computer readable program code devices configured to cause a computer to locate a version of the table representing the table not after the point in time and nearest to the point in time than other versions of the table.
Claim 20
Dependent Claim
35 words
The computer program product of claim 17 additionally comprising computer readable program code devices configured to cause a computer to update the version of the table to represent the table at the point in time.
Claim 21
Dependent Claim
42 words
The computer program product of claim 18 wherein the computer readable program code devices configured to cause a computer to update comprise computer readable program code devices configured to cause a computer to apply at least one recorded transaction to the table.
Claim 22
Dependent Claim
46 words
The computer program product of claim 19 wherein the computer readable program code devices configured to cause a computer to update additionally comprises computer readable program code devices configured to cause a computer to undo at least one transaction not committed at the point in time.
Claim 23
Dependent Claim
57 words
The computer program product of claim 18 additionally comprising: computer readable program code devices configured to cause a computer to identify at least one related table related to the at least one table; and computer readable program code devices configured to cause a computer to update the at least one related table to the point in time.
Claim 24
Dependent Claim
26 words
The computer program product of claim 15 additionally comprising computer readable program code devices configured to cause a computer to identify at least one related table.
Claim 25
Dependent Claim
29 words
The computer program product of claim 22 wherein at least one of the at least one related table identified comprises a table used by the at least one table.
Claim 26
Dependent Claim
28 words
The computer program product of claim 22 wherein at least one of the at least one related table identified comprises a table using the at least one table.
Claim 27
Dependent Claim
39 words
The computer program product of claim 22 wherein at least one of the at least one related table identified comprises a table using the at least one table as one selected from an index and a foreign key constraint.
Claim 28
Dependent Claim
29 words
The computer program product of claim 22 wherein the at least one related table is stored in a file with at least one of the at least one tables.
Claim 29
Independent Claim
197 words
An apparatus for recovering at least one table of a database, the apparatus comprising: a related files identifier module, having an first input operatively coupled to receive a name of the at least one table, the related files identifier module for identifying and providing at an output at least one name of at least one file, at least one of the at least one file comprising at least one of the at least one table; a working storage; a file restorer module coupled to the working storage and having a first input coupled to the related files identifier module output for receiving the at least one name, the file restorer module for restoring into the working storage coupled to an output at least one file corresponding to the name received at the file restorer module input and at least one first data dictionary; a data dictionary splicer module having an input operatively coupled to receive a portion comprising less than all of a second data dictionary corresponding to the at least one table, the data dictionary splicer for replacing less than all of the first data dictionary with the portion received at the data dictionary splicer output.
Claim 30
Independent Claim
197 words
An apparatus for recovering at least one table of a database, the apparatus comprising: a related files identifier module, having an first input operatively coupled to receive a name of the at least one table, the related files identifier module for identifying and providing at an output at least one name of at least one file, at least one of the at least one file comprising at least one of the at least one table; a working storage; a file restorer module coupled to the working storage and having a first input coupled to the related files identifier module output for receiving the at least one name, the file restorer module for restoring into the working storage coupled to an output at least one file corresponding to the name received at the file restorer module input and at least one first data dictionary; a data dictionary splicer module having an input operatively coupled to receive a portion comprising less than all of a second data dictionary corresponding to the at least one table, the data dictionary splicer for replacing less than all of the first data dictionary with the portion received at the data dictionary splicer output.
Claim 31
Dependent Claim
39 words
The apparatus of claim 27 wherein the at least one name of the at least one file provided by the related files identifier module comprises a related table related to at least one of the at least one table.
Claim 32
Dependent Claim
27 words
The apparatus of claim 28, wherein at least one of the at least one related table identified comprises a table used by the at least one table.
Claim 33
Dependent Claim
26 words
The apparatus of claim 28 wherein at least one of the at least one related table identified comprises a table using the at least one table.
Claim 34
Dependent Claim
37 words
The apparatus of claim 28 wherein at least one of the at least one related table identified comprises a table using the at least one table as one selected from an index and a foreign key constraint.
Claim 35
Dependent Claim
55 words
The apparatus of claim 28 wherein: the file restorer module comprises a second input operatively coupled to receive a point in time; and the file restored comprises a version of the file stored not later than the point in time and closer to the point in time than a plurality of versions of the file.
Claim 36
Dependent Claim
66 words
The apparatus of claim 28, additionally comprising a data base roll forward module coupled to the working storage and having an input operatively coupled to receive the point in time, the data base roll forward module for updating at least one table in at least one of the files in the working storage to represent the at least one table as of the point in time.
Claim 37
Dependent Claim
55 words
The apparatus of claim 33 additionally comprising a database undo module having an input operatively coupled to receive the point in time and coupled to the working storage, the database undo module for undoing transactions uncommitted in the at least one table updated by the database roll forward module as of the point in time.
Claim 38
Dependent Claim
53 words
The apparatus of claim 27 additionally comprising a production control file adjuster module coupled to a storage containing a control file for the database, the production control file adjuster for adjusting the control file to reference at least one file corresponding to a file restored to the working storage by file restorer module.
References Cited (Backward Citations)
US4817050A
Cited
US4791561A
Cited
US4945474A
Cited
US5295256A
Cited
US5455946A
Cited
US5678046A
Cited
US5721915A
Cited
US5740457A
Cited
US5826257A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-11-22 | 2003-05-24 | 2003-11-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-11-22 | 2007-05-24 | 2007-11-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-11-22 | 2011-05-24 | 2011-11-23 | $7700.00 | Window Closed / Lapsed |