Control File Multiplexing Using Pfile --oracle
Control file is head of the every oracle database. If control files lost or corrupt for any kind of physical damage of storage then the database must be shutdown. So every database mast have more than one control files needed on different physical storage. Control files can be multiplexed up to eight times. There are different ways to multiplexing the control file.
Step-1: Shutdown the database as normal
SQL> shutdown normal;
Step-2: Using OS command copy the existing control file to a new name and location
$ cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/oradata/orcl/control02.ctl
Step-3: Add the new control file name to PFILE
CONTROL_FILES = (/u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/oradata/orcl/control02.ctl)
Step-4: Start the database
SQL> startup;
Step-1: Shutdown the database as normal
SQL> shutdown normal;
Step-2: Using OS command copy the existing control file to a new name and location
$ cp /u01/app/oracle/oradata/orcl/control01.ctl /u01/app/oracle/oradata/orcl/control02.ctl
Step-3: Add the new control file name to PFILE
CONTROL_FILES = (/u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/oradata/orcl/control02.ctl)
Step-4: Start the database
SQL> startup;
Comments
Post a Comment