重庆思庄oracle技术分享-rac环境增加控制文件个数

环境：rac
节点1执行：
SQL> show parameter control

NAME TYPE VALUE

---

control_file_record_keep_time integer 7
control_files string +DATA/ORCL/CONTROLFILE/current
.261.1099351569
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> alter system set control_files=’+DATA/ORCL/CONTROLFILE/current.261.1099351569’,’+OCR/ORCL/CONTROLFILE/control01.ctl’ scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 3640654064 bytes
Fixed Size 8902896 bytes
Variable Size 771751936 bytes
Database Buffers 2852126720 bytes
Redo Buffers 7872512 bytes
SQL> show parameter control

NAME TYPE VALUE

---

control_file_record_keep_time integer 7
control_files string +DATA/ORCL/CONTROLFILE/current
.261.1099351569, +OCR/ORCL/CON
TROLFILE/control01.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
节点2执行：
shutdown immediate
节点1执行：
[oracle@hisdb1:/home/oracle]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Mar 15 22:24:35 2022
Version 19.3.0.0.0

Copyright © 1982, 2019, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (not mounted)

RMAN> restore controlfile from ‘+DATA/ORCL/CONTROLFILE/current.261.1099351569’;

Starting restore at 15-MAR-22
using channel ORA_DISK_1

channel ORA_DISK_1: copied control file copy
output file name=+DATA/ORCL/CONTROLFILE/current.261.1099351569
output file name=+OCR/ORCL/CONTROLFILE/control01.ctl
Finished restore at 15-MAR-22

RMAN> alter database mount;

released channel: ORA_DISK_1
Statement processed

RMAN> alter database open;

Statement processed

RMAN> select name from v$controlfile;
NAME

+DATA/ORCL/CONTROLFILE/current.261.1099351569
+OCR/ORCL/CONTROLFILE/control01.ctl