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

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

If C drive fails :confused:

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

sorry dbasan what do you mean by this

Quote:

---

Originally Posted by seyiisq

sorry dbasan what do you mean by this

---

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

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. :)

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

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.

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]

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.

Do you know what happens when you startup nomount ? If you have not figured out.................Then

do the 4th step before step 1 and you are good to go. :)

Quote:

---

Originally Posted by 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 (Just do this)

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

---

create pfile='/somepath/pfile' from spfile;
then go to that directory
and open the pfile with vi ,or notepad(windows).
Change the lines about control files;
Like;
*.control_files='/ora9db/oradata/HISDB/control01.ctl','/oradb/oradata/HISDB/control02.ctl','/ora9db/oradata/HISDB/control03.ctl'

then save it.
now shutdown the database;
and finally startup with that newly created pfile.
startup pfile='/somepath/pfile'.

bytheway, it doesnt mean that,if the database uses a spfile,the parameter can be changed dynamically.
If the parameter is non session or system modifiable,you cant modify it during runtime.