| 发明名称 |
APPARATUS AND METHOD FOR RECOVERING DATA IN ORACLE DATABASE |
| 摘要 |
Provided is an apparatus and method for recovering data in an oracle database, in which the data restoring apparatus receives a system file from a database, inquires a system table included in the system file to deduct schema information about at least one table in the system file, sorts a deleted table among the at least one table based on the schema information, searches and deducts a data block including the deleted record by means of an object ID of the sorted table, and identifies and extracts the deleted record from the deducted data block to restore the deleted record. |
| 申请公布号 |
US2015278023(A1) |
申请公布日期 |
2015.10.01 |
| 申请号 |
US201514666995 |
申请日期 |
2015.03.24 |
| 申请人 |
KOREA UNIVERSITY RESEARCH AND BUSINESS FOUNDATION |
发明人 |
LEE Sang Jin;Choi Jong-Hyun;Lee Kuk Heon;Jeong Doo Won |
| 分类号 |
G06F11/14;G06F17/30 |
主分类号 |
G06F11/14 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A method for restoring data, comprising:
by an apparatus for restoring data (hereinafter, referred to as a data restoring apparatus), receiving a system file from a database; by the data restoring apparatus, inquiring a system table included in the system file to deduct schema information about at least one table in the system file; by the data restoring apparatus, sorting a deleted table among the at least one table based on the schema information; by the data restoring apparatus, searching and deducting a data block including the deleted record by means of an object ID of the sorted table; and by the data restoring apparatus, identifying and extracting the deleted record from the deducted data block to restore the deleted record. |
| 地址 |
Seoul KR |
