SLTechnology News&Howtos › Database ›

Oracle controls file movement

Shulou Source: shulou.com Published: 2022-06-01 14:46:07 10月03日 Update

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!