Multiplexing of control files

.................Multiplexing of control files.....................




Firstly we need to create a mount point where we want to store the redo logs.
mkdir /redoa
mkdir /redob
mkdir /redoc

then gven the permission and owner to the mount points;

chmod -Rf 777 /redoa
chmod -Rf 777 /redob
chmod -Rf 777 /redoc

chown -Rf oracle:oinstall /redoa
chown -Rf oracle:oinstall /redob
chown -Rf oracle:oinstall /redoc

........................connect to database..................

root@ab ~]# su - oracle
[oracle@ab ~]$ export ORACLE_SID=dborcl
[oracle@ab ~]$ sqlplus as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Mar 12 16:32:20 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


......................Show the control file location.............................

SQL> show parameter control_files;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /u01/app/oracle/oradata/dborcl
                                                 /control01.ctl, /u01/app/oracl
                                                 e/oradata/dborcl/control02.ctl




............................now Shutdown the database.....................


SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>exit
...........................Through Os level copy the location where we want...............

oracle@ab ~]$
[oracle@ab ~]$ cp /u01/app/oracle/oradata/dborcl/control01.ctl /redoa/control01.ctl
[oracle@ab ~]$ cp /u01/app/oracle/oradata/dborcl/control01.ctl /redob/control02.ctl
[oracle@ab ~]$ cp /u01/app/oracle/oradata/dborcl/control01.ctl /redoc/control03.ctl

.......................................open the database in nomount stage................................



[oracle@ab ~]$ sqlplus as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Mar 12 16:32:20 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



SQL> startup nomount;
ORACLE instance started.

Total System Global Area  885211136 bytes
Fixed Size                  2294456 bytes
Variable Size             620760392 bytes
Database Buffers          255852544 bytes

......................now set the new loction of control_files .......................................

SQL> alter system set control_files='/redoa/control01.ctl','/redob/control02.ctl','/redoc/control03.ctl' scope=spfile;                        

System altered.



..............................shutdown the datbase.....................................

SQL> shu immediate
ORA-01507: database not mounted

................................................now startup the the database...............................

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  885211136 bytes
Fixed Size                  2294456 bytes
Variable Size             620760392 bytes
Database Buffers          255852544 bytes
Redo Buffers                6303744 bytes
Database mounted.
Database opened.


.................now view the control file location..........................

SQL> show parameter control_files;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /redoa/control01.ctl, /redob/c
                                                 ontrol02.ctl, /redoc/control03
                                                 .ctl


..........................................................................................................