How to Multiplex Controlfile in Oracle RAC or ASM

Hi,

I will explain How to Multiplex Controlfile in Oracle RAC or ASM in this article.

 

 

The Control file is a file with a .ctl extension that is physically stored on the operating system that is a must for an Oracle database. This file also acts as the brain for our Oracle database. When the Oracle database starts, it reads the parameter file called SPFILE or PFILE and learn the location of the Control file. Because the Control file is the brain of our database, the database needs to find this file to work. If it cannot find the Control File, the Oracle database will not start and will give an error. Thats why, the control file is stored in 2 copies in the production databases. Oracle’s recommended configuration is that we store 3 copies on separate disks.

 

You can find more details about controlfile like following link.

 

Now let’s go to multiplex controlfile on 2 node RAC. Normally, we have one controlfile which is located on +DATA ASM disk group, we will multiplex it and new controlfile will be located on +RECO Disk group. Thus, database will run with two controlfile simultaneously.

If one controlfile is corrupted, then database can run with other controlfile.

 

 

Check existing controlfile.

SQL> show parameter control_file
NAME TYPE VALUE
 ------------------------------------ ----------- ------------------------------
 control_file_record_keep_time integer 7
 control_files string +DATA/POCDB/controlfile/current.256.847487823

 

 

Stop RAC database like following.

srvctl stop database -d POCDB


start database nomount mode like following.

srvctl start database -d POCDB -o nomount


  

Now let’s go to multiplex controlfile on ASM using restore existing controlfile like following.

 

connected to target database: POCDB (not mounted)
RMAN> restore controlfile from '+DATA/POCDB/controlfile/current.256.847487823';
Starting restore at 14-MAY-14
using target database control file instead of recovery catalog
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID=853 instance=POCDB1 device type=DISK
channel ORA_DISK_1: copied control file copy
 output file name=+DATA/POCDB/controlfile/current.256.847487823
 output file name=+RECO/POCDB/controlfile/current.263.847536995
 Finished restore at 14-MAY-14
RMAN>

 

Set controlfiles parameter with two controlfiles like following.

 SQL> alter system set control_files='+DATA/POCDB/controlfile/current.256.847487823', +RECO/POCDB/controlfile/current.263.847536995'  scope=spfile sid='*';

 

 

Stop RAC database again

oracle:oraserver01:/home/users/oracle:>srvctl stop database -d POCDB


Then start RAC database now like following.

 

 oracle:oraserver01:/home/users/oracle:>srvctl start database -d POCDB

 

 

 

Now check controlfile again, you can see that controlfile multiplexed

 

 SQL> show parameter control_files
NAME TYPE VALUE
 ------------------------------------ ----------- ------------------------------
 control_files string +DATA/POCDB/controlfile/current.256.847487823, +RECO/POCDB/controlfile/current.263.847536995

 

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *