Oracle control file multiplexing

Oracle control file multiplexing

1. Oracle 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

Multiplexing of Oracle Control Files