Control file multiplexing on different disks decreases availability
Hi,
Oracle® Database Administrator's Guide 11g Release 2 (http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/control002.htm) states:
"Every Oracle Database should have at least two control files, each stored on a different physical disk."
"If any of the control files become unavailable during database operation, the instance becomes inoperable and should be aborted."
This behaviour decreases availability, because the many control file copies on different disks, the higher probability one of them fails and instance becomes inoperable.
Is this right?
If it is, having just one control file and backing it up after every change would be enough?
"Every Oracle Database should have at least two control files, each stored on a different physical disk."
"If any of the control files become unavailable during database operation, the instance becomes inoperable and should be aborted."
This behaviour decreases availability, because the many control file copies on different disks, the higher probability one of them fails and instance becomes inoperable.
Is this right?
If it is, having just one control file and backing it up after every change would be enough?
0