Specifying Control Files (90)

最新推荐文章于 2025-12-20 13:10:13 发布

转载最新推荐文章于 2025-12-20 13:10:13 发布 · 76 阅读

文章标签：

本文介绍了Oracle数据库中控制文件的相关概念及使用方式。控制文件由CREATE DATABASE语句创建，并可通过CONTROL_FILES初始化参数进行指定。如果不指定CONTROL_FILES参数，Oracle将使用默认文件名创建控制文件。为了确保数据库的安全性和稳定性，Oracle推荐至少使用两个位于不同物理磁盘上的控制文件。

The CONTROL_FILES initialization parameter specifies one or more control filenames
for the database. When you execute the CREATE DATABASE statement, the control
files listed in the CONTROL_FILES parameter are created.

If you do not include CONTROL_FILES in the initialization parameter file, then Oracle
Database creates a control file using a default operating system dependent filename or,
if you have enabled Oracle-managed files, creates Oracle-managed control files.

If you want the database to create new operating system files when creating database
control files, the filenames listed in the CONTROL_FILES parameter must not match
any filenames that currently exist on your system. If you want the database to reuse or
overwrite existing files when creating database control files, ensure that the filenames
listed in the CONTROL_FILES parameter match the filenames that are to be reused.

Caution: Use extreme caution when setting this specifying
CONTROL_FILE filenames. If you inadvertently specify a file that
already exists and execute the CREATE DATABASE statement, the
previous contents of that file will be overwritten.

Oracle strongly recommends you use at least two control files stored on separate
physical disk drives for each database.

设置控制文件
1. CONTROL_FILES可指定一个或多而空间文件的值
2. 在执行创建数据库语句时如果要创建的控制文件已存在 , 则会覆盖
3. Oracle建议将控制文件备份镜像

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-995933/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-995933/