Showing posts with label How to move Oracle control file. Show all posts
Showing posts with label How to move Oracle control file. Show all posts

Friday, December 14, 2007

Case when you are working with initSID.ora file:

  1. Change the new paths in the init parameter CONTROL_FILES - Reference
  2. Shutdown the database in a clean way ( Preferrable overall is this a production database
  3. Move with OS commands the control files to its new location.
  4. Startup the database

Case when you are working with spfileSID.ora file:

  1. Change the new paths of the CONTROL_FILES parameter in the spfile with
    ALTER SYSTEM SET CONTROL_FILES=... scope=SPFILE\"
    CONTROL_FILES - Reference
    ALTER SYSTEM - Reference
  2. Shutdown the database in a clean way ( Preferrable overall is this a production database )
  3. Startup the database