control files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: control files

  1. #1
    Join Date
    Sep 2000
    Posts
    31
    Hi,
    I am not a DBA and i'm learning how to be one that whats my boss wants me to. This is my question: we have all control files on one drive. We would like to have each of them on different drive. How can i do it? Oracle ver 7.14 and os is unix. I really do not know much about Unix commands. Please help. Thanks in advance.

  2. #2
    Join Date
    Sep 2000
    Posts
    43

    Wink

    I can really simpathize with you :-) ... because first of all controlfiles is the main thing in the database. When oracle starts up, it goes through three stages:
    nomount (oracle reads and verified controlfiles), mount (reads and verified datafiles and you can read V$views), open, when users can connect...
    If you do not know that, I strongly suggest you do some reading... Oracle Concepts and Administrators Guide would be the first books. Please understand correctly, but you can not just move controlfiles to different drives, you can mirror controlfiles...
    You can also recreate controlfiles and before you do that, you need to edit initSID.ora and indicate different operating system path for controlfiles...
    Doc ID: 1012929.6 from Metalink will tell you how to recreate controlfile....
    Alla S. Pfauntsch
    Oracle DBA
    ========================================
    "Life is what happens while you are planning something else".

  3. #3
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    Look into upgrading to 7.3.4 at the *very* least, too. I know you have a lot on your plate, but your version of oracle is very old, if it's 7.1.4

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    jn1971,

    not to discourage you. What apfaunts says is true. Read Oracle documentation and come back here and post your Qs.
    Its lot easier to digest what people talk about here. Go to [url]http://www.ugu.com[/url] and find some basic stuff on unix too.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    Moving control files is an easy thing to do:
    1. look in your init.ora file for the control_files parameter. All control files should be listed there.
    2. Shutdown the database
    3. copy each file to its new location (cp /u01/control01.ctl /u02/control01.dbf)
    4. compare the control files to make sure they were not corrupted by the copy (diff /u01/control01.dbf /u02/control01.dbf)
    5. edit the init.ora file to tell the database where to find the control files
    6. start the database

    Note: The control file contains vital information about the state of the database. I like to have three copies of the control file; each on a seperate disk/controller pair.
    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."

  6. #6
    Join Date
    Sep 2000
    Posts
    31

    Wink control files

    Thanks very much for your helps and advices. marist89's solution is the one i looked for. Thanks very much marist89.

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