multiplexing controlfile
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: multiplexing controlfile

  1. #1
    Join Date
    Jun 2007
    Posts
    29

    multiplexing controlfile

    i have my controlfiles all in a single directory but was just thinking that won't be ideal enough,as shown below.

    Code:
    SQL> show parameters control_files;
    
    NAME           TYPE                VALUE
    -------- ----------- ------------------------------
    control_files     string      C:\ORACLE\PRODUCT\10.1.\ORADATA\ORCL_1\CONTROL01.CTL, 
    C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL02.CTL, 
    C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL03.CTL
    i need to make a multiplex to a new directory like
    ''C:\oracle\product\10.1.0\oradata\orcl_1\mulplx\CONTROL04.CTL''
    If I do
    alter system set control_file=''C:\oracle\product\10.1.0\oradata\orcl_1\CONTROL01.CTL'',''C:\oracle\product\10.1.0\or adata\orcl_1\mulplx\CONTROL04.CTL '' scope = spfile;

    Will oracle synchronise the new controlfile withe the old ones even if they are in different directory.
    thanks

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    If C drive fails

    Is your C drive under raid?, else you need to put them in different drives.

  4. #4
    Join Date
    Jun 2007
    Posts
    29
    sorry dbasan what do you mean by this

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by seyiisq
    sorry dbasan what do you mean by this
    (disk) fails=crash=gone=dead=kaput
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by seyiisq
    sorry dbasan what do you mean by this
    I mean multiplexing to different drives, like

    Code:
    C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL01.CTL, 
    D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL02.CTL, 
    E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL03.CTL
    This will save you against media failure if your drives not under raid. Make sure you regularly backup your controlfile.

  7. #7
    Join Date
    Jun 2007
    Posts
    29
    thanks, after multiplexing do i need to edit my initfile
    note i use spfile which is the default

  8. #8
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    That depends on how you are setting. If you make location change in spfile before shutdown, then you need not change in pfile, also you cannot use pfile for startup.

    Or the other way, change in pfile and then do a pfile startup and then create spfile and bounce the db. Its your choice.

  9. #9
    Join Date
    Jun 2007
    Posts
    29
    I connected as sysdba did the following
    1)shutdown immediate
    2)copy the controlfile successfully to new directory using the
    os command
    3)startup nomount

    Then i i tried setting the control file to the new one but got the error below.

    Code:
    SQL> alter system set control_files = ''C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL01.CTL'',''C:
    \ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\MLPLX_CTL\CONTROL01'' scope=spfile;
    alter system set control_files = ''C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL01.CTL'',''C:\ORAC
                     *
    ERROR at line 1:
    ORA-02095: specified initialization parameter cannot be modified
    I queried the v$parameter to confirm that i am using spfile as below

    Code:
    SQL> select name,value from v$parameter where name = 'spfile';
    
    NAME                           VALUE
    -----------------------------------------------------------------
    spfile     C:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\SPFILEORCL1.ORA
    
    SQL> select name,value from v$parameter where name = 'pfile';
    
    no rows selected
    pls can you help
    [Updated on: Wed, 27 June 2007 19:01]

  10. #10
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Is this a production database? When ever you touch a production database, read read read read and understand what you are doing and how you can do it.

    Just read carefully, the last post from dbasan and do again.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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