SQL> show parameter control_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/app/oracle/oradata/orcl/c
ontrol01.ctl, /u01/app/oracle/
oradata/orcl/control02.ctl
或者可以查询v$parameter视图。
select * from v$parameter where name = 'control_files'
alter system set control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/fullbackup/control03.ctl' scope=spfile;
Ⅲ:关闭数据库
shutdown immediate
Ⅳ:复制控制文件至新路径
和上文control_files参数文件中的路径保持一致。
cd /u01/app/oracle/oradata/orcl
cp control01.ctl /fullbackup/control03.ctl