-
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.
Reddy,Sam
-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|