关于控制文件

来源：互联网发布：魔兽世界加速器mac 编辑：程序博客网时间：2024/04/28 00:27

Maintaining the control file

1. Sized initially by CREATE DATABASE

Main determinants: MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, MAX INSTANCES

2. Multiplexing the Control file : storing each copy on a different physical disk.

3. Backing Up the Control Files

a. Using spfile

1. Alter the spfile

ALTER SYSTEM SET control_file =

‘$HOME/ORADATA/u01/ctrl01.ctl’ , ‘$HOME/ORADATA/u02/ctrl02.ctl’

scope=spfile;

u01和u02对应不同的物理磁盘

2. Shut down the database

shutdown immediate

3. Create additional control files:

cp $HOME/ORADATA/u01/ctrl01.ctl $HOME/ORADATA/u02/ctrl02.ctl

4. Start the database

Startup

b. Using pfile

1. Shut down the database:

Shutdown immediate

2. Create additional control files:

cp $HOME/ORADATA/u01/ctrl01.ctl $HOME/ORADATA/u02/ctrl02.ctl

3．Add control file names to pfile: (纯手工活儿)

CONTROL_FILES=$HOME/ORADATA/u01/ctrl01.ctl $HOME/ORADATA/u02/ctrl02.ctl

4. Start the database

startup pfile = $ORACLE_HOME/dbs/initwade.ora

SQL> show parameter control #查看变化

c. Using OMF #尚处菜鸟级别就不玩了

4. Get control file information

v$controlfile, v$parameter, v$parameter, v$controlfile_record_section,

v$ show parameter control_files (推荐)