ASMDISK DiskGroup Free Space Issue [message #397509] |
Sat, 11 April 2009 12:50 |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
|
|
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
|
|
|
|
Re: ASMDISK DiskGroup Free Space Issue [message #397555 is a reply to message #397523] |
Sun, 12 April 2009 09:26 |
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
|
|
|