https://audiopronews.com/headlines/cz747v1nw O objetivo deste é explicar como multiplexar os controlfiles no ASM em RAC. Este nós vamos utilizar o RMAN para realizar tal operação.
Vamos executar todo procedimento no RAC 1 e deixar o banco de dados no RAC 2 baixado.

https://www.annarosamattei.com/?p=qd76ytbkk Vamos visualizar os controlfiles no ASM em RAC.

http://jannaorganic.co.uk/blog/2025/04/03/x7u2xyx0ni RAC 1

follow site [oracle-DB@rac10g1 ~]$ ps -ef | grep pmon oracle 5385 1 0 20:14 ? 00:00:00 asm_pmon_+ASM1 oracle 5697 1 0 20:15 ? 00:00:00 ora_pmon_racrafa1 oracle 7670 5975 0 20:19 pts/0 00:00:00 grep pmon [oracle-DB@rac10g1 ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 25 20:21:25 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

https://reggaeportugal.com/04jtdtbq

here SQL> conn sys/***** as sysdba Connected. SQL> show parameter control NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string +DGTESTE/racrafa/controlfile/c ontrol02.ctl, +DGDADOS/racrafa /controlfile/current.256.74879 4713 SQL> !

https://aalamsalon.com/j039ete8 Vamos visualizar os discos de grupos disponíveis para a Multiplexação dos Controlfiles.

https://www.villageofhudsonfalls.com/sh9oky0 [oracle-DB@rac10g1 ~]$ export ORACLE_SID=+ASM1 [oracle-DB@rac10g1 ~]$ asmcmd

Buy Soma Generic ASMCMD> lsdg State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name MOUNTED EXTERN N N 512 4096 1048576 2046 167 0 167 0 DGARCH/ MOUNTED EXTERN N N 512 4096 1048576 4092 2354 0 2354 0 DGDADOS/ MOUNTED EXTERN N N 512 4096 1048576 2046 1941 0 1941 0 DGINDEX/ MOUNTED EXTERN N N 512 4096 1048576 3072 2946 0 2946 0 DGTESTE/ ASMCMD> exit

source link Vamos desligar as Instâncias do RAC para realizarmos o procedimento de Multiplexação dos Controlfiles.

https://faroutpodcast.com/d0wttkz [oracle-DB@rac10g1 ~]$ srvctl stop instance -d racrafa -i racrafa1 -o immediate

https://musicboxcle.com/2025/04/6p5jlzd7 RAC 2

here [oracle-DB@rac10g2 ~]$ srvctl stop instance -d racrafa -i racrafa2 -o immediate [oracle-DB@rac10g2 ~]$ ps -ef | grep pmon oracle 5468 1 0 20:14 ? 00:00:00 asm_pmon_+ASM2 oracle 13475 7056 0 20:33 pts/0 00:00:00 grep pmon [oracle-DB@rac10g2 ~]$

https://etxflooring.com/2025/04/sdy1aq6 Vamos iniciar a multiplexação dos controlfiles no RAC 1. Vamos iniciá-lo no estato “nomount” para executar a multiplexação.

go RAC 1

https://colvetmiranda.org/fk4u2eu [oracle-DB@rac10g1 ~]$ srvctl start instance -d racrafa -i racrafa1 -o nomount [oracle-DB@rac10g1 ~]$ exit exit

see url SQL> exit ERROR: ORA-03135: connection lost contact Disconnected from Oracle Database 10g Release 10.2.0.4.0 - Production With the Real Application Clusters option (with complications)

https://www.annarosamattei.com/?p=vtjwqbs2h [oracle-DB@rac10g1 ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 25 20:34:39 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

go to link SQL> conn sys/***** as sysdba Connected. SQL> show parameter control NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string +DGTESTE/racrafa/controlfile/c ontrol02.ctl, +DGDADOS/racrafa /controlfile/current.256.74879 4713 SQL> !

https://lavozdelascostureras.com/kt0f05bv Acessando o RMAN para realizar a Multiplexação do Controlfile.

https://aalamsalon.com/n9ioa86j [oracle-DB@rac10g1 ~]$ rman target ****/***** Recovery Manager: Release 10.2.0.4.0 - Production on Tue Oct 25 20:34:59 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: racrafa (not mounted)

Tramadol Visa Overnight RMAN> restore controlfile to '+DGINDEX/racrafa/controlfile/control03.ctl' from '+DGDADOS/racrafa/controlfile/current.256.748794713'; Starting restore at 25-OCT-11 using channel ORA_DISK_1 channel ORA_DISK_1: copied control file copy Finished restore at 25-OCT-11 RMAN> exit Recovery Manager complete.

https://www.villageofhudsonfalls.com/hda13dtohe [oracle-DB@rac10g1 ~]$ exit exit

see Vamos criar um PFILE do SPFILE corrente por segurança e alterar no SPFILE o parâmetro “control_files”.

https://colvetmiranda.org/60he0q7i SQL> show parameter control NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string +DGTESTE/racrafa/controlfile/c ontrol02.ctl, +DGDADOS/racrafa /controlfile/current.256.74879 4713 SQL> create pfile from spfile; File created. SQL> alter system set control_files='+DGTESTE/racrafa/controlfile/control02.ctl','+DGDADOS/racrafa/controlfile/current.256.748794713','+DGINDEX/racrafa/controlfile/control03.ctl' scope=spfile sid='*'; System altered. SQL> shutdown immediate ORA-01507: database not mounted ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 10g Release 10.2.0.4.0 - Production With the Real Application Clusters option

enter site Vamos iniciar o ambiente RAC.

source site [oracle-DB@rac10g1 ~]$ srvctl start instance -d racrafa -i racrafa1,racrafa2 [oracle-DB@rac10g1 ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 25 20:40:52 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Tramadol Buy Online Uk SQL> conn sys/****** as sysdba Connected. SQL> show parameter control_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string +DGTESTE/racrafa/controlfile/c ontrol02.ctl, +DGDADOS/racrafa /controlfile/current.256.74879 4713, +DGINDEX/racrafa/control file/control03.ctl SQL> show parameter instance_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ instance_name string racrafa1 SQL>

https://semichaschaver.com/2025/04/03/1d0iqfjaqto RAC 2

https://mhco.ca/a7yp9ma [oracle-DB@rac10g2 ~]$ ps -ef | grep pmon oracle 5468 1 0 20:14 ? 00:00:00 asm_pmon_+ASM2 oracle 16270 1 0 20:40 ? 00:00:00 ora_pmon_racrafa2 oracle 16875 7056 0 20:41 pts/0 00:00:00 grep pmon [oracle-DB@rac10g2 ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 25 20:41:20 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

https://www.anonpr.net/iojt755skhr SQL> conn sys/****** as sysdba Connected. SQL> show parameter control_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string +DGTESTE/racrafa/controlfile/c ontrol02.ctl, +DGDADOS/racrafa /controlfile/current.256.74879 4713, +DGINDEX/racrafa/control file/control03.ctl SQL> show parameter instance_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ instance_name string racrafa2 SQL>

click here Pronto seus controlfiles no ASM em RAC foram multiplexados conforme recomendações de segurança da Oracle.

Autor: Maycon Tomiasi

https://audiopronews.com/headlines/62dtub8pi

https://kirkmanandjourdain.com/gqfygxvh Formado em Tecnologia da Informação na FIPP (Faculdade de Informática de Presidente Prudente), Analista DBA Oracle pela Teiko Soluções em Tecnologia da Informação, residente em Blumenau/ SC, Certificado OCP 10g/11g/12c, OCS 11g Implementation, OCE 11g Performance Tuning, OCE 11g RAC & GRID e OPN Specialist. Conhecimentos em PHP.

• 
•