Boa tarde,

   Faça o scan dos discos pela asmlib e depois monte eles no node2.


Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: oracle_br@yahoogrupos.com.br <oracle_br@yahoogrupos.com.br> on behalf of 
Carlos Eduardo carloseduard...@yahoo.com [oracle_br] 
<oracle_br@yahoogrupos.com.br>
Sent: Saturday, April 15, 2017 7:22:28 PM
To: Yahoo! Brazil
Subject: [oracle_br] Problema com ASM Instance



Cenário:

ORACLE RAC 12.1
dois nós
OEL 6.5
GRID Instalado
DATABASE INstalado
Porém, o database ainda não existe.

DISKGROUP CONFIG
DISK01
DISK02
DISK03

DISKGROUP DATA
DISK04
DISK05

DISKGROUP FRA
DISK06
DISK07


Na hora da criação do database, foi indicado que iria faltar espaço em disco 
nos dois diskgroups, pelo motivo que eram apenas de 2GB cada, o que eu foi 
adicionar mais 4 discos, o DISK08 e 09 para o DATA e o DISK 10 e 11 para o FRA
=======
DISK08
DISK09
DISK10
DISK11
=======

RAC 2

ALTER DISKGROUP DATA DISMOUNT;
ALTER DISKGROUP FRA DISMOUNT;

RAC 1

DROP DISKGROUP DATA INCLUDING CONTENTS;
DROP DISKGROUP FRA INCLUDING CONTENTS;

CREATE DISKGROUP DATA NORMAL REDUNDANCY DISK 'ORCL:DISK08', 'ORCL:DISK09';
CREATE DISKGROUP DATA NORMAL REDUNDANCY DISK 'ORCL:DISK10', 'ORCL:DISK11';


ASMDISK MOUNT_S STATE  PATH   HEADER_STATU DISKGROUP
---------------- ------- -------- ---------------------------------------- 
------------ -------------------------
DISK01 CACHED  NORMAL   ORCL:DISK01   MEMBER CONFIG
DISK02 CACHED  NORMAL   ORCL:DISK02   MEMBER CONFIG
DISK03 CACHED  NORMAL   ORCL:DISK03   MEMBER CONFIG
DISK08 CACHED  NORMAL   ORCL:DISK08   MEMBER DATA
DISK09 CACHED  NORMAL   ORCL:DISK09   MEMBER DATA
DISK10 CACHED  NORMAL   ORCL:DISK10   MEMBER FRA
DISK11 CACHED  NORMAL   ORCL:DISK11   MEMBER FRA


É justamente essa configuração que tem que está, porém no RAC2 ficou 
desconfigurado, como posso fazer para corrigir esse problema?

ASMDISK MOUNT_S STATE  PATH   HEADER_STATU DISKGROUP
---------------- ------- -------- ---------------------------------------- 
------------ --------------------
CLOSED  NORMAL   ORCL:DISK07   FORMER FRA
CLOSED  NORMAL   ORCL:DISK07   FORMER DATA
CLOSED  NORMAL   ORCL:DISK06   FORMER FRA
CLOSED  NORMAL   ORCL:DISK06   FORMER DATA
CLOSED  NORMAL   ORCL:DISK11   MEMBER FRA
CLOSED  NORMAL   ORCL:DISK11   MEMBER DATA
CLOSED  NORMAL   ORCL:DISK08   MEMBER FRA
CLOSED  NORMAL   ORCL:DISK08   MEMBER DATA
CLOSED  NORMAL   ORCL:DISK09   MEMBER FRA
CLOSED  NORMAL   ORCL:DISK09   MEMBER DATA
CLOSED  NORMAL   ORCL:DISK10   MEMBER FRA
CLOSED  NORMAL   ORCL:DISK10   MEMBER DATA
CLOSED  NORMAL   ORCL:DISK05   FORMER FRA
CLOSED  NORMAL   ORCL:DISK05   FORMER DATA
CLOSED  NORMAL   ORCL:DISK04   FORMER FRA
CLOSED  NORMAL   ORCL:DISK04   FORMER DATA
DISK02 CACHED  NORMAL   ORCL:DISK02   MEMBER CONFIG
DISK01 CACHED  NORMAL   ORCL:DISK01   MEMBER CONFIG
DISK03 CACHED  NORMAL   ORCL:DISK03   MEMBER CONFIG


COmo seria o procedimento correto para evitar esse tipo de problema no meu RAC?


  • [oracle_br] Problema ... Carlos Eduardo carloseduard...@yahoo.com [oracle_br]
    • Re: [oracle_br] ... Rodrigo Mufalani rodr...@mufalani.com.br [oracle_br]

Responder a