HOW WE CAN ADD A NEW CONTROL FILES:-
1.......
SQL> select * from v$control file;
STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --- ---------- --------------
/u03/oracle/11.2/sachin/redo_01/sachin_control01.ctl NO 16384 594
/u04/oracle/11.2/sachin/arch/sachin_control02.ctl NO 16384 594
/u05/oracle/11.2/sachin/redo_02/sachin_control03.ctl NO 16384 594
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
2..Make a new file manually same location which you want to make like below:---sachin_control04.ctl (new file)
oracle@ecnshtestdb02:sachin:>cp /u05/oracle/11.2/sachin/redo_02/sachin_control03.ctl /u05/oracle/11.2/sachin/redo_02/sachin_control04.ctl
oracle@ecnshtestdb02:sachin:>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 19 15:17:49 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 801701888 bytes
Fixed Size 2232640 bytes
Variable Size 310382272 bytes
Database Buffers 482344960 bytes
Redo Buffers 6742016 bytes
3...........
SQL> alter system set control_files='/u03/oracle/11.2/sachin/redo_01/sachin_control01.ctl','/u04/oracle/11.2/sachin/arch/sachin_control02.ctl','/u05/oracle/11.2/sachin/redo_02/sachin_control03.ctl','/u05/oracle/11.2/sachin/redo_02/sachin_control04.ctl' scope=spfile;
System altered.
4..
SQL> shutdown
ORACLE instance shut down.
5...
SQL> startup
ORACLE instance started.
Total System Global Area 801701888 bytes
Fixed Size 2232640 bytes
Variable Size 310382272 bytes
Database Buffers 482344960 bytes
Redo Buffers 6742016 bytes
Database mounted.
Database opened.
6....
SQL> select * from V$controlfile;
STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --- ---------- --------------
/u03/oracle/11.2/sachin/redo_01/sachin_control01.ctl NO 16384 594
/u04/oracle/11.2/sachin/arch/sachin_control02.ctl NO 16384 594
/u05/oracle/11.2/sachin/redo_02/sachin_control03.ctl NO 16384 594
/u05/oracle/11.2/sachin/redo_02/sachin_control04.ctl NO 16384 594
SQL>