Shulou(Shulou.com)06/01 Report--

Oracle Mobility Control File

OS:Windows

Oracle:10g

The mobile control file migrates the current control file from the current location to another new location.

Complete the control of file movement in six steps:

1. Get the control file name:

SQL > select status,name from v$controlfile

two。 Modify the control file name in SPFILE:

SQL > alter system set control_files=

'd:\ oracle\ new\ CONTROL01.CTL'

'd:\ oracle\ new\ CONTROL02.CTL'

'd:\ oracle\ new\ CONTROL03.CTL' scope=spfile

3. Shut down the database

SQL > shutdown immediate

4. Move the control file to a new directory

SQL > host move D:\ oradata\ old\ CONTROL01.CTL D:\ oracle\ new\ CONTROL01.CTL

SQL > host move D:\ oradata\ old\ CONTROL02.CTL D:\ oracle\ new\ CONTROL02.CTL

SQL > host move D:\ oradata\ old\ CONTROL03.CTL D:\ oracle\ new\ CONTROL03.CTL

5. Restart the database

SQL > startup

6. Verify the modification result

SQL > select status,name from v$controlfile

Thank you: I have made a summary after referring to a number of articles, and I would like to thank all the network sharers!

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.