环境: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 (c) 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 |
重庆思庄oracle技术分享-rac环境增加控制文件个数
最新推荐文章于 2023-11-13 19:06:04 发布