article

Fast-Start: quick fault recovery in oracle

Authors:

Tirthankar Lahiri,

Amit Ganesh,

Ron Weiss,

Ashok JoshiAuthors Info & Claims

ACM SIGMOD Record, Volume 30, Issue 2

Pages 593 - 598

https://doi.org/10.1145/376284.375751

Published: 01 May 2001 Publication History

Get Access

Abstract

Availability requirements for database systems are more stringent than ever before with the widespread use of databases as the foundation for ebusiness. This paper highlights Fast-Start™ Fault Recovery, an important availability feature in Oracle, designed to expedite recovery from unplanned outages. Fast-Start allows the administrator to configure a running system to impose predictable bounds on the time required for crash recovery. For instance, fast-start allows fine-grained control over the duration of the roll-forward phase of crash recovery by adaptively varying the rate of checkpointing with minimal impact on online performance. Persistent transaction locking in Oracle allows normal online processing to be resumed while the rollback phase of recovery is still in progress, and fast-start allows quick and transparent rollback of changes made by uncommitted transactions prior to a crash.

References

[1]

R.Bamford, B. Klots, D. Butler, and N. Macnaughton. Architecture of Oracle Parallel Server. In Proceedings of the Twenty-Fourth International Conference on Very Large Databases, New York, September 1998.

Digital Library

Google Scholar

[2]

W. Bridge, A. Joshi, M. Keihl, T. Lahiri, J. Loaiza, and N. Macnaughton. The Oracle Universal Server Buffer Manager. In Proceedings of the Twenty-Third International Conference on Very Large Databases, Athens, Greece, September 1997.

Digital Library

Google Scholar

[3]

T. Haerder and A. Reuter. Principles of Transaction-Oriented Database Recovery. ACM Computing Surveys, 15(4) 287-317.

Digital Library

Google Scholar

[4]

A. Joshi, W. Bridge, J. Loaiza, and T.Lahiri. Checkpointing in Oracle. In Proceedings of the Twenty-Fourth International Conference on Very Large Databases, New York, September 1998.

Digital Library

Google Scholar

[5]

B. Klots, and S. Chatterjee. Cache Coherency In Oracle Parallel Server, In Proceedings of the Twenty-Second International Conference on Very Large Databases, Bombay, India, September 1996.

Digital Library

Google Scholar

[6]

T. Lahiri, A. Joshi, A. Jasuja, S. Chatterjee. 50,000 Users on an Oracle8 Universal Server Database. In Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, Seattle, Washington, May 1998.

Digital Library

Google Scholar

[7]

C. Mohan and I. Narang. Data Base Recovery in Shared Disks and Client-Server Architectures. In Proceedings of the Twelvth International Conference on Distributed Computing Systems, Yokohama, June 1992.

Crossref

Google Scholar

[8]

C. Mohan. A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure. In Proceedings of the Nineteenth International Conference on Very Large Databases, Dublin, Ireland, August 1993.

Digital Library

Google Scholar

[9]

Oracle Corporation. Oracle8i Concepts Release 2 (8.1.6). Part Number A76965-01.

Google Scholar

[10]

Oracle Corporation. Oracle8i Backup and Recovery Guide Release 2 (8.1.6), Part Number A76993-01.

Google Scholar

Cited By

View all

Tan YTan HZhu PLu YHe Z(2022)Embedded Transaction Support Inside SSD With Small-Capacity Non-Volatile Disk CacheIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2020.300451834:5(2148-2163)Online publication date: 1-May-2022
https://doi.org/10.1109/TKDE.2020.3004518
Wamhoff JRiegel TFetzer CFelber P(2010)RobuSTMProceedings of the 12th international conference on Stabilization, safety, and security of distributed systems10.5555/1926829.1926863(388-404)Online publication date: 20-Sep-2010
https://dl.acm.org/doi/10.5555/1926829.1926863
Wood TCecchet ERamakrishnan KShenoy Pvan der Merwe JVenkataramani A(2010)Disaster recovery as a cloud serviceProceedings of the 2nd USENIX conference on Hot topics in cloud computing10.5555/1863103.1863111(8-8)Online publication date: 22-Jun-2010
https://dl.acm.org/doi/10.5555/1863103.1863111
Show More Cited By

Index Terms

Fast-Start: quick fault recovery in oracle
1. Information systems
  1. Data management systems
    1. Database management system engines
      1. Database transaction processing
        Database recovery
      2. Distributed database transactions
        Distributed database recovery

Recommendations

Fast-Start: quick fault recovery in oracle
SIGMOD '01: Proceedings of the 2001 ACM SIGMOD international conference on Management of data

