Multiplexing the Control File

Multiplexing the Control File

Note: A control file can be multiplexed (copied) maximum 8 times
“ USING SPFILE “
Step-1. Alter the spfile using :
SQL> ALTER SYSTEM SET control_files =
2. ‘C:\ORACLE\ORADATA\ORCL\CTRL01.CTL’,
3. ‘C:\ORACLE\ORADATA\ORCL\CTRL02.CTL’ SCOPE = SPFILE;
Step-2. Shutdown the database
SQL> SHUTDOWN IMMEDIATE
Step-3. Copy control file at some other location using Operating system → Rename the file → again
paste the file into previous folder from where we have coped it .
Step-4. Start the database
SQL> STARTUP
“ USING PFILE “
Step-1. Shutdown the database
SQL> SHUTDOWN IMMEDIATE
Step-2. Copy control file at some other location using Operating system → Rename the file → again
paste the file into previous folder from where we have coped it
Step-3. Add control files name in pfile(init.ora)
CONTROL_FILES = (‘C:\ORACLE\ORADATA\ORCL\CTRL01.CTL’,
‘C:\ORACLE\ORADATA\ORCL\CTRL02.CTL’)
Step-4. Start the database
SQL> STARTUP