addition of asm disk group .
7738417766 ..
ALTER DATABASE OPEN READ ONLY;
dba
lsblk
8:0 0 50G 0 disk
âsdq1 65:1 0 50G 0 part
sdr 65:16 0 50G 0 disk
ââsdr1 65:17 0 50G 0 part ---->
[root@xxxxxx_09~]# oracleasm createdisk ORADATA14 /dev/sdr1
Writing disk header: done
Instantiating disk: done
[root@xxxxxx_09~]#
[root@xxxxxx_09~]#
[root@xxxxxx_09~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@xxxxxx_09~]# oracleasm listdisks
ARCHIVE2
OCR2
ORADATA10
ORADATA11
ORADATA12
ORADATA13
ORADATA14
ORADATA2
ORADATA3
ORADATA4
ORADATA5
ORADATA6
ORADATA7
ORADATA8
ORADATA9
[root@xxxxxx_09~]# su - grid
[grid@xxxxxx_09~]$
[grid@xxxxxx_09~]$ sqlplus '/as sysasm'
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 19 19:09:25 2018
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 Automatic Storage Management option
SQL>
SQL>
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
ARCHIVE 511993 6593
OCR 10239 10180
ORADATA 6815703 6332
SQL> alter diskgroup ORADATA add disk 'ORCL:ORADATA14' rebalance power 11;
Diskgroup altered.
SQL> SQL> SQL> SQL>
SQL> SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
3 REBAL RUN 11 11 1549 75544 8151
9
SQL> /
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
3 REBAL RUN 11 11 3644 75544 8748
8
7738417766 ..
ALTER DATABASE OPEN READ ONLY;
dba
lsblk
8:0 0 50G 0 disk
âsdq1 65:1 0 50G 0 part
sdr 65:16 0 50G 0 disk
ââsdr1 65:17 0 50G 0 part ---->
[root@xxxxxx_09~]# oracleasm createdisk ORADATA14 /dev/sdr1
Writing disk header: done
Instantiating disk: done
[root@xxxxxx_09~]#
[root@xxxxxx_09~]#
[root@xxxxxx_09~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@xxxxxx_09~]# oracleasm listdisks
ARCHIVE2
OCR2
ORADATA10
ORADATA11
ORADATA12
ORADATA13
ORADATA14
ORADATA2
ORADATA3
ORADATA4
ORADATA5
ORADATA6
ORADATA7
ORADATA8
ORADATA9
[root@xxxxxx_09~]# su - grid
[grid@xxxxxx_09~]$
[grid@xxxxxx_09~]$ sqlplus '/as sysasm'
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 19 19:09:25 2018
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 Automatic Storage Management option
SQL>
SQL>
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
ARCHIVE 511993 6593
OCR 10239 10180
ORADATA 6815703 6332
SQL> alter diskgroup ORADATA add disk 'ORCL:ORADATA14' rebalance power 11;
Diskgroup altered.
SQL> SQL> SQL> SQL>
SQL> SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
3 REBAL RUN 11 11 1549 75544 8151
9
SQL> /
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
3 REBAL RUN 11 11 3644 75544 8748
8
Comments
Post a Comment