增加数据库控制文件命令

1.查询到现有控制文件列表:SQL> select name from v$controlfile;NAME-----------------------------------------------------------E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL10G/CONTROL01.CTLE:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL10G/CONTROL02.CTLE:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL10G/CONTROL03.CTL2.增加一个文件:alter system set control_files='E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL10G/CONTROL01.CTL,E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL10G/CONTROL02.CTL,E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL10G/CONTROL03.CTL,E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL10G/CONTROL04.CTL'scope=spfile3.重启服务器.使修改生效.(修改控制文件前,一定要备份.)