DE60233877D1 - Parallelisierte nur-redo-protokollierung und behebung für datenbanksysteme mit hochverfügbarem hauptspeicher - Google Patents

Parallelisierte nur-redo-protokollierung und behebung für datenbanksysteme mit hochverfügbarem hauptspeicher

Info

Publication number
DE60233877D1
DE60233877D1 DE60233877T DE60233877T DE60233877D1 DE 60233877 D1 DE60233877 D1 DE 60233877D1 DE 60233877 T DE60233877 T DE 60233877T DE 60233877 T DE60233877 T DE 60233877T DE 60233877 D1 DE60233877 D1 DE 60233877D1
Authority
DE
Germany
Prior art keywords
logging
log records
redo
highly available
paralleled
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.)
Expired - Lifetime
Application number
DE60233877T
Other languages
English (en)
Inventor
Sang Kyun Cha
Ju Chang Lee
Ki Hong Kim
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.)
SAP SE
Original Assignee
SAP SE
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 SAP SE filed Critical SAP SE
Application granted granted Critical
Publication of DE60233877D1 publication Critical patent/DE60233877D1/de
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16Error detection or correction of the data by redundancy in hardware
    • G06F11/1666Error detection or correction of the data by redundancy in hardware where the redundant component is memory or memory area
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1471Saving, restoring, recovering or retrying involving logging of persistent data for recovery
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16Error detection or correction of the data by redundancy in hardware
    • G06F11/20Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/202Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant
    • G06F11/2041Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant with more than one idle spare processing component
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16Error detection or correction of the data by redundancy in hardware
    • G06F11/20Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/2097Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements maintaining the standby controller/processing unit updated
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16Error detection or correction of the data by redundancy in hardware
    • G06F11/20Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80Database-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)
  • Debugging And Monitoring (AREA)
DE60233877T 2001-07-16 2002-07-16 Parallelisierte nur-redo-protokollierung und behebung für datenbanksysteme mit hochverfügbarem hauptspeicher Expired - Lifetime DE60233877D1 (de)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US30593701P 2001-07-16 2001-07-16
US30595601P 2001-07-16 2001-07-16
PCT/KR2002/001341 WO2003009139A1 (en) 2001-07-16 2002-07-16 Parallelized redo-only logging and recovery for highly available main memory database systems

Publications (1)

Publication Number Publication Date
DE60233877D1 true DE60233877D1 (de) 2009-11-12

Family

ID=26974881

Family Applications (1)

Application Number Title Priority Date Filing Date
DE60233877T Expired - Lifetime DE60233877D1 (de) 2001-07-16 2002-07-16 Parallelisierte nur-redo-protokollierung und behebung für datenbanksysteme mit hochverfügbarem hauptspeicher

Country Status (4)

Country Link
EP (1) EP1407359B1 (de)
AT (1) ATE444525T1 (de)
DE (1) DE60233877D1 (de)
WO (1) WO2003009139A1 (de)

