環(huán)境：?jiǎn)螌?shí)例
SQL> show parameter control
NAME TYPE VALUE

------------------------------------ ----------------------?------------------------------

control_file_record_keep_time integer 7
control_files string F:\APP\ADMINISTRATOR\ORADATA\O
RCL\CONTROL01.CTL, F:\APP\ADMI
NISTRATOR\ORADATA\ORCL\CONTROL
02.CTL

control_management_pack_access string DIAGNOSTIC+TUNING
SQL> alter system set control_files='F:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL','F:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL','F:\ORACLE19C\DB_RECOVERY_FILE\ORCL\AUTOBACKUP\CONTROL03.CTL' scope=spfile;
系統(tǒng)已更改。
SQL> shutdown immediate;
數(shù)據(jù)庫(kù)已經(jīng)關(guān)閉。
已經(jīng)卸載數(shù)據(jù)庫(kù)。
ORACLE 例程已經(jīng)關(guān)閉。
此時(shí)復(fù)制CONTROL01.CTL到F:\ORACLE19C\DB_RECOVERY_FILE\ORCL\AUTOBACKUP目錄下并改名為CONTROL03.CTL
啟動(dòng)數(shù)據(jù)庫(kù)：
SQL> startup
ORACLE 例程已經(jīng)啟動(dòng)。
Total System Global Area 1.0301E+10 bytes
Fixed Size 12578000 bytes
Variable Size 1778384896 bytes
Database Buffers 8489271296 bytes
Redo Buffers 20975616 bytes
數(shù)據(jù)庫(kù)裝載完畢。
數(shù)據(jù)庫(kù)已經(jīng)打開(kāi)。
SQL> show parameter control;
NAME TYPE VALUE

------------------------------------ ----------------------?------------------------------

control_file_record_keep_time integer 7
control_files string F:\APP\ADMINISTRATOR\ORADATA\O
RCL\CONTROL01.CTL, F:\APP\ADMI
NISTRATOR\ORADATA\ORCL\CONTROL
02.CTL, F:\ORACLE19C\DB_RECOVE
RY_FILE\ORCL\AUTOBACKUP\CONTRO
L03.CTL

control_management_pack_access string DIAGNOSTIC+TUNING