Results 1 to 11 of 11
  1. #1
    Join Date
    Dec 2007
    Posts
    28

    Unanswered: How do you multiplex control files?

    A quick question: how do you multiplex control files?
    Can't multi-plex from Enterprise Manager, can't manually edit the spfile.
    Oracle instructions say to shut down database and edit the spfile but how do you do this?

  2. #2
    Join Date
    May 2006
    Posts
    132
    The docs are great for this kinda stuff (Managing Control Files).

  3. #3
    Join Date
    Dec 2007
    Posts
    28
    But that's exactly where i came from and why i posted on the forum.
    Oracle advice on how to multiplex control files (from that link):
    1.Shut down the database.
    2.Copy an existing control file to a new location, using operating system commands.
    3.Edit the CONTROL_FILES parameter in the database initialization parameter file to add the new control file name, or to change the existing control filename.
    4.Restart the database.

    But how do i do step3 when i can't edit the spfile for my database directly? (since it is a binary file).

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Sql> Create Pfile From Spfile;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    You need to create a new SPFILE.

    http://download.oracle.com/docs/cd/B...htm#sthref5347

    You may need to create a pfile from the spfile to begin with, though.

  6. #6
    Join Date
    Dec 2007
    Posts
    28
    Gotcha. Thanks guys.

  7. #7
    Join Date
    Dec 2007
    Posts
    253
    Edit: Screwed up and posted twice. 2nd post is more readable. Soz
    Last edited by pablolee; 01-15-08 at 05:02.

  8. #8
    Join Date
    Dec 2007
    Posts
    253

    Red face

    You do NOT need to create a new sp file, nor do you need to create a pfile from the spfile. You simply need to alter the control_files parameter whilst the database is up and running and add the scope = spfile onto the end of the code:
    Code:
    alter system set control_files = 'ctrl1','ctrl2','ctrln'
    scope = spfile
    Then shutdown the db, copy the controlfile and start the db.

  9. #9
    Join Date
    Dec 2007
    Posts
    28
    Did the create pfile from spfile, edited the pfile and then turned it back into a pfile yesterday and it worked, now i've got multiplexed control files :-)
    But this way looks quicker and I've got another identical system so i'll try this method on the 2nd oracle server.
    (i will try 'scope = both' to make changes on the running instance as well as the spfile).

  10. #10
    Join Date
    Dec 2007
    Posts
    253
    Do not use 'scope = both', it will not work.
    The reason for 'scope = spfile' is so that the instance will not try to write to an spfile that currently does not exist. If you use scope = both, the instance will instantly start trying to write to an spfile that you have not yet created.
    scope = spfile is the only one that will work with this particular set of tasks.

  11. #11
    Join Date
    Dec 2007
    Posts
    28
    ok, scope=spfile and then i'll restart to make sure it worked. Thanks.

Posting Permissions

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