Oracle Control File multiplexing

I. Control file multiplexing

1.show parameter control
--View Control file information
Show Parameter SPFile
--see if there are spfile
Create Pfile from SPFile;
--Generate Pfile
Shutdown immediate
--Guanqu
2. Modify the Pfile file to add multiple paths
VI $ORACLE _home/dbs/initorcl.ora
Copy the original controlfile to the new add path directory;
Cp......
3.create SPFile from Pfile;
--Generate SPFile
Startup
--Open Database
Show parameter control
--See if control file information is multiplexed

Law II:
1. Change the SPFILE using the following command:
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. Close the database.

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

4. Open the Database

Oracle Control File multiplexing