关于控制文件

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  (推荐)