• Arun Kumar

Controlfile Multiplexing

Control file contains crucial database information and loss of this file will lead to loss of important data about database. So it is recommended to have multiplexed copies of files in different locations.


If control file is lost in 9i, database may go for force shutdown, where as database will continue to run, if it is 10g version and above.


Multiplexing Steps


Check if the database is running with spfile

SQL> show parameter spfile 

If yes, then check the control files

SQL> show parameter control_files 

Now add the new controlfile to below command along with old controlfiles from above command. We will add control03.ctl

SQL> alter system set control_files='/u02/prod/control01.ctl','/u02/prod/control02.ctl','/u02/prod/control03.ctl' scope=spfile; 

We need to bounce the database and copy control02.ctl as control03.ctl

SQL> shutdown immediate
SQL> ! cp /u02/prod/control01.ctl /u02/prod/control04.ctl 

Start the database

SQL> startup 


Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Automate RMAN Backups using Shell Scripts

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback