Oracle Multiplex Control File

By Kamran Agayev A.

The following steps are for multiplexing the Control File:

SQL> CREATE PFILE=’/tmp/pfile.ora’ FROM SPFILE;

File created.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 – Production

With the Partitioning, OLAP and Data Mining options

[oracle@localhost /]$ vi /tmp/pfile.ora

Here, change CONTROL_FILES parameter and indicate the second control file on the newly created hard disk, which mounted to /control_file_folder

*.control_files=’/home/oracle/product/10.1.0/oradata/qafqaz/control01.ctl’,'/control_file_folder/control02.ctl’

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> host

[oracle@localhost /]$ su root

Password:

[root@localhost /]# chown -R oracle:oinstall /control_file_folder/

[root@localhost /]# exit

exit

[oracle@localhost /]$ cp /home/oracle/product/10.1.0/oradata/qafqaz/control01.ctl /control_file_folder/control02.ctl

[oracle@localhost /]$ cd /control_file_folder/

[oracle@localhost control_file_folder]$ ls -lh

total 2.8M

-rw-r—–  1 oracle oinstall 2.8M Mar 14 23:56 control02.ctl

[oracle@localhost control_file_folder]$

[oracle@localhost control_file_folder]$ sqlplus “/as sysdba”

SQL*Plus: Release 10.1.0.3.0 – Production on Sat Mar 14 23:57:15 2009

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create spfile from pfile=’/tmp/pfile.ora’;

File created.

SQL> startup

ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                   778212 bytes
Variable Size              61874204 bytes
Database Buffers          104857600 bytes
Redo Buffers                 262144 bytes

Database mounted.

Database opened.

SQL> show parameter control_files

NAME          TYPE        VALUE
----------------------------------------------

control_files   string  /home/oracle/product/10.1.0/oradata/qafqaz/control01.ctl, /control_file_folder/control02.ctl

SQL>

This process is integral to adding a new hard disk on Linux.