tyring to move control files/path in ini file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: tyring to move control files/path in ini file

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    tyring to move control files/path in ini file

    I am using SPFILE??? How to move controlfile from one location to another?Pls let me know the steps to do it.

    Many Thanks,

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    somthing like:

    shutdown
    move files to new location
    startup nomount
    alter system set control_files='new location'
    alter database open;
    Assistance is Futile...

  3. #3
    Join Date
    Jan 2003
    Posts
    141
    Attempting to move CONTROL files (CONTROL01/02/03.CTL) into directories differing from the installation default directory location results in this "memory realm" error.

    TO move these files I am following proper procedures of
    1) stopping instance
    2) moving the control01/02/03.ctl files to desired directories, 3
    ) modifying INIT.ora initialization file to reflect proper new path for each file,
    4) restart instance.

    After restarting the instance its not taking the controlfile in the new location. Deleting the controlfile from old location and starting restarting the db having memory realm" error.

    Pls advice if i am wrong...

    I am following these steps.

    Shutdown the database
    copy the the controlfiles from old to new location
    startup nomount
    alter system set control_files='new location"
    alter database open

    Many Thanks,
    Last edited by castlerock; 07-14-2005 at 11:41 AM.

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    You can also try creating pfile from spfile.

    CREATE PFILE FROM SPFILE;
    Shutdown the database.
    Copy control file to new location.
    Make changes in the pfile to point control_file to new location.
    Login to sqlplus as sysdba.
    Create spfile from pfile.
    Startup the database.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Jan 2003
    Posts
    141
    Thanks a lot

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    alter system set control_files='new location" will not work, you must edit your pfile

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    I knew something was wrong and Pando pointed it out
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Ooh yes, my bad. Just got to work and tried it. Sorry Castlerock.
    Assistance is Futile...

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