Oracle control file multiplexing

Oracle control file multiplexing

1. Control File multiplexing

1. show parameter control
-- View Control File Information
Show parameter spfile
-- Check whether spfile exists.
Create pfile from spfile;
-- Generate pfile
Shutdown immediate
-- Close the database
2. Modify the pfile and add multiple paths.
Vi $ ORACLE_HOME/dbs/initORCL. ora
Copy the original controlfile to the newly added directory;
Cp ......
3. create spfile from pfile;
-- Generate spfile
Startup
-- Open the database
Show parameter control
-- Check whether control file information is multiplexing

Method 2:
1. Use the following command to change the SPFILE:
Alter system set control_files =
'/U01/app/oracle/oradata/orcl/control01.ctl ',
'/U01/app/oracle/oradata/orcl/control02.ctl ',
'/U01/app/oracle/oradata/orcl/control03.ctl' SCOPE = SPFILE;

2. Shut down the database.

3. Use the operating system to copy the existing control file to the selected location for the new file.

4. Open the database