Chapter 9. Maintaining Redo Log Files


Terms you'll need to understand:

  • Online redo log files

  • Redo log groups

  • Redo log members

  • ARCHIVELOG

  • NOARCHIVELOG

Concepts you'll need to master:

  • Explain the purpose of the online redo log files.

  • Outline the structure of the online redo log files.

  • Control log switches and checkpoints.

  • Multiplex and maintain online redo log files.

  • Manage online redo log files with Oracle Managed files (OMF).

Redo log files are Oracle's way to record all the changes made to the data in the database to provide the ability to recover from media failure or system failure in the database, in the instance, or on the server on which they are running. This chapter provides information on redo log files, their maintenance, and where to gather information concerning them.

Redo log files are organized into groups. At least two groups are required for an Oracle database and its instance, each group having at least one member. The next section provides information concerning the purpose of the redo log files.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net