数据库:19.3.0.0
系统:CentOS 7.9
环境:单实例+GI
SQL> show parameter control_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA/ORCLCDB/CONTROLFILE/curr
ent.261.1089511797, +FRA/ORCLC
DB/CONTROLFILE/current.256.108
9511797
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 4949277288 bytes
Fixed Size 9144936 bytes
Variable Size 956301312 bytes
Database Buffers 3976200192 bytes
Redo Buffers 7630848 bytes
RMAN> restore controlfile to '+DATA' from '+FRA/ORCLCDB/CONTROLFILE/current.256.1089511797';
[grid@dbserver ~]$ asmcmd -p
ASMCMD [+data/orclcdb/controlfile] > ls
Current.261.1089511797
current.309.1094084007
SQL> alter system set control_files='+DATA/ORCLCDB/CONTROLFILE/current.261.1089511797','+FRA/ORCLCDB/CONTROLFILE/current.256.1089511797','+DATA/ORCLCDB/CONTROLFILE/current.309.1094084007' scope=spfile sid='*';
System altered.
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4949277288 bytes
Fixed Size 9144936 bytes
Variable Size 956301312 bytes
Database Buffers 3976200192 bytes
Redo Buffers 7630848 bytes
Database mounted.
Database opened.
SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA/ORCLCDB/CONTROLFILE/curr
ent.261.1089511797, +FRA/ORCLC
DB/CONTROLFILE/current.256.108
9511797, +DATA/ORCLCDB/CONTROL
FILE/current.309.1094084007