5-Maintaining the Control File (2)

5-Maintaining the Control File (2) - aintaining the Control...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: aintaining the Control File Tathagata Bhattacharjee Maintaining the Control File Presenter Tathagata Bhattacharjee aintaining the Control File Tathagata Bhattacharjee Objective After completing this lesson, you should be able to do the following: Explain the uses of the control file List the contents of the control file Multiplex and manage the control file Manage the control file with Oracle Managed Files Obtain control information aintaining the Control File Tathagata Bhattacharjee Control File Its a binary file that defines the current state of the physical database Its necessary for the database to start and operate successfully Each control file is associated with only one Oracle database aintaining the Control File Tathagata Bhattacharjee Before a database is opened, the control file is read to determine if the database is in a valid state to use Control file is updated continuously by the Oracle server during database use, so it must be available for writing whenever database is open aintaining the Control File Tathagata Bhattacharjee The information in the control file can be modified only by the Oracle server, and not by DBA or other users If all copies of a databases control files are lost, the database must be recovered...
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 20

5-Maintaining the Control File (2) - aintaining the Control...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online