Multiple Control File

MIRRORING / MULTIPLEXING THE CONTROLFILES.

SQL>create pfile from spfile;

Note : Pfile will be created using spfile in the default location of spfile

SQL>Shu immediate;

After shutting down use the OS command to make a copy of the controlfile in your desired location and by your desired name

After Coping make changes to add new name and location of control file or files in initialization parameter file i.e. PFILE

SQL>startup pfile=’path and name of pfile’;

Check the name and location of control files now..

SQL>select name from v$controlfile;

SQL>create spfile from pfile;

So that next time you don’t have to mention pfile at the time of startup.