Re: [oracle_br] Diskgroup Exhausted

2015-07-20 Por tôpico juliano ribeiro julianonoiz...@yahoo.com.br [oracle_br] 
Boa tarde,

Eu já passei por uma situação que diria ser parecida.

Da uma lida no doc abaixo e vê se te ajuda:


*ASM External Redundancy Diskgroups Present Large Imbalance
(V$ASM_DISK.FREE_MB) In 11.2 or 12.1 Releases (Doc ID 1980292.1)*
Boa sorte,

Att.

Juliano Ribeiro


2015-07-20 16:40 GMT-03:00 Rafael Mendonca raffaell.t...@yahoo.com
[oracle_br] :

>
>
> Nos mostra o resultado dessa consulta por favor:
>
> SET LINESIZE  145
> SET PAGESIZE  
> SET VERIFYoff
> COLUMN group_name FORMAT a20   HEAD 'Disk Group|Name'
> COLUMN sector_sizeFORMAT 99,999HEAD 'Sector|Size'
> COLUMN block_size FORMAT 99,999HEAD 'Block|Size'
> COLUMN allocation_unit_size   FORMAT 999,999,999   HEAD 'Allocation|Unit
> Size'
> COLUMN state  FORMAT a11   HEAD 'State'
> COLUMN type   FORMAT a6HEAD 'Type'
> COLUMN total_mb   FORMAT 999,999,999   HEAD 'Total Size (MB)'
> COLUMN used_mbFORMAT 999,999,999   HEAD 'Used Size (MB)'
> COLUMN pct_used   FORMAT 999.99HEAD 'Pct. Used'
>
> break on report on disk_group_name skip 1
>
> compute sum label "Grand Total: " of total_mb used_mb on report
>
> set heading off
> select 'Instancia: [ '||instance_name||' ]' from v$instance;
> set heading on
>
> SELECT
> name group_name
>   , sector_size  sector_size
>   , block_size   block_size
>   , allocation_unit_size allocation_unit_size
>   , statestate
>   , type type
>   , total_mb total_mb
>   , (total_mb - free_mb) used_mb
>   , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used
> FROM
> v$asm_diskgroup
> ORDER BY
> name
> /
>
>
>
>
>
>   Em Segunda-feira, 20 de Julho de 2015 16:32, "
> palomacbarb...@yahoo.com.br [oracle_br]" 
> escreveu:
>
>
>
>  Boa tarde!
>
> Oracle standard 11.2.0.4
> Linux RedHat 5.7
>
>
> Temos atualmente um pouco mais de 20Gb disponível no diskgroup DGDADOS,
> porém não consigo utilizar nem 100MB .
> Me retorna o erro informando que não tem espaço suficiente no diskgroup:
>
> ORA-15041: diskgroup "DGDADOS" space exhausted
>
>
>
> Desde já agradeço.
> Paloma Barbosa
>
>
>
>   
>

Re: [oracle_br] Diskgroup Exhausted

2015-07-20 Por tôpico Rafael Mendonca raffaell.t...@yahoo.com [oracle_br] 
Nos mostra o resultado dessa consulta por favor:
SET LINESIZE  145
SET PAGESIZE  
SET VERIFY    off
COLUMN group_name FORMAT a20   HEAD 'Disk Group|Name'
COLUMN sector_size    FORMAT 99,999    HEAD 'Sector|Size'
COLUMN block_size FORMAT 99,999    HEAD 'Block|Size'
COLUMN allocation_unit_size   FORMAT 999,999,999   HEAD 'Allocation|Unit Size'
COLUMN state  FORMAT a11   HEAD 'State'
COLUMN type   FORMAT a6    HEAD 'Type'
COLUMN total_mb   FORMAT 999,999,999   HEAD 'Total Size (MB)'
COLUMN used_mb    FORMAT 999,999,999   HEAD 'Used Size (MB)'
COLUMN pct_used   FORMAT 999.99    HEAD 'Pct. Used'

break on report on disk_group_name skip 1

compute sum label "Grand Total: " of total_mb used_mb on report

set heading off
select 'Instancia: [ '||instance_name||' ]' from v$instance;
set heading on

SELECT
    name group_name
  , sector_size  sector_size
  , block_size   block_size
  , allocation_unit_size allocation_unit_size
  , state    state
  , type type
  , total_mb total_mb
  , (total_mb - free_mb) used_mb
  , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used
FROM
    v$asm_diskgroup
ORDER BY
    name
/

 


 Em Segunda-feira, 20 de Julho de 2015 16:32, "palomacbarb...@yahoo.com.br 
[oracle_br]"  escreveu:
   

     Boa tarde!
Oracle standard 11.2.0.4Linux RedHat 5.7

Temos atualmente um pouco mais de 20Gb disponível no diskgroup DGDADOS, porém 
não consigo utilizar nem 100MB .Me retorna o erro informando que não tem espaço 
suficiente no diskgroup:
ORA-15041: diskgroup "DGDADOS" space exhausted



Desde já agradeço.Paloma Barbosa
  #yiv0918559304 #yiv0918559304 -- #yiv0918559304ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0918559304 
