Conrofile move
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Conrofile move

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    Question

    Hi:

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

    Thanks.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  3. #3
    Join Date
    Jan 2001
    Posts
    230
    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,

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width