{"id":9234,"date":"2019-02-08T08:32:03","date_gmt":"2019-02-08T08:32:03","guid":{"rendered":"https:\/\/dbtut.com\/?p=9234"},"modified":"2019-02-08T08:37:40","modified_gmt":"2019-02-08T08:37:40","slug":"oracle-automatic-storage-management-2","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/","title":{"rendered":"Oracle Automatic Storage Management -2"},"content":{"rendered":"

In this article I will continue to explain Oracle Automatic Storage Management. Before reading this article, I suggest you read the previous article. “Oracle Automatic Storage Management -1<\/a>”<\/p>\n

\"\"<\/p>\n

When the Oracle ASM is used, the concept of Disk group enters our lives. As the name implies, we store our data in Disk Groups where one or more disks come together instead of a single disk.<\/p>\n

As mentioned in the previous article, the ASM instance is different from the Oracle Database instances. When we query the smon process as follows, “+ ASM” instance is listed as an instance.<\/p>\n

oracle:deveci01:\/home\/users\/oracle:>ps -ef |grep smon\n\nroot 11731186 1 18 10:05:48 - 0:00 \/u01\/app\/oracle\/product\/12.1.0\/grid\/bin\/osysmond.bin\noracle 12058826 1 0 10:06:56 - 0:00 ora_smon_DEVECI\noracle 12976246 1 0 10:06:24 - 0:00 asm_smon_+ASM\noracle 38338572 28049424 1 10:07:02 pts\/0 0:00 grep smon<\/pre>\n
To connect to ASM Instances we create an ASM Instance profile:<\/strong><\/p>\n
oracle:deveci01:\/home\/users\/oracle:> vi profile.12g.asm\n\nexport ORACLE_HOME=\/u01\/app\/oracle\/product\/12.1.0\/grid\nexport ORACLE_BASE=\/u01\/app\/oracle\nexport PATH=$ORACLE_HOME\/bin:$ORACLE_HOME\/OPatch:$PATH\nexport ORACLE_SID=+ASM\nbash<\/pre>\n
After creating as above, we can set the profile as follows and we can now connect to ASM:<\/strong><\/p>\n
oracle:deveci01:\/home\/users\/oracle:>. profile.12c.asm<\/pre>\n
asmcmd<\/strong> is a tool that we perform and monitor many disk operations.<\/p>\n
We can connect and see disk groups and sizes, free spaces etc with LSDG as follows:<\/strong><\/p>\n
oracle:deveci:\/home\/users\/oracle:>asmcmd\nASMCMD> lsdg\nState   Type   Rebal Sector Block AU      Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name\nMOUNTED EXTERN N     512    4096  1048576 512000   510551  0               510551         0             N            DATA\/\nMOUNTED EXTERN N     512    4096  4194304 204800   203272  0               203272         0             Y            RECO\/\nASMCMD>\n\nASMCMD> cd DATA\nASMCMD> ls -l\nType Redund Striped Time Sys Name\nY DEVECI\/<\/pre>\n
We can also connect to ASM instances with “sqlplus \/ as sysasm<\/code>” command and perform similar operations with queries.<\/p>\n
You can add and remove disks to the ASM disk groups as follows.<\/p>\n
First set the ASM profile:<\/strong><\/p>\n
oracle:deveci01:\/home\/users\/oracle:>. profile.12c.asm<\/pre>\n
Then we are connecting to the ASM Instance with the command “sqlplus \/ as sysasm”.<\/p>\n
Run the following query to see disk groups in here:<\/p>\n
SQL> SELECT GROUP_NUMBER, NAME,SECTOR_SIZE,BLOCK_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE TOTAL_MB,FREE_MB FROM V$ASM_DISKGROUP;\n\n\nGROUP_NUMBER NAME     SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE       TOTAL_   FREE_MB\n\n------------ -------- ----------- ---------- -------------------- ----------- ------   ----------\n\n1            DATA     512         4096       1048576              CONNECTED   EXTERN   355915\n\n2            RECO     512         4096       1048576              CONNECTED   EXTERN   721067<\/pre>\n
If an ASM Disk has been mapped to the operating system(this is a storage-side operation.), they will appear in the following query. HEADER_STATUS = CANDIDATE are disks that could not be added.<\/p>\n
Disks with HEADER_STATUS value CANDIDATE are disks that are not mapped to the operating system.<\/p>\n
SQL> SELECT MOUNT_STATUS, HEADER_STATUS, MODE_STATUS, STATE, TOTAL_MB, FREE_MB, NAME, PATH, LABEL FROM V$ASM_DISK;\n\n\nMOUNT_S HEADER_STATU MODE_ST STATE    TOTAL_MB   FREE_MB    NAME        PATH          LABEL\n\n------- ------------ ------- -------- ---------- ---------- ----------- --------      ----------\n\nCLOSED CANDIDATE     ONLINE   NORMAL  0          0                      \/dev\/rhdisk38\n\nCLOSED CANDIDATE     ONLINE   NORMAL  0          0                      \/dev\/rhdisk39\n\nCLOSED CANDIDATE     ONLINE   NORMAL  0          0                      \/dev\/rhdisk40\n\nCACHED MEMBER        ONLINE   NORMAL   102399    17756      DATA_0000   \/dev\/rhdisk10\n\nCACHED MEMBER        ONLINE   NORMAL   102399    17795      DATA_0001   \/dev\/rhdisk11\n\nCACHED MEMBER        ONLINE   NORMAL   102399    17787      DATA_0002   \/dev\/rhdisk12<\/pre>\n
If you re-create a diskgroup you can use the following commands:<\/strong><\/p>\n
CREATE DISKGROUP RECO EXTERNAL REDUNDANCY DISK \u2018\/dev\/mapper\/asmtsk1\u2019 NAME RECO_0001 SIZE 102399 M;\n\nALTER DISKGROUP RECO REBALANCE POWER 10;<\/pre>\n
ALTER DISKGROUP RECO ADD DISK \u2018\/dev\/mapper\/asmtsk2\u2019 NAME RECO_0002 SIZE 102399 M REBALANCE POWER 10;\n\nALTER DISKGROUP RECO ADD DISK '\/dev\/mapper\/asmtsk3' NAME RECO_0003 SIZE 102399 M REBALANCE POWER 10;\n\nALTER DISKGROUP RECO ADD DISK '\/dev\/mapper\/asmtsk4' NAME RECO_0004 SIZE 102399 M REBALANCE POWER 10;\n\nALTER DISKGROUP RECO ADD DISK '\/dev\/mapper\/asmtsk5' NAME RECO_0005 SIZE 102399 M REBALANCE POWER 10;\n<\/pre>\n
If we created a new diskgroup on a 2-node RAC system, we should not forget to mount the diskgroup on the second node.<\/p>\n
SQL> select INST_ID,GROUP_NUMBER,NAME,STATE from GV$ASM_DISKGROUP;\n\n\nINST_ID    GROUP_NUMBER  NAME    STATE\n\n---------- ------------ -------  -------\n\n1          1            DATA MOUNTED\n\n1          2            RECO MOUNTED\n\n2          1            DATA MOUNTED\n\n2          0            RECO DISMOUNTED\n\nSQL> alter diskgroup RECO mount;\n\nDiskgroup altered.\n\n\nSQL> select INST_ID,GROUP_NUMBER,NAME,STATE from GV$ASM_DISKGROUP;\n\n\nINST_ID    GROUP_NUMBER  NAME   STATE\n\n---------- ------------ ------  -----------\n\n1          1            DATA    MOUNTED\n\n1          2            RECO    MOUNTED\n\n2          1            DATA    MOUNTED\n\n2          2            RECO    MOUNTED<\/pre>\n
Add the \/dev\/rhdisk12 disk to the RECO disk group:<\/strong><\/p>\n
SQL> ALTER DISKGROUP RECO ADD DISK '\/dev\/rhdisk38' NAME RECO_0010 SIZE 102399 M REBALANCE POWER 10;\n\nDiskgroup altered.<\/pre>\n
We give the parallelism value of the rebalance operation and increase the speed of REBALANCE with the POWER parameter.<\/p>\n
Set to 10 on busy systems can decrease performance in your databases.<\/p>\n
If this parameter is not given, it takes the value of the ASM_POWER_LIMIT parameter by default.. ASM_POWER_LIMIT can take values from 0-11. The rebalance status can be monitored from the V$ASM_OPERATION<\/code> view.<\/p>\n
If this parameter is not given, it takes the value of the ASM_POWER_LIMIT parameter by default.<\/p>\n
SQL> show parameter ASM_POWER_LIMIT\n\nNAME            TYPE    VALUE\n\n--------        ------- --------\nasm_power_limit integer 1\n\nSQL> select * from v$asm_operation;<\/pre>\n
Apart from ASMCMD and sqlplus, you can also see disk groups and add and remove disk with asmca.<\/p>\n
Add a disk with asmca:<\/strong><\/p>\n
\"\"<\/p>\n
A disk in the ASM disk group can be dropped as follows:<\/strong><\/p>\n
SQL> SELECT name, header_status, path FROM V$ASM_DISK;\n\nNAME\u00a0 \u00a0 \u00a0 \u00a0 HEADER_STATU   PATH\n\n-----------\u00a0-------------- ----------\n\nFORMER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk18\n\nFORMER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk15\n\nFORMER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk16\n\nFORMER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk17\n\nDATA_0000 MEMBER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk10\n\nDATA_0001 MEMBER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk11\n\nDATA_0002 MEMBER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk12\n\nDATA_0003 MEMBER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk13\n\nDATA_0004 MEMBER\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/dev\/rhdisk14<\/pre>\n
SQL> alter diskgroup DATA drop disk DATA_0004;\nDiskgroup altered.<\/pre>\n
The value of header_status in the dropped disk will be former.\n\nSQL> SELECT name, header_status, path FROM V$ASM_DISK;\n\n\nNAME\u00a0 \u00a0 \u00a0 \u00a0 HEADER_STATU   PATH \n-----------\u00a0-------------- ----------\nFORMER                     \/dev\/rhdisk18\n\nFORMER                     \/dev\/rhdisk14\n\nFORMER                     \/dev\/rhdisk15\n\nFORMER                     \/dev\/rhdisk16\n\nFORMER                     \/dev\/rhdisk17\n\nDATA_0000 MEMBER           \/dev\/rhdisk10\n\nDATA_0001 MEMBER           \/dev\/rhdisk11\n\nDATA_0002 MEMBER           \/dev\/rhdisk12\n\nDATA_0003 MEMBER           \/dev\/rhdisk13<\/pre>\n
If the RAC is a database, all nodes should be checked and the same status should be seen in other nodes.<\/p>\n
Drop a disk with asmca:<\/strong><\/p>\n
\"\"<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In this article I will continue to explain Oracle Automatic Storage Management. Before reading this article, I suggest you read the previous article. “Oracle Automatic Storage Management -1” When the Oracle ASM is used, the concept of Disk group enters our lives. As the name implies, we store our data in Disk Groups where one …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":472,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[1958,1951,1963,1959,1953,1962,1960,1952,1955,1957,1961,1954,1956],"class_list":["post-9234","post","type-post","status-publish","format-standard","","category-oracle","tag-add-a-disk-to-disgroup","tag-add-a-disk-with-asmca","tag-asm","tag-asm_power_limit","tag-asmca","tag-asmcmd","tag-connect-to-asm-instance","tag-drop-a-disk-with-asmca","tag-drop-disk-from-diskgroup","tag-list-asm-disks","tag-lsdg","tag-remove-disk-from-diskgroup","tag-vasm_disk"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":281,"today_views":0},"yoast_head":"\nOracle Automatic Storage Management -2 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle Automatic Storage Management -2\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Automatic Storage Management -2 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle Automatic Storage Management -2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-08T08:32:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-08T08:37:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png\" \/>\n<meta name=\"author\" content=\"Mehmet Salih DEVEC\u0130\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mehmet Salih DEVEC\u0130\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/\"},\"author\":{\"name\":\"Mehmet Salih DEVEC\u0130\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa\"},\"headline\":\"Oracle Automatic Storage Management -2\",\"datePublished\":\"2019-02-08T08:32:03+00:00\",\"dateModified\":\"2019-02-08T08:37:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/\"},\"wordCount\":455,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png\",\"keywords\":[\"add a disk to disgroup\",\"add a disk with asmca\",\"ASM\",\"ASM_POWER_LIMIT\",\"asmca\",\"asmcmd\",\"connect to asm instance\",\"drop a disk with asmca\",\"drop disk from diskgroup\",\"list asm disks\",\"lsdg\",\"Remove disk from diskgroup\",\"V$ASM_DISK\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/\",\"name\":\"Oracle Automatic Storage Management -2 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png\",\"datePublished\":\"2019-02-08T08:32:03+00:00\",\"dateModified\":\"2019-02-08T08:37:40+00:00\",\"description\":\"Oracle Automatic Storage Management -2\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png\",\"width\":635,\"height\":355},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Automatic Storage Management -2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa\",\"name\":\"Mehmet Salih DEVEC\u0130\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g\",\"caption\":\"Mehmet Salih DEVEC\u0130\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/salihdeveci\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Automatic Storage Management -2 - Database Tutorials","description":"Oracle Automatic Storage Management -2","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Automatic Storage Management -2 - Database Tutorials","og_description":"Oracle Automatic Storage Management -2","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-08T08:32:03+00:00","article_modified_time":"2019-02-08T08:37:40+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png","type":"","width":"","height":""}],"author":"Mehmet Salih DEVEC\u0130","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mehmet Salih DEVEC\u0130","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/"},"author":{"name":"Mehmet Salih DEVEC\u0130","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa"},"headline":"Oracle Automatic Storage Management -2","datePublished":"2019-02-08T08:32:03+00:00","dateModified":"2019-02-08T08:37:40+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/"},"wordCount":455,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png","keywords":["add a disk to disgroup","add a disk with asmca","ASM","ASM_POWER_LIMIT","asmca","asmcmd","connect to asm instance","drop a disk with asmca","drop disk from diskgroup","list asm disks","lsdg","Remove disk from diskgroup","V$ASM_DISK"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/","name":"Oracle Automatic Storage Management -2 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png","datePublished":"2019-02-08T08:32:03+00:00","dateModified":"2019-02-08T08:37:40+00:00","description":"Oracle Automatic Storage Management -2","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5c144dc90f5.png","width":635,"height":355},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/oracle-automatic-storage-management-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Automatic Storage Management -2"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa","name":"Mehmet Salih DEVEC\u0130","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g","caption":"Mehmet Salih DEVEC\u0130"},"url":"https:\/\/dbtut.com\/index.php\/author\/salihdeveci\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/472"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9234"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9234\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}