Shulou(Shulou.com)06/01 Report--

-- do it when the database is open

SQL > alter system set control_files='/u01/app/oracle/oradata/PROD4/PROD4/control01.ctl','/u01/app/oracle/oradata/PROD4/PROD4/control02.ctl','/home/oracle/control03.ctl' scope=spfile

-- View the settings you have made

SQL > show parameter control

-- close the database

SQL > shutdown immediate

-- copy control files

Cp / u01/app/oracle/oradata/PROD4/PROD4/control01.ctl / home/oracle/control03.ctl

The reason is to copy control files with the database open.

-- start the database

SQL > startup

-- View control file parameters

SQL > show parameter control

NAME TYPE VALUE

-

Control_file_record_keep_time integer 7

Control_files string / u01/app/oracle/oradata/PROD4/

PROD4/control01.ctl, / u01/app/

Oracle/oradata/PROD4/PROD4/con

Trol02.ctl, / home/oracle/contr

Ol03.ctl

Control_management_pack_access string DIAGNOSTIC+TUNING

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.