CN103262043B - 从差异备份中执行数据库的精细恢复的方法和系统 - Google Patents

从差异备份中执行数据库的精细恢复的方法和系统 Download PDF

Info

Publication number
CN103262043B
CN103262043B CN201180053083.5A CN201180053083A CN103262043B CN 103262043 B CN103262043 B CN 103262043B CN 201180053083 A CN201180053083 A CN 201180053083A CN 103262043 B CN103262043 B CN 103262043B
Authority
CN
China
Prior art keywords
backup
database
objects
partial
full
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201180053083.5A
Other languages
English (en)
Chinese (zh)
Other versions
CN103262043A (zh
Inventor
L·比蒂
D·萨拉夫
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Gen Digital Inc
Original Assignee
Symantec Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Symantec Corp filed Critical Symantec Corp
Publication of CN103262043A publication Critical patent/CN103262043A/zh
Application granted granted Critical
Publication of CN103262043B publication Critical patent/CN103262043B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14—Error detection or correction of the data by redundancy in operation
    • G06F11/1402—Saving, restoring, recovering or retrying
    • G06F11/1446—Point-in-time backing up or restoration of persistent data
    • G06F11/1458—Management of the backup or restore process
    • G06F11/1469—Backup restoration techniques
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14—Error detection or correction of the data by redundancy in operation
    • G06F11/1402—Saving, restoring, recovering or retrying
    • G06F11/1446—Point-in-time backing up or restoration of persistent data
    • G06F11/1448—Management of the data involved in backup or backup restore
    • G06F11/1451—Management of the data involved in backup or backup restore by selection of backup contents
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80—Database-specific techniques

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN201180053083.5A 2010-09-29 2011-09-29 从差异备份中执行数据库的精细恢复的方法和系统 Active CN103262043B (zh)

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US12/893,729 US8666944B2 (en) 2010-09-29 2010-09-29 Method and system of performing a granular restore of a database from a differential backup
US12/893,729 2010-09-29
US12/893729 2010-09-29
PCT/US2011/053809 WO2012050940A1 (en) 2010-09-29 2011-09-29 Method and system of performing a granular restore of a database from a differential backup

Publications (2)

Publication Number Publication Date
CN103262043A CN103262043A (zh) 2013-08-21
CN103262043B true CN103262043B (zh) 2016-05-18

Family

ID=44774180

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201180053083.5A Active CN103262043B (zh) 2010-09-29 2011-09-29 从差异备份中执行数据库的精细恢复的方法和系统

Country Status (5)

Country Link
US (1) US8666944B2 (enExample)
EP (1) EP2622481B1 (enExample)
JP (1) JP5731000B2 (enExample)
CN (1) CN103262043B (enExample)
WO (1) WO2012050940A1 (enExample)

Families Citing this family (69)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8417674B2 (en) 2010-11-16 2013-04-09 Actifio, Inc. System and method for creating deduplicated copies of data by sending difference data between near-neighbor temporal states
US8843489B2 (en) 2010-11-16 2014-09-23 Actifio, Inc. System and method for managing deduplicated copies of data using temporal relationships among copies
US8402004B2 (en) 2010-11-16 2013-03-19 Actifio, Inc. System and method for creating deduplicated copies of data by tracking temporal relationships among copies and by ingesting difference data
US8396905B2 (en) 2010-11-16 2013-03-12 Actifio, Inc. System and method for improved garbage collection operations in a deduplicated store by tracking temporal relationships among copies
US8788769B2 (en) * 2010-11-16 2014-07-22 Actifio, Inc. System and method for performing backup or restore operations utilizing difference information and timeline state information
US8904126B2 (en) * 2010-11-16 2014-12-02 Actifio, Inc. System and method for performing a plurality of prescribed data management functions in a manner that reduces redundant access operations to primary storage
US9858155B2 (en) 2010-11-16 2018-01-02 Actifio, Inc. System and method for managing data with service level agreements that may specify non-uniform copying of data
US9824091B2 (en) 2010-12-03 2017-11-21 Microsoft Technology Licensing, Llc File system backup using change journal
US8620894B2 (en) 2010-12-21 2013-12-31 Microsoft Corporation Searching files
US9229818B2 (en) * 2011-07-20 2016-01-05 Microsoft Technology Licensing, Llc Adaptive retention for backup data
US9026496B1 (en) * 2011-09-30 2015-05-05 Emc Corporation Efficient building of restore list
JP5812942B2 (ja) * 2012-06-15 2015-11-17 株式会社日立システムズ ディザスタリカバリ管理システムおよびディザスタリカバリ管理方法
US9430331B1 (en) * 2012-07-16 2016-08-30 Emc Corporation Rapid incremental backup of changed files in a file system
US8775377B1 (en) * 2012-07-25 2014-07-08 Symantec Corporation Efficient data backup with change tracking
US9817834B1 (en) * 2012-10-01 2017-11-14 Veritas Technologies Llc Techniques for performing an incremental backup
US9613119B1 (en) 2013-03-14 2017-04-04 Nutanix, Inc. Unique identifiers for data replication, migration, failover operations and failback operations
US10191823B2 (en) 2014-03-11 2019-01-29 Cloudendure Ltd. System and method for restoring original machines from replicated machines in a secondary computing environment
US10180951B2 (en) * 2013-03-15 2019-01-15 Amazon Technologies, Inc. Place snapshots
US9582386B2 (en) 2013-03-15 2017-02-28 Cloudendure, Ltd. System and method for maintaining a copy of a cloud-based computing environment and restoration thereof
US9110601B2 (en) 2013-06-24 2015-08-18 Sap Se Backup lifecycle management
JP2015114784A (ja) * 2013-12-11 2015-06-22 日本電気株式会社 バックアップ制御装置及びバックアップ制御方法、ディスクアレイ装置、並びにコンピュータ・プログラム
US8943441B1 (en) * 2014-01-24 2015-01-27 Storagecraft Technology Corporation Graphical user interface relationship graph for displaying relationships between image backup files in a backup job
CN103761170B (zh) * 2014-01-27 2017-04-12 北京奇虎科技有限公司 系统文件恢复方法及装置、系统
US11169958B2 (en) * 2014-02-07 2021-11-09 International Business Machines Corporation Using a repository having a full copy of source data and point-in-time information from point-in-time copies of the source data to restore the source data at different points-in-time
US11194667B2 (en) * 2014-02-07 2021-12-07 International Business Machines Corporation Creating a restore copy from a copy of a full copy of source data in a repository that is at a different point-in-time than a restore point-in-time of a restore request
US10176048B2 (en) 2014-02-07 2019-01-08 International Business Machines Corporation Creating a restore copy from a copy of source data in a repository having source data at different point-in-times and reading data from the repository for the restore copy
US10372546B2 (en) * 2014-02-07 2019-08-06 International Business Machines Corporation Creating a restore copy from a copy of source data in a repository having source data at different point-in-times
US20150242282A1 (en) * 2014-02-24 2015-08-27 Red Hat, Inc. Mechanism to update software packages
US9697228B2 (en) 2014-04-14 2017-07-04 Vembu Technologies Private Limited Secure relational file system with version control, deduplication, and error correction
US10387446B2 (en) 2014-04-28 2019-08-20 International Business Machines Corporation Merging multiple point-in-time copies into a merged point-in-time copy
US9552365B2 (en) * 2014-05-31 2017-01-24 Institute For Information Industry Secure synchronization apparatus, method, and non-transitory computer readable storage medium thereof
US10503604B2 (en) 2014-06-26 2019-12-10 Hewlett Packard Enterprise Development Lp Virtual machine data protection
JP5991699B2 (ja) 2014-08-08 2016-09-14 インターナショナル・ビジネス・マシーンズ・コーポレーションＩｎｔｅｒｎａｔｉｏｎａｌ Ｂｕｓｉｎｅｓｓ Ｍａｃｈｉｎｅｓ Ｃｏｒｐｏｒａｔｉｏｎ 情報処理装置、情報処理システム、バックアップ方法、およびプログラム
US9754001B2 (en) 2014-08-18 2017-09-05 Richard Banister Method of integrating remote databases by automated client scoping of update requests prior to download via a communications network
US9152504B1 (en) * 2014-09-30 2015-10-06 Storagecraft Technology Corporation Staged restore of a decremental backup chain
US10289495B1 (en) * 2014-12-19 2019-05-14 EMC IP Holding Company LLC Method and system for performing an item level restore from a backup
US10838983B2 (en) 2015-01-25 2020-11-17 Richard Banister Method of integrating remote databases by parallel update requests over a communications network
US10747622B2 (en) * 2015-03-31 2020-08-18 SkyKick, Inc. Efficient backup, search and restore
US10078555B1 (en) * 2015-04-14 2018-09-18 EMC IP Holding Company LLC Synthetic full backups for incremental file backups
US9946603B1 (en) 2015-04-14 2018-04-17 EMC IP Holding Company LLC Mountable container for incremental file backups
US9996429B1 (en) 2015-04-14 2018-06-12 EMC IP Holding Company LLC Mountable container backups for files
US10140189B2 (en) 2015-04-28 2018-11-27 International Business Machines Corporation Database recovery and index rebuilds
US10540237B2 (en) 2015-09-16 2020-01-21 Sesame Software, Inc. System and method for procedure for point-in-time recovery of cloud or database data and records in whole or in part
US10657123B2 (en) 2015-09-16 2020-05-19 Sesame Software Method and system for reducing time-out incidence by scoping date time stamp value ranges of succeeding record update requests in view of previous responses
US10838827B2 (en) 2015-09-16 2020-11-17 Richard Banister System and method for time parameter based database restoration
US10990586B2 (en) 2015-09-16 2021-04-27 Richard Banister System and method for revising record keys to coordinate record key changes within at least two databases
US11157367B1 (en) * 2015-09-30 2021-10-26 EMC IP Holding Company LLC Promotional logic during database differential backup
US10691556B2 (en) * 2016-01-27 2020-06-23 Quest Software Inc. Recovering a specified set of documents from a database backup
WO2017131789A1 (en) * 2016-01-29 2017-08-03 Hewlett Packard Enterprise Development Lp Memory management with versioning of objects
WO2017158794A1 (ja) * 2016-03-17 2017-09-21 楽天株式会社 ファイル管理システム、ファイル管理方法、収集プログラム、ならびに、非一時的なコンピュータ読取可能な情報記録媒体
US10146638B1 (en) * 2016-06-24 2018-12-04 EMC IP Holding Company LLC Check point recovery based on identifying changed blocks for block-based backup files
US10795588B1 (en) * 2016-06-24 2020-10-06 EMC IP Holding Company LLC Check point recovery based on identifying used blocks for block-based backup files
US10635648B2 (en) 2016-11-30 2020-04-28 Nutanix, Inc. Entity identifier generation in distributed computing systems
US10789249B2 (en) * 2017-05-23 2020-09-29 Sap Se Optimal offset pushdown for multipart sorting
JP6583975B1 (ja) * 2018-06-06 2019-10-02 株式会社インテック データ処理装置、データ処理方法及びプログラム
CN109460318B (zh) * 2018-10-26 2021-01-01 珠海市时杰信息科技有限公司 一种可回滚档案采集数据的导入方法、计算机装置及计算机可读存储介质
US11269733B2 (en) * 2018-11-13 2022-03-08 Exagrid Systems, Inc. Synthetic full backups and deduplication backup storage with landing zone
US10936430B2 (en) * 2019-01-24 2021-03-02 EMC IP Holding Company LLC Method and system for automation of differential backups
KR102427418B1 (ko) * 2019-09-27 2022-08-01 주식회사 데이타커맨드 백업 데이터 합성 장치 및 방법
CN111143323B (zh) * 2019-12-02 2022-04-08 新华三大数据技术有限公司 Mpp数据库管理方法、装置及系统
US11372732B2 (en) * 2020-02-25 2022-06-28 Veritas Technologies Llc Systems and methods for agentless and accelerated backup of a database
US11194769B2 (en) 2020-04-27 2021-12-07 Richard Banister System and method for re-synchronizing a portion of or an entire source database and a target database
CN112306748B (zh) * 2020-10-21 2024-02-13 深圳万兴软件有限公司 数据恢复方法、设备及存储介质
US12487843B2 (en) * 2020-12-22 2025-12-02 VMware LLC Data protection for control planes in a virtualized computer system
US11734124B2 (en) * 2021-01-15 2023-08-22 EMC IP Holding Company LLC Rule-based re-tiering of incremental backup data stored on a cloud-based object storage
US11669403B2 (en) * 2021-01-15 2023-06-06 EMC IP Holding Company LLC Intelligent re-tiering of incremental backup data stored on a cloud-based object storage
CN113282573B (zh) * 2021-07-22 2021-09-17 成都云祺科技有限公司 基于iam页的数据库恢复的方法、系统及存储介质
US12332750B2 (en) * 2022-10-14 2025-06-17 Dell Products L.P. Cyber recovery forensics kit—efficient event searching over pits
US20250245199A1 (en) * 2024-01-25 2025-07-31 Rubrik, Inc. Storage and retrieval of filesystem metadata

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1752939A (zh) * 2004-09-22 2006-03-29 微软公司 用于综合备份和恢复的方法和系统
US7634511B1 (en) * 2006-09-29 2009-12-15 Symantec Operating Corporation User interface for viewing logical representation of a database backed up by a database recovery manager
CN101739313A (zh) * 2009-11-27 2010-06-16 华中科技大学 一种连续数据保护和恢复方法

Family Cites Families (40)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5150473A (en) 1990-01-16 1992-09-22 Dantz Development Corporation Data storage format for addressable or sequential memory media
US5966730A (en) 1996-10-30 1999-10-12 Dantz Development Corporation Backup system for computer network incorporating opportunistic backup by prioritizing least recently backed up computer or computer storage medium
EP0945800B1 (en) 1998-03-02 2003-07-16 Hewlett-Packard Company, A Delaware Corporation Data backup system
US6366986B1 (en) * 1998-06-30 2002-04-02 Emc Corporation Method and apparatus for differential backup in a computer storage system
US6269381B1 (en) 1998-06-30 2001-07-31 Emc Corporation Method and apparatus for backing up data before updating the data and for restoring from the backups
US6571285B1 (en) 1999-12-23 2003-05-27 Accenture Llp Providing an integrated service assurance environment for a network
US6470329B1 (en) 2000-07-11 2002-10-22 Sun Microsystems, Inc. One-way hash functions for distributed data synchronization
US6523036B1 (en) 2000-08-01 2003-02-18 Dantz Development Corporation Internet database system
US6871271B2 (en) * 2000-12-21 2005-03-22 Emc Corporation Incrementally restoring a mass storage device to a prior state
WO2002071219A2 (en) 2001-03-07 2002-09-12 Matchtip Limited System for replicating data of a mobile station
JP2005521114A (ja) 2001-07-06 2005-07-14 コンピュータ アソシエイツ シンク，インコーポレイテッド 情報バックアップシステム及び方法
US7043507B2 (en) 2002-02-28 2006-05-09 Veritas Operating Corporation System and method for validated indirect data backup using operating system I/O Operations
US20030172094A1 (en) 2002-03-06 2003-09-11 International Business Machines Corporation Automatic file system maintenance
US6938135B1 (en) 2002-10-04 2005-08-30 Veritas Operating Corporation Incremental backup of a data volume
US20040193953A1 (en) 2003-02-21 2004-09-30 Sun Microsystems, Inc. Method, system, and program for maintaining application program configuration settings
US20040215619A1 (en) 2003-04-24 2004-10-28 Bsquare Corporation System and method for integrating persistent and non-persistent storage in an integrated storage area
US7328366B2 (en) 2003-06-06 2008-02-05 Cascade Basic Research Corp. Method and system for reciprocal data backup
US7302536B2 (en) 2003-06-17 2007-11-27 Hitachi, Ltd. Method and apparatus for managing replication volumes
US20040268068A1 (en) 2003-06-24 2004-12-30 International Business Machines Corporation Efficient method for copying and creating block-level incremental backups of large files and sparse files
KR100890573B1 (ko) * 2003-08-05 2009-03-25 세파톤 인코포레이티드 에뮬레이팅된 저장 시스템
JP4267420B2 (ja) 2003-10-20 2009-05-27 株式会社日立製作所 ストレージ装置及びバックアップ取得方法
JP2005301497A (ja) 2004-04-08 2005-10-27 Hitachi Ltd ストレージ管理装置、リストア方法及びそのプログラム
JP2006011635A (ja) * 2004-06-23 2006-01-12 Yokogawa Electric Corp バックアップ方法およびバックアップ装置
US7694088B1 (en) 2005-03-31 2010-04-06 Symantec Operating Corporation System and method for efficient creation of aggregate backup images
US7669020B1 (en) 2005-05-02 2010-02-23 Symantec Operating Corporation Host-based backup for virtual machines
US7937547B2 (en) 2005-06-24 2011-05-03 Syncsort Incorporated System and method for high performance enterprise data protection
US20070168401A1 (en) 2006-01-05 2007-07-19 Aditya Kapoor User interface for piecemeal restore
US7370164B1 (en) 2006-03-21 2008-05-06 Symantec Operating Corporation Backup of virtual machines from the base machine
US8117163B2 (en) * 2006-10-31 2012-02-14 Carbonite, Inc. Backup and restore system for a computer
JP2008310889A (ja) * 2007-06-15 2008-12-25 Panasonic Corp 記録再生装置
US7853569B2 (en) * 2007-06-29 2010-12-14 Air Liquide Large Industries U.S. Lp Synchronizing historical archive data between primary and secondary historian systems
US7694105B2 (en) 2007-08-22 2010-04-06 Hitachi Global Storage Technologies Netherlands, B.V. Data storage systems that implement sector sets
US7797279B1 (en) * 2007-12-31 2010-09-14 Emc Corporation Merging of incremental data streams with prior backed-up data
US8577845B2 (en) 2008-06-13 2013-11-05 Symantec Operating Corporation Remote, granular restore from full virtual machine backup
US8046550B2 (en) 2008-07-14 2011-10-25 Quest Software, Inc. Systems and methods for performing backup operations of virtual machine files
US8150801B2 (en) 2008-08-20 2012-04-03 Microsoft Corporation Recovery of a computer that includes virtual disks
US20100083251A1 (en) 2008-09-12 2010-04-01 Hyper9, Inc. Techniques For Identifying And Comparing Virtual Machines In A Virtual Machine System
US9501368B2 (en) 2008-09-30 2016-11-22 Veritas Technologies Llc Backing up and restoring selected versioned objects from a monolithic database backup
US8099391B1 (en) 2009-03-17 2012-01-17 Symantec Corporation Incremental and differential backups of virtual machine files
JP2009245448A (ja) * 2009-06-15 2009-10-22 Fujitsu Ltd データリストア装置

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1752939A (zh) * 2004-09-22 2006-03-29 微软公司 用于综合备份和恢复的方法和系统
US7634511B1 (en) * 2006-09-29 2009-12-15 Symantec Operating Corporation User interface for viewing logical representation of a database backed up by a database recovery manager
CN101739313A (zh) * 2009-11-27 2010-06-16 华中科技大学 一种连续数据保护和恢复方法

Also Published As

Publication number Publication date
JP2013542513A (ja) 2013-11-21
JP5731000B2 (ja) 2015-06-10
EP2622481A1 (en) 2013-08-07
US8666944B2 (en) 2014-03-04
EP2622481B1 (en) 2019-12-25
US20120078855A1 (en) 2012-03-29
CN103262043A (zh) 2013-08-21
WO2012050940A1 (en) 2012-04-19

Similar Documents

Publication Publication Date Title
CN103262043B (zh) 从差异备份中执行数据库的精细恢复的方法和系统
US8606752B1 (en) Method and system of restoring items to a database while maintaining referential integrity
US10740319B2 (en) Graph-based data models for partitioned data
US7761456B1 (en) Secure restoration of data selected based on user-specified search criteria
US9026512B2 (en) Data object search and retrieval
US8635187B2 (en) Method and system of performing incremental SQL server database backups
CN102567140B (zh) 使用变化日志的文件系统备份
KR102579190B1 (ko) 일관된 데이터베이스 스냅샷들을 이용한 분산 데이터베이스에서의 백업 및 복원
US8825972B1 (en) Method and system of producing a full backup image using an incremental backup method
US11327927B2 (en) System and method for creating group snapshots
US8095678B2 (en) Data processing
US8601147B2 (en) Export of metadata streams to applications
CN104508666A (zh) 对备份数据进行编目
US11513907B2 (en) Method and system for resuming interrupted database backup operations using checkpoints
US20080005524A1 (en) Data processing
US20220114139A1 (en) Fractional consistent global snapshots of a distributed namespace
JP2004252957A (ja) 分散ファイルシステムのファイルレプリケーション方法及び装置
US11269837B2 (en) Data tree checkpoint and restoration system and method
US10713305B1 (en) Method and system for document search in structured document repositories
US20210342333A1 (en) Partial updates in data collections in a data storage system
HK1172423B (en) Backup using metadata virtual hard drive and differential virtual hard drive

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant