To Find Asm Disk Group Details
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View To Find Asm Disk Group Details as PDF for free.
More details
- Words: 70
- Pages: 1
To find ASM disk group details: Source the environment before use the following statements. SQL> select GROUP_NUMBER,NAME,PATH from v$asm_disk; GROUP_NUMBER NAME ------------ --------------------------------------------------------------------1 ARC_DISK_01 2 DG1_DATA_02 2 DG2_DATA_01 2 DG1_DATA_01 2 DG2_DATA_02 3 RG1_REDO_01 3 RG2_REDO_01
PATH /rawdev/ASM_ARC_D01 /rawdev/ASM_DG1_R10_D02 /rawdev/ASM_DG2_R05_D01 /rawdev/ASM_DG1_R10_D01 /rawdev/ASM_DG2_R05_D02 /rawdev/ASM_RG1_R10_D01 /rawdev/ASM_RG2_R05_D01
7 rows selected. SQL> select name,total_mb,free_mb from v$asm_diskgroup; GROUP_NUMBER -----------1 2 3
NAME TOTAL_MB FREE_MB ------------------------------ ---------- ---------ARCH 289781 289145 DATA 2047936 2043093 REDO 682976 682627
PATH /rawdev/ASM_ARC_D01 /rawdev/ASM_DG1_R10_D02 /rawdev/ASM_DG2_R05_D01 /rawdev/ASM_DG1_R10_D01 /rawdev/ASM_DG2_R05_D02 /rawdev/ASM_RG1_R10_D01 /rawdev/ASM_RG2_R05_D01
7 rows selected. SQL> select name,total_mb,free_mb from v$asm_diskgroup; GROUP_NUMBER -----------1 2 3
NAME TOTAL_MB FREE_MB ------------------------------ ---------- ---------ARCH 289781 289145 DATA 2047936 2043093 REDO 682976 682627
Related Documents
To Find Asm Disk Group Details
June 2020 1
Managing Asm Disk Groups Linux
May 2020 8
Adding Dropping Disks From A Asm Disk Group
May 2020 2
Asm
July 2020 9
Asm
August 2019 27