[grid@sbldcdb01 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 23 17:38:28 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> SET LINE 200
COL NAME FORMAT A30
COL HEADER_STATUS FORMAT A15
COL PATH FORMAT A50
COL TOTAL_MB FORMAT 99999
SELECT NAME,TOTAL_MB, HEADER_STATUS, PATH FROM V$ASM_DISK;SQL> SQL> SQL> SQL> SQL> SQL>
NAME TOTAL_MB HEADER_STATUS PATH
------------------------------ -------- --------------- --------------------------------------------------
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_03
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_04
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_06
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_05
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_04
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_03
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_10
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_09
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_08
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_05
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_06
NAME TOTAL_MB HEADER_STATUS PATH
------------------------------ -------- --------------- --------------------------------------------------
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_07
DB_ORCL_DATA_ASM_01 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_01
DB_ORCL_DATA_ASM_02 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_02
DB_ORCL_FRA_ASM_01 46079 MEMBER ORCL:DB_ORCL_FRA_ASM_01
DB_ORCL_FRA_ASM_02 46079 MEMBER ORCL:DB_ORCL_FRA_ASM_02
DB_ORCL_OCR_01 4095 MEMBER ORCL:DB_ORCL_OCR_01
DB_ORCL_OCR_02 4095 MEMBER ORCL:DB_ORCL_OCR_02
DB_ORCL_OCR_03 4095 MEMBER ORCL:DB_ORCL_OCR_03
DB_ORCL_RMAN_BACKUP_01 46079 MEMBER ORCL:DB_ORCL_RMAN_BACKUP_01
20 rows selected.
SQL> ALTER DISKGROUP DATA ADD DISK 'ORCL:DB_ORCL_DATA_ASM_03';
Diskgroup altered.
SQL> SELECT NAME,TOTAL_MB, HEADER_STATUS, PATH FROM V$ASM_DISK;
NAME TOTAL_MB HEADER_STATUS PATH
------------------------------ -------- --------------- --------------------------------------------------
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_04
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_05
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_06
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_05
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_04
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_03
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_10
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_09
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_08
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_07
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_06
NAME TOTAL_MB HEADER_STATUS PATH
------------------------------ -------- --------------- --------------------------------------------------
DB_ORCL_DATA_ASM_01 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_01
DB_ORCL_DATA_ASM_02 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_02
DB_ORCL_DATA_ASM_03 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_03
DB_ORCL_FRA_ASM_01 46079 MEMBER ORCL:DB_ORCL_FRA_ASM_01
DB_ORCL_FRA_ASM_02 46079 MEMBER ORCL:DB_ORCL_FRA_ASM_02
DB_ORCL_OCR_01 4095 MEMBER ORCL:DB_ORCL_OCR_01
DB_ORCL_OCR_02 4095 MEMBER ORCL:DB_ORCL_OCR_02
DB_ORCL_OCR_03 4095 MEMBER ORCL:DB_ORCL_OCR_03
DB_ORCL_RMAN_BACKUP_01 46079 MEMBER ORCL:DB_ORCL_RMAN_BACKUP_01
20 rows selected.
SQL>
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 23 17:38:28 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> SET LINE 200
COL NAME FORMAT A30
COL HEADER_STATUS FORMAT A15
COL PATH FORMAT A50
COL TOTAL_MB FORMAT 99999
SELECT NAME,TOTAL_MB, HEADER_STATUS, PATH FROM V$ASM_DISK;SQL> SQL> SQL> SQL> SQL> SQL>
NAME TOTAL_MB HEADER_STATUS PATH
------------------------------ -------- --------------- --------------------------------------------------
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_03
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_04
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_06
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_05
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_04
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_03
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_10
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_09
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_08
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_05
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_06
NAME TOTAL_MB HEADER_STATUS PATH
------------------------------ -------- --------------- --------------------------------------------------
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_07
DB_ORCL_DATA_ASM_01 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_01
DB_ORCL_DATA_ASM_02 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_02
DB_ORCL_FRA_ASM_01 46079 MEMBER ORCL:DB_ORCL_FRA_ASM_01
DB_ORCL_FRA_ASM_02 46079 MEMBER ORCL:DB_ORCL_FRA_ASM_02
DB_ORCL_OCR_01 4095 MEMBER ORCL:DB_ORCL_OCR_01
DB_ORCL_OCR_02 4095 MEMBER ORCL:DB_ORCL_OCR_02
DB_ORCL_OCR_03 4095 MEMBER ORCL:DB_ORCL_OCR_03
DB_ORCL_RMAN_BACKUP_01 46079 MEMBER ORCL:DB_ORCL_RMAN_BACKUP_01
20 rows selected.
SQL> ALTER DISKGROUP DATA ADD DISK 'ORCL:DB_ORCL_DATA_ASM_03';
Diskgroup altered.
SQL> SELECT NAME,TOTAL_MB, HEADER_STATUS, PATH FROM V$ASM_DISK;
NAME TOTAL_MB HEADER_STATUS PATH
------------------------------ -------- --------------- --------------------------------------------------
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_04
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_05
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_06
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_05
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_04
0 PROVISIONED ORCL:DB_ORCL_FRA_ASM_03
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_10
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_09
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_08
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_07
0 PROVISIONED ORCL:DB_ORCL_DATA_ASM_06
NAME TOTAL_MB HEADER_STATUS PATH
------------------------------ -------- --------------- --------------------------------------------------
DB_ORCL_DATA_ASM_01 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_01
DB_ORCL_DATA_ASM_02 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_02
DB_ORCL_DATA_ASM_03 46079 MEMBER ORCL:DB_ORCL_DATA_ASM_03
DB_ORCL_FRA_ASM_01 46079 MEMBER ORCL:DB_ORCL_FRA_ASM_01
DB_ORCL_FRA_ASM_02 46079 MEMBER ORCL:DB_ORCL_FRA_ASM_02
DB_ORCL_OCR_01 4095 MEMBER ORCL:DB_ORCL_OCR_01
DB_ORCL_OCR_02 4095 MEMBER ORCL:DB_ORCL_OCR_02
DB_ORCL_OCR_03 4095 MEMBER ORCL:DB_ORCL_OCR_03
DB_ORCL_RMAN_BACKUP_01 46079 MEMBER ORCL:DB_ORCL_RMAN_BACKUP_01
20 rows selected.
SQL>
No comments:
Post a Comment