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



Comments

Popular posts from this blog

How to check OS inventory