Recovery in Oracle

  • Vijay Kumar
  • Sang H. Son
Part of the The Kluwer International Series on Advances in Database Systems book series (ADBS, volume 12)


Oracle is a relational database management system. Its architecture is based on client/server paradigm. Basically Oracle has two parts: Oracle database and Oracle instance. The Oracle database is a logical collection of data (tables) that are manipulated and a set of system files that are used to support the desired functions. The Oracle instance, on the other hand, is a set of software modules that are responsible for providing access to the database and manage database state transition through a number of processes, such as the Process Monitor (PMON), the System Monitor (SMON), the Database Writer (DBWR), and the Log Writer (LGWR). PMON performs the following functions (a) it recovers a user process when it fails, (b) restarts dispatcher and server processes when they die, and (c) recovers a failed transaction (rolls it back). SMON performs the following functions: (a) performs instance recovery, and (b) releases temporary segments and merges contiguous free extents to make larger size free blocks. LGWR performs the following functions: (a) saves redo log buffers to log files, (b) manages the checkpoint process (the actual checkpointing is done by DBWR process), and (c) writes redo log data at (i) the commit point, or (ii) at every three seconds, or (iii) when the redo log buffer is one-third full. In this section the role of these processes are describes in more detail [14].


Data File Version Number Change Vector Media Recovery File Header 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer Science+Business Media New York 1998

Authors and Affiliations

  • Vijay Kumar
    • 1
  • Sang H. Son
    • 2
  1. 1.University of MissouriKansas CityUSA
  2. 2.University of VirginiaCharlottesvilleUSA

Personalised recommendations