Families Citing this family (20)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7188273B2 (en) 2003-11-24 2007-03-06 Tsx Inc. System and method for failover
EP1691290B1 (de) * 2005-02-09 2007-10-10 Deutsche Post AG Verfahren zur Sicherung einer Datenbank und Vorrichtung zur Durchführung des Verfahrens
US7725764B2 (en) 2006-08-04 2010-05-25 Tsx Inc. Failover system and method
US7890457B2 (en) 2006-10-20 2011-02-15 Oracle International Corporation Transactionally consistent database workload replay
US7984015B2 (en) 2006-10-20 2011-07-19 Oracle International Corporation Database workload capture and replay architecture
WO2008051855A1 (en) * 2006-10-20 2008-05-02 Oracle International Corporation Database workload capture and replay architecture
US7634512B2 (en) 2006-10-20 2009-12-15 Oracle International Corporation Migrating temporary data of a session
US7890458B2 (en) 2006-10-20 2011-02-15 Oracle International Corporation Capturing database workload while preserving original transactional and concurrency characteristics for replay
US8024299B2 (en) 2006-10-20 2011-09-20 Oracle International Corporation Client-driven functionally equivalent database replay
US8997048B1 (en) 2007-02-14 2015-03-31 Oracle America, Inc. Method and apparatus for profiling a virtual machine
US8433680B2 (en) 2008-07-01 2013-04-30 Oracle International Corporation Capturing and restoring database session state
US8418150B2 (en) 2009-04-03 2013-04-09 Oracle International Corporation Estimating impact of configuration changes
CN101625655B (zh) * 2009-08-20 2011-05-25 华中科技大学 一种内存数据库的并行恢复方法
US9563655B2 (en) 2013-03-08 2017-02-07 Oracle International Corporation Zero and near-zero data loss database backup and recovery
US9672237B2 (en) 2013-03-15 2017-06-06 Amazon Technologies, Inc. System-wide checkpoint avoidance for distributed database systems
CN103150149B (zh) * 2013-03-26 2015-11-25 华为技术有限公司 处理数据库重做数据的方法和装置
US11556500B2 (en) 2017-09-29 2023-01-17 Oracle International Corporation Session templates
US11176004B2 (en) * 2019-04-01 2021-11-16 Sap Se Test continuous log replay
CN112506710B (zh) * 2020-12-16 2024-02-23 深信服科技股份有限公司 分布式文件系统数据修复方法、装置、设备及存储介质
US11797522B2 (en) * 2021-01-29 2023-10-24 International Business Machines Corporation Database log writing based on log pipeline contention

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1996023269A1 (en) * 1995-01-23 1996-08-01 Tandem Computers Incorporated System for maintenance of database integrity
JPH10161916A (ja) * 1996-11-28 1998-06-19 Hitachi Ltd データベースの複製に伴う更新競合の検出方法
JPH10333961A (ja) * 1997-05-30 1998-12-18 Kokusai Zunou Sangyo Kk データベースのリカバリーシステムおよびリカバリープログラムを記録したコンピュータ読み取り可能な記録媒体
US5890154A (en) * 1997-06-06 1999-03-30 International Business Machines Corp. Merging database log files through log transformations

Also Published As

Publication number Publication date
ATE444525T1 (de) 2009-10-15
EP1407359A1 (de) 2004-04-14
WO2003009139A1 (en) 2003-01-30
EP1407359B1 (de) 2009-09-30

Similar Documents

Publication Publication Date Title
DE60233877D1 (de) Parallelisierte nur-redo-protokollierung und behebung für datenbanksysteme mit hochverfügbarem hauptspeicher
US6581143B2 (en) Data processing method and apparatus for enabling independent access to replicated data
MY120157A (en) Data management apparatus, data management method, and recording medium
DE69823367D1 (de) Anordnungen zur erfassung des gebrauchs von kardialen vorrichtungen
EP1406174B8 (de) Verfahren und Vorrichtungen zur proaktiven Speicherverwaltung
WO2002014997A3 (en) Apparatus and method for writing and reading data to and from a virtual volume of redundant storage devices
CN100498796C (zh) 逻辑日志生成方法、数据库备份/恢复方法与系统
US8762347B1 (en) Method and apparatus for processing transactional file system operations to enable point in time consistent file data recreation
DE60213836D1 (de) Überwachungssystem, fahrzeugüberwachungsvorrichtung, überwachungsverfahren, überwachungsprogramm, dieses enthaltendes rechnerlesbares aufzeichnungsmedium
NO952546D0 (no) Apparat og fremgangsmåte for lagring av data
DE602006020709D1 (de) Ferndaten-spiegelungssystem
AU2002221679A1 (en) Device and method for data mirroring
TW200506636A (en) Autonomic power loss recovery for a multi-cluster storage sub-system
TWI256619B (en) Information storage medium, information recording method, and information reproducing method
HK1028284A1 (en) Method for creating an information database in a computer system.
SE9203528L (sv) För en bitfelsövervakning i en väljarutrustning avsedd anordning
MY147621A (en) Recording management information and reliability information in a recording medium for management of the recording medium
GB2351818B (en) Computer,computer network system,and recording medium
DE60116392D1 (de) Verfahren und vorrichtung für verschachtelte datensicherung
TW359833B (en) Digital audio recorder and player with address backup function
KR940020322A (ko) 기록 매체 기록, 장치 및 재생장치
ATE448547T1 (de) Aktivierung von speicherredundanz während des testens
MY144411A (en) Method of recording information on and/or reproducing information from information storage medium including user data area having first sync patterns and additional data area having second and third sync patterns different from each other and from the first sync patterns
NO960817L (no) Filkrypteringsskjema
ES2168860T3 (es) Procedimiento de sincronizacion y/o de intercambio de datos para ordenadores seguros, de alta disponibilidad, y dispositivo adecuado para ello.

Legal Events

Date Code Title Description
8364 No opposition during term of opposition