Shulou(Shulou.com)05/31 Report--

This article mainly introduces oracle11g how to modify the control file path, the article introduces in great detail, has a certain reference value, interested friends must read it!

1. View path

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

two。 Modify parameter file

SQL > alter system set control_files='/alidata1/oradata/orahq/control01.ctl','/alidata1/oradata/orahq/control02.ctl' scope=spfile;System altered.

3. Restart the database

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. Check to see if the modification is successful

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 above is all the content of the article "how oracle11g modifies the control file path" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.