Asher/ 十月 15, 2009/ Oracle/ 1 comments

Control File

The control file is a small binary file necessary for the database to start and operate successfully. Each control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine whether the database is in a valid state to use. A control file is updated continuously by the Oracle server during database use, so it must be available for writing whenever the database is open. The information in the control file can be modified only by the Oracle server; no database administrator or end user can edit the control file. If for some reason the control file is not accessible, the database does not function properly. If all copies of a database’s control files are lost, the database must be recovered before it can be opened.

Contents of the Control file

A control file contains the following entries: • Database name and identifier • Timestamp of database creation • Tablespace names • Names and locations of data files and online redo log files • Current online redo log file sequence number • Checkpoint information • Begin and end of undo segments • Redo log archive information • Backup information

A control file contains the following entries:
• Database name and identifier
• Time stamp of database creation
• Tablespace names
• Names and locations of data files and onli
log files
• Current online redo log file sequence num
• Checkpoint information
• Begin and end of undo segments
• Redo log archive information
• Backup information

……………………………………End

顶一下
(0)
100%
踩一下
(0)
100%
Share this Post

1 Comment

  1. 收获不少:
    1 db name & id
    2 db created timestamp
    3 tbs names
    4 datafile & logfile
    5 current sequence number
    6 ckpt info
    7 undo segment起始和终止
    8 arch info
    9 bak info

Leave a Comment

电子邮件地址不会被公开。 必填项已用*标注

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*