We can do the multiplexing either by pfile or spfile. I have described both the methods in this post.
Multiplexing with pfile
- Show parameter controlfile;
- Add the third control file in pfile,
Make sure the 3rd cfile location is available at os level,
- Copy the cfile from old location to new location,
- Startup the database with pfile
- New control file is added consistently,
Multiplexing with spfile
By default startup command would take spfile,
- Now startup; the database using spfile,
However, there are 2 c-files with respect to spfile,
- Set the new cfile
- Copy at os level after shutdown the database
Scope =spfile - changes reflected in next startup
Scope=memory - changes reflects in current instance
Scope=both – changes reflects current instance and next startup as well
That's it. We are completed the multiplexing task of control file.