oracle 增加控制文件的方法

先:shutdown immediate
然后物理拷贝一个控制文件
cp /opt/u01/app/oracle/oradata/cwt/control01.ctl /opt/u01/app/oracle/oradata/cwt/control04.ctl
然后如果用的spfile就用alter system 如果是用的pfile直接修改文件，我使用的spfile

startup nomount
ALTER SYSTEM SET control_files='/opt/u01/app/oracle/oradata/cwt/control01.ctl', '/opt/u01/app/oracle/oradata/cwt/control02.ctl',
 '/opt/u01/app/oracle/oradata/cwt/control03.ctl','/opt/u01/app/oracle/oradata/cwt/control04.ctl'  sope=SPFILE;

SQL> ALTER SYSTEM SET control_files='/opt/u01/app/oracle/oradata/cwt/control01.ctl',
  2 '/opt/u01/app/oracle/oradata/cwt/control02.ctl',
  3 '/opt/u01/app/oracle/oradata/cwt/control03.ctl',
  4 '/opt/u01/app/oracle/oradata/cwt/control04.ctl'
  5  SCOPE=SPFILE;

System altered.

然后shutdown immediate
startup
就生效了

如果出现了以下的错误只需要重新复制一次就可以了，原因都是没有关闭完全就复制了。