multiplexing controlfile

[seyiisq]

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

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

[PAVB]

http://www.dbasupport.com/forums/sho...ve+controlfile

[dbasan]

If C drive fails

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

[seyiisq]

sorry dbasan what do you mean by this

[PAVB]

sorry dbasan what do you mean by this

(disk) fails=crash=gone=dead=kaput

[dbasan]

sorry dbasan what do you mean by this

I mean multiplexing to different drives, like

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.

[seyiisq]

thanks, after multiplexing do i need to edit my initfile
note i use spfile which is the default

[dbasan]

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.

[seyiisq]

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.

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

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]

[Thomasps]

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.