数据库: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