1.查看路径
SQL> show parameter control; NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ control_file_record_keep_time integer 7 control_files string /home/app/oracle/oradata/orahq /control01.ctl, /home/app/orac le/fast_recovery_area/orahq/co ntrol02.ctl control_management_pack_access string DIAGNOSTIC+TUNING
2.修改参数文件
SQL> alter system set control_files='/alidata1/oradata/orahq/control01.ctl','/alidata1/oradata/orahq/control02.ctl' scope=spfile; System altered.
3.重启数据库
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 2.1379E+10 bytes Fixed Size 2262656 bytes Variable Size 1677724032 bytes Database Buffers 1.9663E+10 bytes Redo Buffers 36073472 bytes Database mounted. Database opened.
4.mv
[oracle@oraclerac1 ~]$ mv /home/app/oracle/oradata/orahq/control01.ctl /alidata1/oradata/orahq/control01.ctl [oracle@oraclerac1 ~]$ mv /home/app/oracle/fast_recovery_area/orahq/control02.ctl /alidata1/oradata/orahq/control02.ctl
5.查看是否修改成功
SQL> show parameter control; NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ control_file_record_keep_time integer 7 control_files string /alidata1/oradata/orahq/contro l01.ctl, /alidata1/oradata/ora hq/control02.ctl control_management_pack_access string DIAGNOSTIC+TUNING