#yiv0918559304ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0918559304 
#yiv0918559304ygrp-mkp #yiv0918559304hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0918559304 #yiv0918559304ygrp-mkp #yiv0918559304ads 
{margin-bottom:10px;}#yiv0918559304 #yiv0918559304ygrp-mkp .yiv0918559304ad 
{padding:0 0;}#yiv0918559304 #yiv0918559304ygrp-mkp .yiv0918559304ad p 
{margin:0;}#yiv0918559304 #yiv0918559304ygrp-mkp .yiv0918559304ad a 
{color:#ff;text-decoration:none;}#yiv0918559304 #yiv0918559304ygrp-sponsor 
#yiv0918559304ygrp-lc {font-family:Arial;}#yiv0918559304 
#yiv0918559304ygrp-sponsor #yiv0918559304ygrp-lc #yiv0918559304hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0918559304 
#yiv0918559304ygrp-sponsor #yiv0918559304ygrp-lc .yiv0918559304ad 
{margin-bottom:10px;padding:0 0;}#yiv0918559304 #yiv0918559304actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0918559304 
#yiv0918559304activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0918559304
 #yiv0918559304activity span {font-weight:700;}#yiv0918559304 
#yiv0918559304activity span:first-child 
{text-transform:uppercase;}#yiv0918559304 #yiv0918559304activity span a 
{color:#5085b6;text-decoration:none;}#yiv0918559304 #yiv0918559304activity span 
span {color:#ff7900;}#yiv0918559304 #yiv0918559304activity span 
.yiv0918559304underline {text-decoration:underline;}#yiv0918559304 
.yiv0918559304attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0918559304 .yiv0918559304attach div a 
{text-decoration:none;}#yiv0918559304 .yiv0918559304attach img 
{border:none;padding-right:5px;}#yiv0918559304 .yiv0918559304attach label 
{display:block;margin-bottom:5px;}#yiv0918559304 .yiv0918559304attach label a 
{text-decoration:none;}#yiv0918559304 blockquote {margin:0 0 0 
4px;}#yiv0918559304 .yiv0918559304bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0918559304 
.yiv0918559304bold a {text-decoration:none;}#yiv0918559304 dd.yiv0918559304last 
p a {font-family:Verdana;font-weight:700;}#yiv0918559304 dd.yiv0918559304last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0918559304 
dd.yiv0918559304last p span.yiv0918559304yshortcuts 
{margin-right:0;}#yiv0918559304 div.yiv0918559304attach-table div div a 
{text-decoration:none;}#yiv0918559304 div.yiv0918559304attach-table 
{width:400px;}#yiv0918559304 div.yiv0918559304file-title a, #yiv0918559304 
div.yiv0918559304file-title a:active, #yiv0918559304 
div.yiv0918559304file-title a:hover, #yiv0918559304 div.yiv0918559304file-title 
a:visited {text-decoration:none;}#yiv0918559304 div.yiv0918559304photo-title a, 
#yiv0918559304 div.yiv0918559304photo-title a:active, #yiv0918559304 
div.yiv0918559304photo-title a:hover, #yiv0918559304 
div.yiv0918559304photo-title a:visited {text-decoration:no

Re: [oracle_br] Diskgroup Exhausted

2015-07-20 Por tôpico Rodrigo Mufalani rodr...@mufalani.com.br [oracle_br] 
Boa tarde,

   Já tentou fazer um rebalance neste DG? Olhou também dentro do dg pelo asmcmd?

[ ]'s
#mufalani

   Desculpe por erros! Este e-mail foi escrito do meu smartphone!

Sorry for typos! This mail was written from my smartphone!!!

> Em 20/07/2015, às 16:32, palomacbarb...@yahoo.com.br [oracle_br] 
>  escreveu:
> 
> Boa tarde!
> 
> 
> Oracle standard 11.2.0.4
> Linux RedHat 5.7
> 
> 
> Temos atualmente um pouco mais de 20Gb disponível no diskgroup DGDADOS, porém 
> não consigo utilizar nem 100MB .
> Me retorna o erro informando que não tem espaço suficiente no diskgroup:
> 
> ORA-15041: diskgroup "DGDADOS" space exhausted
> 
> 
> 
> Desde já agradeço.
> Paloma Barbosa
> 
>

Re: [oracle_br] Diskgroup Exhausted

2015-07-20 Por tôpico Vitor Junior vitorj...@gmail.com [oracle_br] 
Execute:

alter diskgroup DGDADOS check all repair;

E depois verifique novamente o 'real' espaço disponível.



Em seg, 20 de jul de 2015 às 16:32, palomacbarb...@yahoo.com.br [oracle_br]
 escreveu:

>
>
> Boa tarde!
>
> Oracle standard 11.2.0.4
> Linux RedHat 5.7
>
>
> Temos atualmente um pouco mais de 20Gb disponível no diskgroup DGDADOS,
> porém não consigo utilizar nem 100MB .
> Me retorna o erro informando que não tem espaço suficiente no diskgroup:
>
> ORA-15041: diskgroup "DGDADOS" space exhausted
>
>
>
> Desde já agradeço.
> Paloma Barbosa
>
>  
>
-- 
Att,/Regards,


Vitor Jr.
Infraestrutura / Infrastructure Team

Oracle 12c DBA Certified Professional - OCP 12c
Oracle 11g DBA Certified Professional - OCP 11g
Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid
Infrastructure Administrator - OCE
Oracle Database 11g Performance Tuning Certified Expert - OCE
Oracle Exadata 11g Certified Implementation Specialist
Oracle Certified Associate, MySQL 5
mail, gtalk e msn: vitorj...@gmail.com
http://certificacaobd.com.br/
skype: vjunior1981
https://mybizcard.co/vitor.jr.385628