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

1.查看路径

SQL>showparametercontrol;NAMETYPE----------------------------------------------------------VALUE------------------------------control_file_record_keep_timeinteger7control_filesstring/home/app/oracle/oradata/orahq/control01.ctl,/home/app/oracle/fast_recovery_area/orahq/control02.ctlcontrol_management_pack_accessstringDIAGNOSTIC+TUNING

2.修改参数文件

SQL>altersystemsetcontrol_files='/alidata1/oradata/orahq/control01.ctl','/alidata1/oradata/orahq/control02.ctl'scope=spfile;Systemaltered.

3.重启数据库

SQL>shutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea2.1379E+10bytesFixedSize2262656bytesVariableSize1677724032bytesDatabaseBuffers1.9663E+10bytesRedoBuffers36073472bytesDatabasemounted.Databaseopened.

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>showparametercontrol;NAMETYPE----------------------------------------------------------VALUE------------------------------control_file_record_keep_timeinteger7control_filesstring/alidata1/oradata/orahq/control01.ctl,/alidata1/oradata/orahq/control02.ctlcontrol_management_pack_accessstringDIAGNOSTIC+TUNING

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