ATE463797T1 - DATABASE DATA RECOVERY SYSTEM AND METHOD - Google Patents
DATABASE DATA RECOVERY SYSTEM AND METHODInfo
- Publication number
- ATE463797T1 ATE463797T1 AT04779217T AT04779217T ATE463797T1 AT E463797 T1 ATE463797 T1 AT E463797T1 AT 04779217 T AT04779217 T AT 04779217T AT 04779217 T AT04779217 T AT 04779217T AT E463797 T1 ATE463797 T1 AT E463797T1
- Authority
- AT
- Austria
- Prior art keywords
- database
- snapshot
- data
- error
- files
- Prior art date
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a system and method of data restoration, for instance, after the occurrence of a user error. In particular, snapshot database can be maintained that stores a copy of database data. The snapshot database does not have to store a complete copy of all data on a source database, but rather shares data that is common to both but not necessarily identical. If an error occurs on the primary database then the database can be reverted back to a point in time prior to the error by replacing source database files with snapshot files. Additionally, an undo component can be employed in conjunction with the snapshot to approach an error to a finer grained point in time. In brief, the present invention can restore a database much faster and simpler, while utilizing less space and resources than conventional data restoration technologies.
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US54764104P | 2004-02-25 | 2004-02-25 | |
US10/833,541 US8095511B2 (en) | 2003-06-30 | 2004-04-28 | Database data recovery system and method |
PCT/US2004/024048 WO2005086032A1 (en) | 2004-02-25 | 2004-07-27 | Database data recovery system and method |
Publications (1)
Publication Number | Publication Date |
---|---|
ATE463797T1 true ATE463797T1 (en) | 2010-04-15 |
Family
ID=36773857
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
AT04779217T ATE463797T1 (en) | 2004-02-25 | 2004-07-27 | DATABASE DATA RECOVERY SYSTEM AND METHOD |
Country Status (3)
Country | Link |
---|---|
CN (1) | CN1784676B (en) |
AT (1) | ATE463797T1 (en) |
DE (1) | DE602004026422D1 (en) |
Families Citing this family (22)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8112664B2 (en) * | 2008-03-26 | 2012-02-07 | Symantec Operating Corporation | Using volume snapshots to prevent file corruption in failed restore operations |
US8412676B2 (en) * | 2008-10-21 | 2013-04-02 | Microsoft Corporation | Forgetting items with knowledge based synchronization |
CN102685733B (en) * | 2012-04-27 | 2016-08-03 | 王兰睿 | A kind of method and system for creating and safeguard mobile station information mirror database |
CN103870478B (en) * | 2012-12-12 | 2018-09-25 | 腾讯科技(深圳)有限公司 | A kind of method and device for restoring synchrodata |
CN103914359B (en) * | 2012-12-31 | 2017-09-26 | 中国移动通信集团浙江有限公司 | A kind of data reconstruction method and device |
US9589008B2 (en) * | 2013-01-10 | 2017-03-07 | Pure Storage, Inc. | Deduplication of volume regions |
GB2509930A (en) * | 2013-01-17 | 2014-07-23 | Ibm | Data backup recovery |
US9501501B2 (en) | 2013-03-15 | 2016-11-22 | Amazon Technologies, Inc. | Log record management |
US9514007B2 (en) | 2013-03-15 | 2016-12-06 | Amazon Technologies, Inc. | Database system with database engine and separate distributed storage service |
CN104156369B (en) * | 2013-05-14 | 2019-04-02 | 上海盛大网络发展有限公司 | A kind of database mirroring production method and a kind of database |
US9098453B2 (en) * | 2013-07-11 | 2015-08-04 | International Business Machines Corporation | Speculative recovery using storage snapshot in a clustered database |
CN105677673B (en) * | 2014-11-20 | 2019-01-04 | 阿里巴巴集团控股有限公司 | Method for processing business, apparatus and system |
CN104462342B (en) * | 2014-12-04 | 2018-08-07 | 北京国双科技有限公司 | database snapshot synchronization processing method and device |
EP3234771A4 (en) * | 2014-12-18 | 2018-07-25 | Intel Corporation | Translation cache closure and persistent snapshot in dynamic code generating system software |
US10884869B2 (en) * | 2015-04-16 | 2021-01-05 | Nuodb, Inc. | Backup and restore in a distributed database utilizing consistent database snapshots |
US10180954B2 (en) | 2015-05-29 | 2019-01-15 | Nuodb, Inc. | Disconnected operation within distributed database systems |
US10496672B2 (en) | 2015-12-30 | 2019-12-03 | EMC IP Holding Company LLC | Creating replicas at user-defined points in time |
CN107239365B (en) * | 2016-03-29 | 2020-11-27 | 华为技术有限公司 | Method and device for accessing storage equipment |
CN106708662A (en) * | 2016-12-13 | 2017-05-24 | 上海上讯信息技术股份有限公司 | Method for restoring database and equipment |
TWI735518B (en) * | 2017-01-24 | 2021-08-11 | 香港商阿里巴巴集團服務有限公司 | Service provision method and system of database |
CN107203345B (en) * | 2017-06-01 | 2019-10-01 | 深圳市云舒网络技术有限公司 | A kind of more copies storage rapid verification coherence method and its device |
CN111414370A (en) * | 2019-01-07 | 2020-07-14 | 北京智融网络科技有限公司 | Feature library updating method and system |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6065018A (en) * | 1998-03-04 | 2000-05-16 | International Business Machines Corporation | Synchronizing recovery log having time stamp to a remote site for disaster recovery of a primary database having related hierarchial and relational databases |
US6438749B1 (en) * | 1999-03-03 | 2002-08-20 | Microsoft Corporation | Method and system for restoring a computer to its original state after an unsuccessful patch installation attempt |
-
2004
- 2004-07-27 CN CN200480001706.4A patent/CN1784676B/en not_active Expired - Fee Related
- 2004-07-27 DE DE602004026422T patent/DE602004026422D1/en not_active Expired - Lifetime
- 2004-07-27 AT AT04779217T patent/ATE463797T1/en not_active IP Right Cessation
Also Published As
Publication number | Publication date |
---|---|
DE602004026422D1 (en) | 2010-05-20 |
CN1784676A (en) | 2006-06-07 |
CN1784676B (en) | 2012-05-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
ATE463797T1 (en) | DATABASE DATA RECOVERY SYSTEM AND METHOD | |
MXPA05009680A (en) | Method and system for synthetic backup and restore. | |
US10353781B2 (en) | File corruption recovery in concurrent data protection | |
US9152500B1 (en) | Hash collision recovery in a deduplication vault | |
CN105446828B (en) | A kind of DB Backup, restoration methods, apparatus and system | |
US9626518B2 (en) | Avoiding encryption in a deduplication storage | |
JP2007524173A5 (en) | ||
ATE470903T1 (en) | PROVIDING A SNAPSHOT OF A SUBSET OF A FILE SYSTEM | |
JP2006092553A5 (en) | ||
CN105843707B (en) | Database quick recovery method and equipment | |
US9430272B2 (en) | Efficiently providing virtual machine reference points | |
WO2007021443A3 (en) | Online page restore from a database mirror | |
MY141354A (en) | Device, method and computer program to avoid data corruption during writing operations | |
TW200707226A (en) | Method, system and article of manufacture for metadata replication and restoration | |
GB2530958A (en) | Replication for on-line hot-standby database | |
RU2008147124A (en) | EFFECTIVE CREATION OF FREQUENCY BACKUP COPIES INTEGRATED FOR APPLICATIONS | |
WO2006127404A3 (en) | Method and apparatus for storage backup | |
CN102609337A (en) | Rapid data recovery method for memory database | |
US8732418B1 (en) | Shadow registry | |
WO2007111751A3 (en) | Architecture for a smart enterprise framework and methods thereof | |
US20190138386A1 (en) | Recovering log-structured filesystems from physical replicas | |
CN104850628A (en) | Data synchronization method and apparatus in database | |
US8639660B1 (en) | Method and apparatus for creating a database replica | |
SA522431555B1 (en) | Securing Database Backups With Unique Global Identifier | |
CN105653718A (en) | Method for ensuring database data consistency after snapshot in storage disk snapshot environment |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
RER | Ceased as to paragraph 5 lit. 3 law introducing patent treaties |