OCI -Shell command

 

 OCI -Shell command 

• Login oci console and select oci cli console 

Oracle Web link : OCI CLI Commands

type: oci cli commands

• OCI CLI command example with jason output:

varunyadav@cloudshell:~ (ap-mumbai-1)$ oci db autonomous-database get --autonomous-database-id ocid1.autonomousdatabase.oc1.ap-mumbai-1.abrg6ljrhpgapdvvqp4azumv5geam6dpw3k7plqbij6ix643jwldsp4353tq

{

  "data": {

    "apex-details": {

      "apex-version": "20.2.0.00.20",

      "ords-version": "20.4.4.068.1249"

    },

    "are-primary-whitelisted-ips-used": null,

    "autonomous-container-database-id": null,

    "available-upgrade-versions": [],

    "backup-config": {

      "manual-backup-bucket-name": null,

      "manual-backup-type": "NONE"

    },

    "compartment-id": "ocid1.tenancy.oc1..aaaaaaaa3lrct7pisw4bc3szl6jubecnxyqfgyfrrc7aapifurbmgw2tjolq",

    "connection-strings": {

      "all-connection-strings": {

        "HIGH": "adb.ap-mumbai-1.oraclecloud.com:1522/s5yv3egc6903wng_orcladb_high.adb.oraclecloud.com",

        "LOW": "adb.ap-mumbai-1.oraclecloud.com:1522/s5yv3egc6903wng_orcladb_low.adb.oraclecloud.com",

        "MEDIUM": "adb.ap-mumbai-1.oraclecloud.com:1522/s5yv3egc6903wng_orcladb_medium.adb.oraclecloud.com",

        "TP": "adb.ap-mumbai-1.oraclecloud.com:1522/s5yv3egc6903wng_orcladb_tp.adb.oraclecloud.com",

        "TPURGENT": "adb.ap-mumbai-1.oraclecloud.com:1522/s5yv3egc6903wng_orcladb_tpurgent.adb.oraclecloud.com"

      },

      "dedicated": null,

      "high": "adb.ap-mumbai-1.oraclecloud.com:1522/s5yv3egc6903wng_orcladb_high.adb.oraclecloud.com",

      "low": "adb.ap-mumbai-1.oraclecloud.com:1522/s5yv3egc6903wng_orcladb_low.adb.oraclecloud.com",

      "medium": "adb.ap-mumbai-1.oraclecloud.com:1522/s5yv3egc6903wng_orcladb_medium.adb.oraclecloud.com"

    },

    "connection-urls": {

      "apex-url": "https://S5YV3EGC6903WNG-ORCLADB.adb.ap-mumbai-1.oraclecloudapps.com/ords/apex",

      "machine-learning-user-management-url": "https://adb.ap-mumbai-1.oraclecloud.com/omlusers/tenants/OCID1.TENANCY.OC1..AAAAAAAA3LRCT7PISW4BC3SZL6JUBECNXYQFGYFRRC7AAPIFURBMGW2TJOLQ/databases/ORCLADB/index.html",

      "sql-dev-web-url": "https://S5YV3EGC6903WNG-ORCLADB.adb.ap-mumbai-1.oraclecloudapps.com/ords/sql-developer"

    },

    "cpu-core-count": 1,

    "data-safe-status": "NOT_REGISTERED",

    "data-storage-size-in-gbs": 20,

    "data-storage-size-in-tbs": 1,

    "db-name": "ORCLADB",

    "db-version": "19c",

    "db-workload": "OLTP",

    "defined-tags": {

      "Oracle-Tags": {

        "CreatedBy": "varunyadav.dba@gmail.com",

        "CreatedOn": "2021-03-22T12:46:35.319Z"

      }

    },

    "display-name": "ORCLADB",

    "failed-data-recovery-in-seconds": null,

    "freeform-tags": {},

    "id": "ocid1.autonomousdatabase.oc1.ap-mumbai-1.abrg6ljrhpgapdvvqp4azumv5geam6dpw3k7plqbij6ix643jwldsp4353tq",

    "infrastructure-type": null,

    "is-access-control-enabled": null,

    "is-auto-scaling-enabled": false,

    "is-data-guard-enabled": false,

    "is-dedicated": false,

    "is-free-tier": true,

    "is-preview": false,

    "is-refreshable-clone": null,

    "key-store-id": null,

    "key-store-wallet-name": null,

    "license-model": "LICENSE_INCLUDED",

    "lifecycle-details": null,

    "lifecycle-state": "AVAILABLE",

    "nsg-ids": null,

    "open-mode": "READ_WRITE",

    "operations-insights-status": "NOT_ENABLED",

    "permission-level": "UNRESTRICTED",

    "private-endpoint": null,

    "private-endpoint-ip": null,

    "private-endpoint-label": null,

    "refreshable-mode": null,

    "refreshable-status": null,

    "role": null,

    "service-console-url": "https://adb.ap-mumbai-1.oraclecloud.com/console/index.html?tenant_name=OCID1.TENANCY.OC1..AAAAAAAA3LRCT7PISW4BC3SZL6JUBECNXYQFGYFRRC7AAPIFURBMGW2TJOLQ&database_name=ORCLADB&service_type=ATP",

    "source-id": null,

    "standby-db": null,

    "standby-whitelisted-ips": null,

    "subnet-id": null,

    "system-tags": {

      "orcl-cloud": {

        "free-tier-retained": "true"

      }

    },

    "time-created": "2021-03-22T12:46:35.322000+00:00",

    "time-deletion-of-free-autonomous-database": null,

    "time-maintenance-begin": "2021-04-17T02:00:00+00:00",

    "time-maintenance-end": "2021-04-17T06:00:00+00:00",

    "time-of-last-failover": null,

    "time-of-last-refresh": null,

    "time-of-last-refresh-point": null,

    "time-of-last-switchover": null,

    "time-of-next-refresh": null,

    "time-reclamation-of-free-autonomous-database": "2021-04-18T13:00:38.257000+00:00",

    "used-data-storage-size-in-tbs": 1,

    "whitelisted-ips": null

  },

  "etag": "53a50687--gzip"

}

