您好,欢迎光临! 请 |

Introduce the Oracle Control File

作者: | 分类:Oracle | Tag:, | 评论:1 
字号:T|T

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%

原创内容,转载时请保留原文信息:
文章标题:Introduce the Oracle Control File
↑上一篇↑:
↓下一篇↓:

1 篇回应 (访客:1 篇, 博主:0 篇)

  1. Rix Chan 2014-20-03

    收获不少:
    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

    #-49楼

插入图片

NOTICE1:请申请gravatar头像,没有头像的评论可能不会被回复|头像相关帮助!