In this article, you will get to know the process of How to do “Multiplexing of Control Files” through spfile in Oracle 11g.
Example to create spfile from pfile: –
Note: – At present, I have 2 control files, I will add one more Control files in the same location.
Now you can see from above output control04.ctl file has been physically added successfully under /u01/app/oracle/oradata/prod/control04.ctl location.
Step 3) Now you need to set the same through alter command.
a) first shut down the database
b) Startup (Start the database through spfile)
Step 4) Now through SQL prompt alter the changes.
Step 5) Now shutdown and start the database again and check the status of added Control file.
a) Shut Immediate
c) Status of the added Control file
As we can check from above output 4th control files has been added and the database is also up and running.
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: –