Conrofile move

[ora_inf]

Hi:

Is it possible to move control file while database is up and running?

Thanks.

[sreddy]

What do you mean by move ? You can copy but until you bring database down and make the change in init.ora /config.ora its not effective.

[ora_inf]

Sam:

I know that, I can shut down the database and mv controlfile from one location to another at O.S level and also need to modify the config.ora file for new location.
But, I need to change the location of controlfile at o.s level while database is running, if I move the controlfile, and change the config.ora, will it impact anything like if I add datafile?

Thanks,

[marist89]

No, you can't move the location of the control files while the database is up. Shutdown the database, move the files, update your init/config.ora files, and restart the database.