Multiplexing Oracle Control File
1 Multiplexing the control file when using SPFILE
Firstly, Obtain the information of your control file
SQL> select * from v$controlfile;
| STATUS | NAME | IS_ | BLOCK_SIZE | FILE_SIZE_BLKS |
| /u01/oradata/helen/control01.ctl | NO | 16384 | 430 | |
| /u01/oradata/helen/control02.ctl | NO | 16384 | 430 |
also you can issue this command show parameter control_files to get the information of your control file.
Secondly, Make sure that your server is using the SPFILE
SQL> show parameter spfile; Aafter this command is executed,we should get some value like this
| NAME | TYPE | VALUE |
| spfile | string | /u01/app/oracle/dbs/spfilehelen.ora |
if there is no result returned (a truly result for the VALUE column in the above table),it means that your server is now using a PFILE. 
How to Multiplexing Control File when using PFILE ? We will describe it soon . Now,we will multiplex the Control File:
① Alter the SPFILE
SQL> alter system set control_files=’/u01/oradata/helen/control01.ctl’,
‘/u01/oradata/helen/control02.ctl’, ’/u01/oradata/control03.ctl’ scope=spfile;
System altered.
② Shutdown the database
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
③ Create the additional Control File
[oracle@Linux10g ~]$ cp /u01/oradata/helen/control01.ctl /u01/oradata/control03.ctl
④ Startup the database
SQL> startup;
ORACLE instance started.
Total System Global Area 343932928 bytes
Fixed Size 1219328 bytes
Variable Size 79693056 bytes
Database Buffers 260046848 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
⑤ Identifying our Control File again
SQL> select * from v$controlfile;
| STATUS | NAME | IS_ | BLOCK_SIZE | FILE_SIZE_BLKS |
| /u01/oradata/helen/control01.ctl | NO | 16384 | 430 | |
| /u01/oradata/helen/control02.ctl | NO | 16384 | 430 | |
| /u01/oradata/control03.ctl | NO | 16384 | 430 |
NOw,we have multiplexed the Control File When using SPFILE.
2 Multiplexing the control file when using PFILE
First of all, you should to know if your server is now using a PFILE ?
| NAME | TYPE | VALUE |
| spfile | string |
⑤ Identifying our Control File again,to see if it works correctly.
SQL> select * from v$controlfile;
| STATUS | NAME | IS_ | BLOCK_SIZE | FILE_SIZE_BLKS |
| /u01/oradata/helen/control01.ctl | NO | 16384 | 430 | |
| /u01/oradata/helen/control02.ctl | NO | 16384 | 430 | |
| /u01/oradata/control03.ctl | NO | 16384 | 430 | |
| /u01/oradata/control04.ctl | NO | 16384 | 430 |
From OracleOnLinux, post Multiplexing Oracle Control File
Categories: Experiments, Oracle | 
Tags: | 
6 Comments »
good job
Thank you.I will continue to write more and more articles to log my experiences.
BTW: banping, you are the one,you are the first one who commented on my site.
The old link dont work, ill repost what i posted earlier… Hey, long story short. A couple weeks ago i saw a comment just like this one promoting a product known as Mobile Monopoly. I decided to visit the site and check the product out, i was amazed with it and signed up correct away. So far i have made $2,512 in 3 weeks. I suggest you all check their website out, what have you got to lose? I GUARANTEE you will sign up with them once you watch their video… The method is just incredible for generating money online and the potential cash you can make from it’s near infinite. Really worth looking into… Mobile Monopoly
Heya guys, I spottet a excellent way to make tons of money online blogging. I presume this is mainly for the website administrator but there are probably alot more bloggers reading this. I’ve made thousands using the techniques described in the product and its only been 2 months. Auto Blog System X – Blog to the bank
Hey guys i wish to share with you a way i make $500 daily and i only spend 5 minuites doing it a day! I strongly suggest you check their website out as there is really a brilliant video that explains everything you need to know. Check them out at DOMINATE MOBILE MARKETING
The blog was absolutely fantastic! Lots of great information and inspiration, both of which we all need!