Multiplexing The Control File

MULTIPLEXING OF CONTROLFILE To safe guard against a single point of failure of the control file. Strongly each copy on a different disk. Controlfiles can be multiplexed up to 8 times. Using spfile : •

We have to bringup the database

•

In sql > ALTER SYSTEM SET CONTROL_FILES = ‘/apps/venkat/oradata/control01.ctl’, ‘/apps/venkat/oradata/control02.ctl’, ‘/apps/venkat/oradata/control03.ctl’ scope=spfile,both & memory;

•

Shutdown the database immediate

•

Copy the new controlfile by using existing controlfile under $ORACLE_BASE/oradata/sidname/

•

After that bringup the database and check it whether additional controlfile is added or not, by using select statement Sql > Select * frim v$controlfile;

Using pfile : •

If database is up and running then shutdown it

•

Copy the new controlfile by using existing controlfile under $ORACLE_BASE/oradata/sidname/

•

Edit the new controlfile in initsid.ora by using vi editer

•

Then bringup the database and check it whether additional controlfile is added or not , by using select statement Sql > Select * frim v$controlfile;