https://marcosgerente.com.br/hkja4pp0ih5 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://ragadamed.com.br/2024/09/18/tsuwsogh Vamos visualizar os controlfiles no ASM em RAC.
https://www.thoughtleaderlife.com/cgw9cd9h59 RAC 1
Buying Diazepam In The Uk [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://boxfanexpo.com/laj0x9d59
source site 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> !
watch Vamos visualizar os discos de grupos disponíveis para a Multiplexação dos Controlfiles.
Buy Valium England [oracle-DB@rac10g1 ~]$ export ORACLE_SID=+ASM1 [oracle-DB@rac10g1 ~]$ asmcmd
click here 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
https://luisfernandocastro.com/1zwtxib5y6 Vamos desligar as Instâncias do RAC para realizarmos o procedimento de Multiplexação dos Controlfiles.
Buy Zepose Diazepam [oracle-DB@rac10g1 ~]$ srvctl stop instance -d racrafa -i racrafa1 -o immediate
https://technocretetrading.com/drkfieu8 RAC 2
https://traffordhistory.org/lookingback/zow1rpebx7 [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://www.modulocapital.com.br/ekee898sbc8 Vamos iniciar a multiplexação dos controlfiles no RAC 1. Vamos iniciá-lo no estato “nomount” para executar a multiplexação.
Buying Diazepam In Mexico RAC 1
https://www.parolacce.org/2024/09/18/9hpvi2j [oracle-DB@rac10g1 ~]$ srvctl start instance -d racrafa -i racrafa1 -o nomount [oracle-DB@rac10g1 ~]$ exit exit
https://vbmotorworld.com/phwkg6ftu 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.drcarolineedwards.com/2024/09/18/0ex2uzsoyku [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.
https://www.thoughtleaderlife.com/k901vgmn5c8 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://livingpraying.com/7hthesmhb2j Acessando o RMAN para realizar a Multiplexação do Controlfile.
enter site [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)
see 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://ragadamed.com.br/2024/09/18/uqrpf44199a [oracle-DB@rac10g1 ~]$ exit exit
https://boxfanexpo.com/24ssz31a Vamos criar um PFILE do SPFILE corrente por segurança e alterar no SPFILE o parâmetro “control_files”.
follow url 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
https://technocretetrading.com/ili7nzmfhig Vamos iniciar o ambiente RAC.
Buy Diazepam In Bulk [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.
go to site 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>
enter RAC 2
https://trevabrandonscharf.com/2hw5h5am4gx [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.
enter site 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>
https://traffordhistory.org/lookingback/35gse4i Pronto seus controlfiles no ASM em RAC foram multiplexados conforme recomendações de segurança da Oracle.
Autor: Maycon Tomiasi
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.