varunyadav@cloudshell:~ (ap-mumbai-1)$ 

OCI- Cloud Sql developer connection

 

OCI- Web Sql developer  connection 

• Visit oracle cloud website : https://www.oracle.com/in/cloud/sign-in.html

• Enter Cloud Account Name credential.

• Select dashboard menu 

• Select Autonomous database and choose mentioned database.

• Select Tools options and new window open 

• Login with Admin user and mention the password.

• Select mentioned icon below:

• Execute command on web sql developer.

ASM - Online OCR and Voting Adding on ASM Diskgroup using Normal Redundancy

 ASM -   Online OCR and Voting disk SAN LUN Migration on ASM Diskgroup Normal Redundancy

Once 3 ASM disks are created at OS level using oracleasm utility. We will add to CRS ASM diskgroup online as OCR and voting disk is stored on it.

See also  blog link for details in alert log: ASM - Online OCR and Voting disk SAN LUN Migration on ASM Diskgroup

Redundancy Level: Normal

Grid Version: 12.1.0.2.0

• Create ASM disk of same size using oracleasm utility

[root@srv1 ~]# oracleasm createdisk CRSNEW1 /dev/sdc1

Writing disk header: done

Instantiating disk: done

[root@srv1 ~]# oracleasm createdisk CRSNEW2 /dev/sdd1

Writing disk header: done

Instantiating disk: done

[root@srv1 ~]# oracleasm createdisk CRSNEW3 /dev/sdk1

Writing disk header: done

Instantiating disk: done

[root@srv1 ~]# oracleasm listdisks

CRS1

CRS2

CRS3

CRSNEW

CRSNEW1

CRSNEW2

CRSNEW3

DATANEW

FRANEW

• Login to the ASM instance using grid user and check the current diskgroup status.

[root@srv1 ~]# su grid

[grid@srv1 root]$ cd

[grid@srv1 ~]$ . oraenv

ORACLE_SID = [+ASM1] ?

The Oracle base remains unchanged with value /u01/app/grid

