Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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;


Popular posts from this blog

Ora2PG - Oracle/MySQL to Postgres DB migration Version 20.0

spfile and pfile errors

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

How to Return a Result Set from a PostgreSQL Stored Procedure

PostgreSQL New version upgrade