add & delete control file

增加控制文件

查看控制文件信息

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/opt/oracle/oradata/orcl/control01.ctl

/opt/oracle/oradata/orcl/control02.ctl

/opt/oracle/oradata/orcl/control03.ctl

下面这一步，oracle一定要开着，要不然会报错（ORACLE not available）更改spfile文件的信息

SQL> alter system set control_files=

2 '/opt/oracle/oradata/orcl/control01.ctl',

3 '/opt/oracle/oradata/orcl/control02.ctl',

4 '/opt/oracle/oradata/orcl/control03.ctl',

5 '/opt/oracle/oradata/orcl/control04.ctl'

6 scope=spfile;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

复制控制文件并改名为新控制文件名字。

SQL> ho cp /opt/oracle/oradata/orcl/control01.ctl /opt/oracle/oradata/orcl/control04.ctl

SQL> ho ls /opt/oracle/oradata/orcl

control01.ctl d1.dbf redo01.log sysaux01.dbf undotbs01.dbf

control02.ctl dd.dbf redo02.log system01.dbf users01.dbf

control03.ctl log043.log redo03.log temp01.dbf

control04.ctl log04.log redo04.log undo1.dbf

启动数据库成功

SQL> startup

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1218968 bytes

Variable Size 104859240 bytes

Database Buffers 171966464 bytes

Redo Buffers 7168000 bytes

Database mounted.

Database opened.

减少控制文件

显示控制文件信息

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/opt/oracle/oradata/orcl/control01.ctl

/opt/oracle/oradata/orcl/control02.ctl

/opt/oracle/oradata/orcl/control03.ctl

/opt/oracle/oradata/orcl/control04.ctl

减少新增加的控制文件

SQL> alter system set control_files=

2 '/opt/oracle/oradata/orcl/control01.ctl',

3 '/opt/oracle/oradata/orcl/control02.ctl',

4 '/opt/oracle/oradata/orcl/control03.ctl'

5 scope=spfile;

System altered.

关闭数据库删除新增加控制文件

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> ho rm -rf /opt/oracle/oradata/orcl/control04.ctl

SQL> ho ls /opt/oracle/oradata/orcl/

control01.ctl dd.dbf redo02.log system01.dbf users01.dbf

control02.ctl log043.log redo03.log temp01.dbf

control03.ctl log04.log redo04.log undo1.dbf

d1.dbf redo01.log sysaux01.dbf undotbs01.dbf

重起数据库，使控制文件生效

SQL> startup

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1218968 bytes

Variable Size 104859240 bytes

Database Buffers 171966464 bytes

Redo Buffers 7168000 bytes

Database mounted.

Database opened.

备份控制文件

alter database backup controlfile to ‘/opt/oracle/controlfile_20090716.ctl’;

[@more@]

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

转载于:http://blog.itpub.net/22779391/viewspace-1028204/