oracle11g如何修改控制文件路径

这篇文章主要介绍oracle11g如何修改控制文件路径，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

1.查看路径

SQL> show parameter control;NAME     TYPE------------------------------------ ----------------------VALUE------------------------------control_file_record_keep_time     integer7control_files     string/home/app/oracle/oradata/orahq/control01.ctl, /home/app/oracle/fast_recovery_area/orahq/control02.ctlcontrol_management_pack_access     stringDIAGNOSTIC+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> startupORACLE instance started.Total System Global Area 2.1379E+10 bytesFixed Size    2262656 bytesVariable Size 1677724032 bytesDatabase Buffers 1.9663E+10 bytesRedo Buffers   36073472 bytesDatabase 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     integer7control_files     string/alidata1/oradata/orahq/control01.ctl, /alidata1/oradata/orahq/control02.ctlcontrol_management_pack_access     stringDIAGNOSTIC+TUNING

以上是"oracle11g如何修改控制文件路径"这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注行业资讯频道！