Multiplexing of the control file is done so that if you lose one control file, you will still have others to use....
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
What concerns me is where you said, "is it necessary to take a backup of the whole control file folder?" This implies that all of your control files are on the same disk volume. If you lose that disk volume, you lose all of your control files. It is important to multiplex your control files to multiple disk volumes, if at all possible.
That being said, backups of your control files are your defense against losing all of your control files. You only need to back up one control file, but as a practice, I back up all of them. I also perform a binary backup of my control file with the ALTER DATABASE BACKUP CONTROL FILE command. This gives me one more backup of my control files. I also perform a backup to a trace file with the ALTER DATABASE BACKUP CONTROL FILE TO TRACE. This may seem like overkill but with a file as important as the control files, I feel that all of these backups give me many more options should I need to restore the control file. And the backups are typically pretty small.
If you are using RMAN, then you can have RMAN back up the control file for you. I still perform the ALTER DATABASE BACKUP CONTROL FILE TO TRACE when using RMAN.
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.