[oracle@ora-prod cleandb]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Oct 27 11:22:10 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
scripts-1
SQL> SELECT name, free_mb, total_mb, total_mb-free_mb "USED_MB", free_mb/total_mb*100 "%FREE" FROM v$asm_diskgroup;
NAME FREE_MB TOTAL_MB USED_MB %FREE
------------------------------ ---------- ---------- ---------- ----------
DATA 376496 1048576 672080 35.9054565
RECO 258856 262144 3288 98.7457275
scripts-2
SQL> SELECT name, free_mb, total_mb, total_mb-free_mb "USED_MB" FROM v$asm_diskgroup;
NAME FREE_MB TOTAL_MB USED_MB
------------------------------ ---------- ---------- ----------
DATA 376496 1048576 672080
RECO 258856 262144 3288
[grid@ora-prod ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Oct 27 11:19:43 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set lines 150
SQL> column path format a40
SQL> column name format a30
SQL> select name,path,mount_status,header_status,mode_status,state,total_mb,free_mb from v$asm_disk order by 2;
NAME PATH MOUNT_S HEADER_STATU MODE_ST STATE TOTAL_MB FREE_MB
------------------------------ ---------------------------------------- ------- ------------ ------- -------- ---------- ----------
DATA_0004 /dev/DATADISK5 CACHED MEMBER ONLINE NORMAL 262144 94092
DATA_0005 /dev/DATADISK6 CACHED MEMBER ONLINE NORMAL 262144 94156
DATA_0006 /dev/DATADISK7 CACHED MEMBER ONLINE NORMAL 262144 94132
DATA_0007 /dev/DATADISK8 CACHED MEMBER ONLINE NORMAL 262144 94116
RECODISK1 /dev/RECODISK1 CACHED MEMBER ONLINE NORMAL 65536 64720
RECODISK2 /dev/RECODISK2 CACHED MEMBER ONLINE NORMAL 65536 64704
RECODISK3 /dev/RECODISK3 CACHED MEMBER ONLINE NORMAL 65536 64716
RECODISK4 /dev/RECODISK4 CACHED MEMBER ONLINE NORMAL 65536 64716
8 rows selected.
SQL> select name,path, group_number group_#, disk_number disk_#, mount_status,header_status, state, total_mb, free_mb from v$asm_disk order by group_number;
NAME PATH GROUP_# DISK_# MOUNT_S HEADER_STATU STATE TOTAL_MB FREE_MB
------------------------------ ---------------------------------------- ---------- ---------- ------- ------------ -------- ---------- ----------
DATA_0005 /dev/DATADISK6 1 5 CACHED MEMBER NORMAL 262144 94156
DATA_0006 /dev/DATADISK7 1 6 CACHED MEMBER NORMAL 262144 94132
DATA_0004 /dev/DATADISK5 1 4 CACHED MEMBER NORMAL 262144 94092
DATA_0007 /dev/DATADISK8 1 7 CACHED MEMBER NORMAL 262144 94116
RECODISK1 /dev/RECODISK1 2 0 CACHED MEMBER NORMAL 65536 64720
RECODISK3 /dev/RECODISK3 2 2 CACHED MEMBER NORMAL 65536 64716
RECODISK2 /dev/RECODISK2 2 1 CACHED MEMBER NORMAL 65536 64704
RECODISK4 /dev/RECODISK4 2 3 CACHED MEMBER NORMAL 65536 64716
8 rows selected.
SQL>
ASM diskgroup number and file number for your redo logs.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+RECO/prod_ora/ONLINELOG/group_3.259.968631061
+RECO/prod_ora/ONLINELOG/group_2.258.968631059
+RECO/prod_ora/ONLINELOG/group_1.257.968631059
SQL>
No comments:
Post a Comment