In this article you will get to know the process of How to do “Multiplexing of Control Files” through pfile in Oracle 11g.
For “Multiplexing of Control Files” through pfile we need to follow below steps.
Note: – As from the above output we can see 2 control files are in IN USE. Now I will add one more control file in /u01/app/oracle/oradata/prod location.
Step 2) Second step is to edit pfile which is under ORACLE_HOME/dbs location.
Note: – I have added third control file in pfile.
Step 3) Now we need to copy the content through ‘cp’ command to make the control files in sync.
[[email protected] dbs]$ cp /u01/app/oracle/oradata/prod/control01.ctl /u01/app/oracle/oradata/prod/control03.ctl
[[email protected] dbs]$ cp /u01/app/oracle/fast_recovery_area/prod/control02.ctl /u01/app/oracle/oradata/prod/control03.ctl
Step 4) Now shut down the database through shut immediate command then start it again.
SQL> shut immediate;
ORACLE instance shut down.
Hope this blog will help you!!
If this article is useful for you please comment, share with your friends.
In case of any issues please send your query to below comment section.
For more articles please do visit below links: –