Description:-
In this is the article we are going to see Multiplexing The Control Files In Oracle 19c RAC/ASM
Step:-1 Before multiplexing the controlfile check the location
SQL> select name from v$controlfile;
NAME
——————————————————————————–
+DATA/ORADBWR/CONTROLFILE/current.261.1027956745
SQL> show parameter control_files
NAME TYPE VALUE
———————————— ———– ——————————
control_files string +DATA/ORADBWR/CONTROLFILE/curr
ent.261.1027956745
Step:-2 Check the diskgroup name for Multiplexing The Control Files
[oracle@rac1 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 40956 38056 0 38056 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 12284 11936 0 11936 0 Y OCR_VOTING/
Step:-3 Change the control_files parameter with diskgroup name OCR_VOTING
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Dec 26 09:51:12 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL> alter system set control_files=’+DATA/ORADBWR/CONTROLFILE/current.261.1027956745′,’+OCR_VOTING’ scope=spfile sid=’*’;
System altered.
Step:-4 Stop the rac database service.
[oracle@rac1 ~]$ srvctl stop database -d oradbwr
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is not running on node rac1
Instance oradbwr2 is not running on node rac2
Step:-5 Start the rac database in nomount state.
[oracle@rac1 ~]$ srvctl start database -d oradbwr -o nomount
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is running on node rac1
Instance oradbwr2 is running on node rac2
Step:-6 Restore controlfile using rman for Multiplexing
[oracle@rac1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Thu Dec 26 09:58:17 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORADBWR (not mounted)
RMAN> restore controlfile from ‘+DATA/ORADBWR/CONTROLFILE/current.261.1027956745’;
Starting restore at 26-DEC-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=62 instance=oradbwr1 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=+DATA/ORADBWR/CONTROLFILE/current.261.1027956745
output file name=+OCR_VOTING/ORADBWR/CONTROLFILE/current.261.1028023133
Finished restore at 26-DEC-19
Step:-7 Stop the rac database service.
[oracle@rac1 ~]$ srvctl stop database -d oradbwr
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is not running on node rac1
Instance oradbwr2 is not running on node rac2
Step:-8 Restart the rac database
[oracle@rac1 ~]$ srvctl start database -d oradbwr
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is running on node rac1
Instance oradbwr2 is running on node rac2
Step:-9 After multiplexing the controlfile check the location
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Dec 26 10:05:28 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL> select name from v$controlfile;
NAME
——————————————————————————–
+DATA/ORADBWR/CONTROLFILE/current.261.1027956745
+OCR_VOTING/ORADBWR/CONTROLFILE/current.261.1028023133
SQL> show parameter control_files
NAME TYPE VALUE
———————————— ———– ——————————
control_files string +DATA/ORADBWR/CONTROLFILE/curr
ent.261.1027956745, +OCR_VOTIN
G/ORADBWR/CONTROLFILE/current.
261.1028023133
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr
