Home » Server Options » RAC & Failsafe » ASMDISK DiskGroup Free Space Issue (Oracle 10g + 10.2.0.4 + Windows XP)
ASMDISK DiskGroup Free Space Issue [message #397509] Sat, 11 April 2009 12:50 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

/forum/fa/6017/0/

E:\asmdisk>dir
 Volume in drive E is Oracle
 Volume Serial Number is 944B-F093

 Directory of E:\asmdisk

03/27/2009  12:50 AM    <DIR>          .
03/27/2009  12:50 AM    <DIR>          ..
04/11/2009  01:07 AM     3,145,728,000 disk1
04/11/2009  01:07 AM     4,194,304,000 disk2
04/11/2009  01:07 AM     4,194,304,000 disk3

SQL> select total_mb,free_mb,name from v$asm_diskgroup;

  TOTAL_MB    FREE_MB NAME
---------- ---------- ------------------------------
     11000      10896 DGROUP1


I have created asmdisk using admdisk cmd. While donig database installation I'm getting different free space. (Please find my screen shot) and advice me

Babu
  • Attachment: To OraFAq.JPG
    (Size: 56.50KB, Downloaded 4533 times)
Re: ASMDISK DiskGroup Free Space Issue [message #397523 is a reply to message #397509] Sat, 11 April 2009 17:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>While donig database installation I'm getting different free space.
Did you run this query against the ASM instance or Database?
You are supposed to do it in ASM instance.
set your ORACLE_SID to +ASM and try.
Also crosscheck the output with
 asmcmd lsdg

Unless this is for learning purposes, you must be using external redundancy.
It is also to be noted that there are several bugs related to this.
Re: ASMDISK DiskGroup Free Space Issue [message #397555 is a reply to message #397523] Sun, 12 April 2009 09:26 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
Did you run this query against the ASM instance or Database?
You are supposed to do it in ASM instance.
set your ORACLE_SID to +ASM and try.


Yes. I have only one asm instance.

C:\>set ORACLE_SID=+ASM


C:\>SQLPLUS "/AS SYSDBA"

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 12 19:28:58 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name: SYS AS SYSDBA
Enter password:
Connected to an idle instance.

SQL> STARTUP
ASM instance started

Total System Global Area   79691776 bytes
Fixed Size                  1247396 bytes
Variable Size              53278556 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> select total_mb,free_mb,name from v$asm_diskgroup;

  TOTAL_MB    FREE_MB NAME
---------- ---------- ------------------------------
     11000      10896 DGROUP1

SQL> SHOW PARAMETER INS

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      +asm

SQL> select total_mb,free_mb,path from v$asm_disk;

  TOTAL_MB    FREE_MB
---------- ----------
PATH
--------------------------------------------------------------------------------
      3000       2975
E:\ASMDISK\DISK1

      4000       3972
E:\ASMDISK\DISK2

      4000       3949
E:\ASMDISK\DISK3

SQL>


>>Also crosscheck the output with "ASMCMD"

ASMCMD> lsdg
State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  NORMAL  N      N         512   4096  1048576     11000    10896             4000            3448              0  DGROUP1/

Babu

[Updated on: Sun, 12 April 2009 13:01]

Report message to a moderator

Previous Topic: NAS BOX Requirement for oracle RAC
Next Topic: Verify Standalone database not starting Database
Goto Forum:
  


Current Time: Thu Nov 21 11:40:15 CST 2024