Oracle Multiplexing Control file backup (Code instance), oracle multiplexing

Oracle Multiplexing Control file backup (Code instance), oracle multiplexing

1. view the current control file

Show parameter control_files; select name from v $ controlfile;

2. Modify the control_files parameter in the initialization parameter file, add the name of the newly added control file to the control file list, or modify the name and location of the original control file in the control file list.

Alter system set control_files = 'd: \ APP \ MARK \ ORADATA \ ORCL \ CONTROL01.CTL ', 'd: \ APP \ MARK \ FLASH_RECOVERY_AREA \ ORCL \ CONTROL02.CTL ','? E: \ orc \ CONTROL03.CTL 'scope = spfile;

3. Shut down the database

Only the Administrator has the permission to close the database.

Conn systems/123456 as sysdbashutdown immediate;

4. Create a control file copy

In this step, you need to manually copy a control file to the backup location under the oracle installation directory.

5. Start the database

Startup

If there is a problem, a ora 00205 error will occur when you manually add a control file.