We are going to have look on the steps which we use for Multiplex Controlfile In Oracle RAC. The control file is the most important file in Oracle database. These few lines explain about the technical definition of the control file.

A control file is a small binary file that is part of an Oracle database. The control file is used to keep track of the database’s status and physical structure. Every Oracle Database must have at least one control file. However, it is recommended to create more than one, up to a maximum of 8. Each copy of a control file should be stored on a different disk drive. One practice is to store a control file copy on every disk drive that stores members of online redo log groups if the online redo log is multiplexed. By storing control files in these locations, you minimize the risk that all control files will be lost in a single disk failure.

Oracle always recommends keeping the controlfile in multiple diskgroups.  For standalone database multiplexing controlfile is straightforward, But for RAC, we need to follow below steps.

1. Check the controlfile location:

Currently, there is only one controlfile under +DATA diskgroup. We will multiplex them by to REDOA and REDOB diskgroup.

2. Modify the control_files parameters with diskgroup nam

3. Start the database in the nomount stage:

4. Check the control_file parameter:

5. Stop and start the database in open mode:

6. Check the controlfile from v$controlfile;

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply