Oracle control file multiplexing and oracle control 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
Solution to oracle control file multiplexing problem, error ora-00940
Yes
Alter system
You have converted it into alter syetem.
Control files and data files in oracle
The control file is used when the oracle database is started. It stores some information about the database structure, such as the database name, Instance name, data file location, tablespace, and log file;
The data file is the place where the oracle database actually stores data. For example, the data you insert using the insert statement is first stored in the memory, and then oracle will follow its own mechanism, write to a data file;
Do you understand?