数据库:oracle 11.2.0.4
系统:oel 7.9
SQL> show parameter control_files;
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
control_files string /u01/app/oracle/oradata/orcl15
0/control01.ctl, /u01/app/orac
le/fast_recovery_area/orcl150/
control02.ctl
SQL> alter system set control_files='/u01/app/oracle/oradata/orcl150/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl150/control02.ctl','/u01/app/oracle/oradata/orcl150/control02.ctl' scope=spfile sid='orcl150'; 备注:之所以添加sid='orcl150',是因为环境为DG
System altered.
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
关闭数据库后复制一份控制文件到/u01/app/oracle/oradata/orcl150/目录,并命名control02.ctl
SQL> startup
ORACLE instance started.
Total System Global Area 3206836224 bytes
Fixed Size 2257520 bytes
Variable Size 1811942800 bytes
Database Buffers 1375731712 bytes
Redo Buffers 16904192 bytes
Database mounted.
Database opened.
SQL> show parameter control_files;
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
control_files string /u01/app/oracle/oradata/orcl15
0/control01.ctl, /u01/app/orac
le/fast_recovery_area/orcl150/
control02.ctl, /u01/app/oracle
/oradata/orcl150/control02.ctl