Describe how to multiplex control files

Check Content of control file. Make a binary copy of the control file:. Generate an SQL file to create the control file:. Multiplex control file.

Make sure that the new control file resides on a separate physical disk. The purpose of multiple control files is to protect the database in case of a disk failure. Labels: adding controlfile in oracle databse. Database opened. Hello Robert!

Leave a Reply Cancel reply Your email address will not be published. Previous Previous post: Error: cannot restore segment prot after reloc: Permission Denied. Next Next post: Recover from a corrupt or missing control file. Search for: Search. Sorry, your blog cannot share posts by email. Some one asked me, can you start a database without control file?

Multiplexing: The term multiplexing is frequently used in Telecom Industries which means mirroring in plain English. It is an act of sending signals to multiple directions at a same time. How is this relevant to Oracle database? Oracle db has the ability to write to more than one files max 8 files - 11g at a given time. This is done to preserve the copy of a file. Multiplexing of control file minimized the risk of losing a copy during single disk or media failure.

We need to do whatever we can to preserve the control file. It is recommended that you have at-least 3 copies of control files on different medias. The idea her is not to store all the eggs in a same basket!