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

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

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

Postgres Streaming Replication Configuration

vacuumlo - removing large objects orphans from a database PostgreSQL