[grid@srv1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 2 17:45:51 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> 

set lines 999;

col diskgroup for a10

col diskname for a12

col path for a30

select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

                                 0          0          0 /dev/oracleasm/disks/CRSNEW    FORMER

                                 0          0          0 /dev/oracleasm/disks/CRSNEW1   PROVISIONED

                                 0          0          0 /dev/oracleasm/disks/CRSNEW3   PROVISIONED

                                 0          0          0 /dev/oracleasm/disks/CRSNEW2   PROVISIONED

CRS        CRS1              12284       1519      10765 /dev/oracleasm/disks/CRS1      MEMBER

CRS        CRS2              12284       1484      10800 /dev/oracleasm/disks/CRS2      MEMBER

CRS        CRS3              12284       1485      10799 /dev/oracleasm/disks/CRS3      MEMBER

DATA       DATA_0001         20473       2476      17997 /dev/oracleasm/disks/DATANEW   MEMBER

FRA        FRA_0001          20473       1075      19398 /dev/oracleasm/disks/FRANEW    MEMBER

9 rows selected.

SQL>  set pages 40000 lines 120

col PATH for a30

select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;

DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    PATH

----------- ------- ------------ ------- -------- ------------------------------

          0 CLOSED  FORMER       ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW

          1 CLOSED  PROVISIONED  ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW1

          2 CLOSED  PROVISIONED  ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW3

          3 CLOSED  PROVISIONED  ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW2

          1 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/FRANEW

          3 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRS3

          1 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/DATANEW

          2 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRS2

          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRS1

9 rows selected.

• Add these provisioned disks in CRS diskgroup 

SQL> ALTER DISKGROUP CRS ADD DISK '/dev/oracleasm/disks/CRSNEW1' NAME CRSNEW1,'/dev/oracleasm/disks/CRSNEW2' NAME CRSNEW2,'/dev/oracleasm/disks/CRSNEW3' NAME CRSNEW3;

Diskgroup altered.

• Check Rebalance operation to complete using below query.

SQL> Select operation, state, est_work, est_minutes from v$asm_operation;

OPERA STAT   EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN        2218           3

REBAL WAIT          0           0

SQL> /

OPERA STAT   EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN        2218           1

REBAL WAIT          0           0

SQL> /

OPERA STAT   EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL DONE       2218           0

REBAL RUN           0           0

SQL> Select operation, state, est_work, est_minutes from v$asm_operation;

OPERA STAT   EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL DONE       2218           0

REBAL RUN           0           0

SQL> /

no rows selected

• Check the status of Diskgroup

SQL> 

set pages 40000 lines 120

col PATH for a30

select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;

DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    PATH

----------- ------- ------------ ------- -------- ------------------------------

          0 CLOSED  FORMER       ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW

          1 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/FRANEW

          3 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRS3

          1 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/DATANEW

          2 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRS2

          5 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW3

          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRS1

          4 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW2

          1 CACHED  MEMBER       ONLINE  NORMAL   /dev/oracleasm/disks/CRSNEW1

9 rows selected.

SQL> 

set lines 999;

col diskgroup for a10

col diskname for a12

 col path for a30

select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;SQL>

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

                                 0          0          0 /dev/oracleasm/disks/CRSNEW    FORMER

CRS        CRS1              12284        778      11506 /dev/oracleasm/disks/CRS1      MEMBER

CRS        CRS2              12284        746      11538 /dev/oracleasm/disks/CRS2      MEMBER

CRS        CRS3              12284        746      11538 /dev/oracleasm/disks/CRS3      MEMBER

CRS        CRSNEW1           12284        743      11541 /dev/oracleasm/disks/CRSNEW1   MEMBER

CRS        CRSNEW2           12284        742      11542 /dev/oracleasm/disks/CRSNEW2   MEMBER

CRS        CRSNEW3           12284        742      11542 /dev/oracleasm/disks/CRSNEW3   MEMBER

DATA       DATA_0001         20473       2476      17997 /dev/oracleasm/disks/DATANEW   MEMBER

FRA        FRA_0001          20473       1075      19398 /dev/oracleasm/disks/FRANEW    MEMBER

9 rows selected.

• Drop old Diskgroup of CRS with disk CRS1,CRS2,CRS3

SQL> alter diskgroup CRS drop disk 'CRS1';

Diskgroup altered.

SQL> alter diskgroup CRS drop disk 'CRS2';

Diskgroup altered.

SQL> alter diskgroup CRS drop disk 'CRS3';

Diskgroup altered.

• Check query to complete rebalance operations.

SQL> Select operation, state, est_work, est_minutes from v$asm_operation;

OPERA STAT   EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN        2177           2

REBAL WAIT          0           0

SQL> Select operation, state, est_work, est_minutes from v$asm_operation;

OPERA STAT   EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN        2177           2

REBAL WAIT          0           0

SQL> /

OPERA STAT   EST_WORK EST_MINUTES

----- ---- ---------- -----------

REBAL RUN        2177           1

REBAL WAIT          0           0

SQL> /

no rows selected

• Check the current status of disk CRS1, CRS2,CRS3

SQL>

 set lines 999;

col diskgroup for a10

col diskname for a12

col path for a30

select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

                                 0          0          0 /dev/oracleasm/disks/CRSNEW    FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS1      FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS3      FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS2      FORMER

CRS        CRSNEW1           12284       1517      10767 /dev/oracleasm/disks/CRSNEW1   MEMBER

CRS        CRSNEW2           12284       1485      10799 /dev/oracleasm/disks/CRSNEW2   MEMBER

CRS        CRSNEW3           12284       1486      10798 /dev/oracleasm/disks/CRSNEW3   MEMBER

DATA       DATA_0001         20473       2476      17997 /dev/oracleasm/disks/DATANEW   MEMBER

FRA        FRA_0001          20473       1075      19398 /dev/oracleasm/disks/FRANEW    MEMBER

9 rows selected.

SQL> /

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

                                 0          0          0 /dev/oracleasm/disks/CRSNEW    FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS1      FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS3      FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS2      FORMER

CRS        CRSNEW1           12284       1517      10767 /dev/oracleasm/disks/CRSNEW1   MEMBER

CRS        CRSNEW2           12284       1485      10799 /dev/oracleasm/disks/CRSNEW2   MEMBER

CRS        CRSNEW3           12284       1486      10798 /dev/oracleasm/disks/CRSNEW3   MEMBER

DATA       DATA_0001         20473       2476      17997 /dev/oracleasm/disks/DATANEW   MEMBER

FRA        FRA_0001          20473       1075      19398 /dev/oracleasm/disks/FRANEW    MEMBER

9 rows selected.

SQL> /

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

                                 0          0          0 /dev/oracleasm/disks/CRSNEW    FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS1      FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS3      FORMER

                                 0          0          0 /dev/oracleasm/disks/CRS2      FORMER

CRS        CRSNEW1           12284       1517      10767 /dev/oracleasm/disks/CRSNEW1   MEMBER

CRS        CRSNEW2           12284       1485      10799 /dev/oracleasm/disks/CRSNEW2   MEMBER

CRS        CRSNEW3           12284       1486      10798 /dev/oracleasm/disks/CRSNEW3   MEMBER

DATA       DATA_0001         20473       2476      17997 /dev/oracleasm/disks/DATANEW   MEMBER

FRA        FRA_0001          20473       1075      19398 /dev/oracleasm/disks/FRANEW    MEMBER

9 rows selected.

• Delete Disk at OS level using oracleasm utility

srv1:/home/grid # oracleasm deletedisk CRS1

Disk "CRS1" defines an unmarked device

Dropping disk: done

srv1:/home/grid # oracleasm deletedisk CRS2

Clearing disk header: done

Dropping disk: done

srv1:/home/grid # oracleasm deletedisk CRS3

Clearing disk header: done

Dropping disk: done

SQL> /

• Check query for current status of ASM Disk group

SQL>

 set lines 999;

col diskgroup for a10

col diskname for a12

col path for a30

select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

                                 0          0          0 /dev/oracleasm/disks/CRSNEW    FORMER

CRS        CRSNEW1           12284       1517      10767 /dev/oracleasm/disks/CRSNEW1   MEMBER

CRS        CRSNEW2           12284       1485      10799 /dev/oracleasm/disks/CRSNEW2   MEMBER

CRS        CRSNEW3           12284       1486      10798 /dev/oracleasm/disks/CRSNEW3   MEMBER

DATA       DATA_0001         20473       2476      17997 /dev/oracleasm/disks/DATANEW   MEMBER

FRA        FRA_0001          20473       1075      19398 /dev/oracleasm/disks/FRANEW    MEMBER

6 rows selected.

############## Another Example of Online ASM disk group migration ###############

SQL> set lines 999;

SQL> col diskgroup for a10

SQL> col diskname for a12

SQL> col path for a30

SQL> select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

                                 0          0          0 ORCL:CRSNEW1                   PROVISIONED

                                 0          0          0 ORCL:CRSNEW2                   PROVISIONED

                                 0          0          0 ORCL:CRSNEW3                   PROVISIONED

BACKUP     BACKUP            15359         96      15263 ORCL:BACKUP                    MEMBER

CRS        CRS1              12287       3047       9240 ORCL:CRS1                      MEMBER

CRS        CRS2              12287       3046       9241 ORCL:CRS2                      MEMBER

CRS        CRS3              12287       3043       9244 ORCL:CRS3                      MEMBER

DATA       DATA              20479       4249      16230 ORCL:DATA                      MEMBER

FRA        FRA               20479        937      19542 ORCL:FRA                       MEMBER

9 rows selected.

SQL> ALTER DISKGROUP CRS ADD DISK 'ORCL:CRSNEW1' NAME CRSNEW1,'ORCL:CRSNEW2' NAME CRSNEW2,'ORCL:CRSNEW3' NAME CRSNEW3;

Diskgroup altered.

SQL> set lines 999;

col diskgroup for a10

SQL> SQL> SQL> SQL> col diskname for a12

col path for a30

SQL> SQL> SQL> SQL> select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

BACKUP     BACKUP            15359         96      15263 ORCL:BACKUP                    MEMBER

CRS        CRS1              12287       3017       9270 ORCL:CRS1                      MEMBER

CRS        CRS2              12287       3014       9273 ORCL:CRS2                      MEMBER

CRS        CRS3              12287       3011       9276 ORCL:CRS3                      MEMBER

CRS        CRSNEW1           12287         34      12253 ORCL:CRSNEW1                   MEMBER

CRS        CRSNEW2           12287         34      12253 ORCL:CRSNEW2                   MEMBER

CRS        CRSNEW3           12287         35      12252 ORCL:CRSNEW3                   MEMBER

DATA       DATA              20479       4249      16230 ORCL:DATA                      MEMBER

FRA        FRA               20479        937      19542 ORCL:FRA                       MEMBER

9 rows selected.

srv1:/home/grid # oracleasm deletedisk CRS1

Disk "CRS1" defines an unmarked device

Dropping disk: done

srv1:/home/grid # oracleasm deletedisk CRS2

Clearing disk header: done

Dropping disk: done

srv1:/home/grid # oracleasm deletedisk CRS3

Clearing disk header: done

Dropping disk: done

srv1:/home/grid # su grid

grid@srv1:~> sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 8 13:16:53 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> set lines 999;

SQL> SQL> col diskgroup for a10

col diskname for a12

SQL> SQL> SQL> SQL> col path for a30

select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where a.group_number (+) =b.group_number order by b.group_number,b.name;

SQL> SQL>

DISKGROUP  DISKNAME       TOTAL_MB    USED_MB    FREE_MB PATH                           HEADER_STATU

---------- ------------ ---------- ---------- ---------- ------------------------------ ------------

BACKUP     BACKUP            15359         96      15263 ORCL:BACKUP                    MEMBER

CRS        CRSNEW1           12287       3045       9242 ORCL:CRSNEW1                   MEMBER

CRS        CRSNEW2           12287       3046       9241 ORCL:CRSNEW2                   MEMBER

CRS        CRSNEW3           12287       3045       9242 ORCL:CRSNEW3                   MEMBER

DATA       DATA              20479       4249      16230 ORCL:DATA                      MEMBER

FRA        FRA               20479        937      19542 ORCL:FRA                       MEMBER

6 rows selected.

SQL>

srv2:~ # oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Cleaning disk "CRS1"

Cleaning disk "CRS2"

Cleaning disk "CRS3"

Scanning system for ASM disks...

srv2:~ # oracleasm listdisks

BACKUP

CRSNEW1

CRSNEW2

CRSNEW3

DATA

FRA

srv2:~ #