Multiplexing Control Files

To protect the database from a single point of failure occurring in the control file, it is strongly recommended by Oracle that the control file be multiplexed and each copy stored to a different writable disk. If the primary control file is for any reason lost, the database can continue using the multiplexed version, and the instance and database can be restarted (after alteration of the primary control file to one of the backup locations and restarting the instance and database) without the necessity of database recovery. Control files can be multiplexed up to a maximum of eight times. The Oracle server is responsible for creating and maintaining all files listed in the CONTROL_FILES parameter when the instance is ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.