重庆思庄Oracle、Redhat认证学习论坛

标题: rac环境增加控制文件个数 [打印本页]

作者: denglj 时间: 2022-3-16 09:14
标题: 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 (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、Redhat认证学习论坛 (http://bbs.cqsztech.com/)