1.查询到现有控制文件列表: SQL> select name from v$controlfile;NAME ----------------------------------------------------------- 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 2.增加一个文件: 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=spfile 3.重启服务器.使修改生效. (修改控制文件前,一定要备份.)
增加数据库控制文件命令
最新推荐文章于 2022-11-19 10:38:23 发布