Search This Blog

Thursday, December 29, 2011

How to Multiplex Control Files ?

To multiplex a control file:

1. Set the new location.

   Example: SQL> alter system set control_files='/u01/app/control04.ctl',
                    '/u01/app/control01.ctl','/u01/app/control02.ctl',
                     '/u01/app/control03.ctl' scope=spfile;

2. Shutdown the database
3. Copy a already existing controlfile to the above locatons
   and rename it.

4. Startup the database.

0 comments:

Post a Comment