ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Manaing Control files

Manaing Control files

原创 Linux操作系统 作者:xhailiang 时间:2006-10-25 00:00:00 0 删除 编辑

Managing control files

Contril file is a binary file that records the physical stracture of the database and includes:

The database name;

Names and locations of associated datafiles and online redo log files;

The timestamp of the database creation;

The current log sequence number;

Checkpoint information;


To multiplex or move additional copies of the current control files:

Shutdown the database;

Copy an existing control file to a different location,using operating system commands;

Edit the control_files parameter in the database’s initialization parameter file to add the new contril file’s name ,or to change the existing control filename;

Restart the database;

Managing the size of control files:

The main determinants of a control file’s size are the values set for the MAXDATAFILESMAXLOGFILESMAXLOGMEMBERSMAXLOGHISTORYMAXINSTANCES parameter in the CREATE DATABASE statement that created the associated database.Increaing the values of these parameters increases the size of a control file of the associated database.

Setps for creating new control files:

1.Make a list of all datafiles and online redo log files of the database;

2.Shut down the database;

3.Backup all datafiles and online redo logfiles of the database;

4.Startup a new instance,but do not mount or open the database:

STARTUP NOMOUNT

5.Create a new control file for the database using the create control file statement;

6.store a backup of the new control file on an offline storage device.

7.Edit the CONTROL_FILES initialization parameter for the database to the control files now part of your database as created in .if you are renaming the database ,edit the db_name parameter to specify the new name;

8.recover the database if necessary .

9.open the database using one of the following methods:

If you did not perform recovery ,or you performed complete ,closed database recovery in Step 8 ,open the database normally;

Backing up control files:

Back up the control file to a binary file using the statement:

ALTER DATABASE BACKUP CONTROLFILE TO ‘DEST’;

Produce SQL statements :

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

V$CONTROLFILE_RECORD_SECTION displays information about control file record sections;

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

请登录后发表评论 登录
全部评论

注册时间:2008-02-17

  • 博文量
    270
  • 访问量
    415613