{"id":320,"date":"2015-03-11T01:38:55","date_gmt":"2015-03-11T01:38:55","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=320"},"modified":"2015-03-11T01:38:55","modified_gmt":"2015-03-11T01:38:55","slug":"exadata-diskrepairtime-%ec%a1%b0%ed%9a%8c-%eb%b0%8f-%eb%b3%80%ea%b2%bd","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=320","title":{"rendered":"Exadata DISK_REPAIR_TIME \uc870\ud68c \ubc0f \ubcc0\uacbd"},"content":{"rendered":"<p><span style=\"font-family: Dotum, \ub3cb\uc6c0;\">1. DISK_REPAIR_TIME \ud30c\ub77c\ubbf8\ud130 \uc870\ud68c<\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">select name,value<br \/>\nfrom v$asm_attribute where group_number=1 and name not like &#8216;template%&#8217;;<\/span><\/span><\/p>\n<p ><span  style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0; color: rgb(31, 73, 125);\">&nbsp;<\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\nVALUE<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">idp.type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\ndynamic<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">idp.boundary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\nauto<\/span><\/span><\/p>\n<p ><b><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:red\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">disk_repair_time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n3.6h<\/span><\/span><\/b><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">phys_meta_replicated&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\ntrue<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">failgroup_repair_time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n24.0h<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">thin_provisioned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\nFALSE<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">content.type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\ndata<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">content.check&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\nFALSE<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">au_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n1048576<\/span><\/span><\/p>\n<p><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\"><\/p>\n<p><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><span style=\"font-size: 9pt; font-family: Dotum, \ub3cb\uc6c0;\">sector_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n&nbsp;&nbsp;512<\/span><\/span><\/p>\n<p ><span  style=\"font-size:10.0pt;font-family:&quot;\ub9d1\uc740 \uace0\ub515&quot;;color:#1F497D\"><br \/><\/span><\/p>\n<p ><font color=\"#1f497d\" face=\"\ub9d1\uc740 \uace0\ub515\"><span style=\"font-size: 13.3333330154419px; line-height: 20px; font-family: Dotum, \ub3cb\uc6c0;\">Default \uac12\uc740 3.6h<\/span><\/font><\/p>\n<p ><font color=\"#1f497d\" face=\"\ub9d1\uc740 \uace0\ub515\"><span style=\"font-size: 13.3333330154419px; line-height: 20px;\"><br \/><\/span><\/font><\/p>\n<p ><font color=\"#1f497d\" face=\"\ub9d1\uc740 \uace0\ub515\"><span style=\"font-size: 13.3333330154419px; line-height: 20px; font-family: Dotum, \ub3cb\uc6c0;\">2. \ud30c\ub77c\ubbf8\ud130 \ubcc0\uacbd \ubc29\ubc95<\/span><\/font><\/p>\n<p ><span style=\"font-family: Dotum, \ub3cb\uc6c0;\">ALTER DISKGROUP dgroupA SET ATTRIBUTE \u201eDISK_REPAIR_TIME\u201f = &#8220;5H&#8221;;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. DISK_REPAIR_TIME \ud30c\ub77c\ubbf8\ud130 \uc870\ud68c select name,value from v$asm_attribute where group_number=1 and name not like &#8216;template%&#8217;; &nbsp; NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; idp.type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dynamic idp.boundary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; auto disk_repair_time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.6h phys_meta_replicated&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; true failgroup_repair_time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24.0h thin_provisioned&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FALSE content.type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data content.check&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FALSE au_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1048576 sector_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;512 Default \uac12\uc740 3.6h 2. \ud30c\ub77c\ubbf8\ud130 \ubcc0\uacbd \ubc29\ubc95 ALTER DISKGROUP dgroupA SET ATTRIBUTE \u201eDISK_REPAIR_TIME\u201f = &#8220;5H&#8221;;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[25],"tags":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/320"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=320"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}