Availability requirements for database systems are more stringent than ever before with the widespread use of databases as the foundation for ebusiness. This paper highlights Fast-Start™ Fault Recovery, an important availability feature in Oracle, ...
The Software Rejuvenation Model with Pre-start Technology
ISIP '08: Proceedings of the 2008 International Symposiums on Information Processing

Software aging related failures can be prevented by applying software rejuvenation technology. But the restart operation in the software rejuvenation phase makes the system unable to provide services, which leads to system unavailability. The software ...
Double Mutual-Aid Checkpointing for Fast Recovery
HPCC '12: Proceedings of the 2012 IEEE 14th International Conference on High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems

Because of the enlarging system size and the increasing number of processors, the probability of errors and multiple simultaneously failures become the norm rather than the exception. Therefore, to tolerate multiple failures is indispensable. Normally, ...

Comments

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 30, Issue 2

June 2001

625 pages

ISSN:0163-5808

DOI:10.1145/376284

Editors:
Timos Sellis
National Technical Univ. of Athens
,
Sharad Mehrotra
Univ. of California at Irvine

Issue’s Table of Contents

SIGMOD '01: Proceedings of the 2001 ACM SIGMOD international conference on Management of data
May 2001
630 pages
ISBN:1581133324
DOI:10.1145/375663
Editors:
Timos Sellis,
Sharad Mehrotra

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 May 2001

Published in SIGMOD Volume 30, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

14
Total Citations
View Citations
1,218
Total Downloads

Downloads (Last 12 months)7
Downloads (Last 6 weeks)2

Reflects downloads up to 04 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Tan YTan HZhu PLu YHe Z(2022)Embedded Transaction Support Inside SSD With Small-Capacity Non-Volatile Disk CacheIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2020.300451834:5(2148-2163)Online publication date: 1-May-2022
https://doi.org/10.1109/TKDE.2020.3004518
Wamhoff JRiegel TFetzer CFelber P(2010)RobuSTMProceedings of the 12th international conference on Stabilization, safety, and security of distributed systems10.5555/1926829.1926863(388-404)Online publication date: 20-Sep-2010
https://dl.acm.org/doi/10.5555/1926829.1926863
Wood TCecchet ERamakrishnan KShenoy Pvan der Merwe JVenkataramani A(2010)Disaster recovery as a cloud serviceProceedings of the 2nd USENIX conference on Hot topics in cloud computing10.5555/1863103.1863111(8-8)Online publication date: 22-Jun-2010
https://dl.acm.org/doi/10.5555/1863103.1863111
Wamhoff JRiegel TFetzer CFelber P(2010)RobuSTM: A Robust Software Transactional MemoryStabilization, Safety, and Security of Distributed Systems10.1007/978-3-642-16023-3_32(388-404)Online publication date: 20-Sep-2010
https://doi.org/10.1007/978-3-642-16023-3_32
Janakiraman GSantos JTurner Y(2004)Automated system design for availabilityInternational Conference on Dependable Systems and Networks, 200410.1109/DSN.2004.1311911(411-420)Online publication date: 2004
https://doi.org/10.1109/DSN.2004.1311911
Tan YTan HZhu PLu YHe Z(2022)Embedded Transaction Support Inside SSD With Small-Capacity Non-Volatile Disk CacheIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2020.300451834:5(2148-2163)Online publication date: 1-May-2022
https://doi.org/10.1109/TKDE.2020.3004518
Nadgowda SSuneja SKanso A(2017)Comparing Scaling Methods for Linux Containers2017 IEEE International Conference on Cloud Engineering (IC2E)10.1109/IC2E.2017.42(266-272)Online publication date: Apr-2017
https://doi.org/10.1109/IC2E.2017.42
Lee SMoon B(2011)Transactional In-Page Logging for multiversion read consistency and recoveryProceedings of the 2011 IEEE 27th International Conference on Data Engineering10.1109/ICDE.2011.5767889(876-887)Online publication date: 11-Apr-2011
https://dl.acm.org/doi/10.1109/ICDE.2011.5767889
Wamhoff JRiegel TFetzer CFelber P(2010)RobuSTM: A Robust Software Transactional MemoryStabilization, Safety, and Security of Distributed Systems10.1007/978-3-642-16023-3_32(388-404)Online publication date: 20-Sep-2010
https://doi.org/10.1007/978-3-642-16023-3_32
Jiang NVillafane RHua KSawant APrabhakara K(2005)ADMiReIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2005.10317:7(888-901)Online publication date: 1-Jul-2005
https://dl.acm.org/doi/10.1109/TKDE.2005.103
Show More Cited By

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Fast-Start: quick fault recovery in oracle

The Software Rejuvenation Model with Pre-start Technology

Double Mutual-Aid Checkpointing for Fast Recovery