Hi:
Is it possible to move control file while database is up and running?
Thanks.
Printable View
Hi:
Is it possible to move control file while database is up and running?
Thanks.
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.
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,
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.