{"id":524,"date":"2015-11-04T08:22:10","date_gmt":"2015-11-04T08:22:10","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=524"},"modified":"2015-11-04T08:22:10","modified_gmt":"2015-11-04T08:22:10","slug":"oracle-fail-safer-%ea%b5%ac%ec%b6%95-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=524","title":{"rendered":"Oracle Fail Safer \uad6c\ucd95 \ubc29\ubc95"},"content":{"rendered":"
    \n
  1. \n
    node1,2\uc5d0 MSCS\uad6c\uc131,\ud074\ub7ec\uc2a4\ud130\ub9c1
    \n<\/span><\/div>\n<\/li>\n
  2. \n
    node1,2\uc5d0 \uac01\uac01 \uc624\ub77c\ud074 \uc5d4\uc9c4 \uc124\uce58
    \n<\/span><\/div>\n<\/li>\n
  3. \n
    node1\uc5d0\uc11c\ub9cc \uc778\uc2a4\ud134\uc2a4 \uc0dd\uc131
    \n<\/span><\/div>\n<\/li>\n
  4. \n
    node1,2\uc5d0 \uac01\uac01 OFS\uc778\uc2a4\ud1a8\ud6c4 \uc7ac\ubd80\ud305
    \n<\/span><\/div>\n<\/li>\n
  5. \n
    ofs maanger\ub97c \uc2e4\ud589\ud558\uc5ec MSCS\ud074\ub7ec\uc2a4\ud130 \ub4f1\ub85d
    \n<\/strong><\/span><\/div>\n<\/li>\n<\/ol>\n


    \n\t\t<\/span><\/p>\n

    \ud074\ub7ec\uc2a4\ud130\uc5d0 \uc5f0\uacb0
    \n<\/span><\/p>\n


    \n\t\t<\/span><\/p>\n

    \ub4f1\ub85d\ud558\uae30\uc704\ud574\uc11c username,password,domain\uc744 \uc785\ub825\ud55c\ub2e4
    \n<\/span><\/p>\n


    \n\t\t<\/span><\/p>\n

    \ud074\ub7ec\uc2a4\ud130 \ud558\ub4dc\uc6e8\uc5b4,\uc18c\ud504\ud2b8\uc6e8\uc5b4\uac00 \uc81c\ub300\ub85c \uad6c\uc131\ub418\uc5c8\ub294\uc9c0 Verify Cluster\ub97c \uc774\uc6a9\ud558\uc5ec \ud655\uc778\ud55c\ub2e4.(\ucc98\uc74c\uc811\uc18d\uc2dc \uae30\ubcf8\uc801\uc73c\ub85c \ucc3d\uc774 \ub72c\ub2e4)
    \n<\/span><\/p>\n


    \n\t\t<\/span><\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    Verifying \uacfc\uc815\uc744 \ubcfc\uc218\uc788\ub2e4.
    \n<\/span><\/p>\n


    \n\t\t<\/span><\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    6.\uadf8\ub8f9\uc0dd\uc131
    \n<\/strong><\/span><\/p>\n

      \n
    • \n
      ofs\uac00 \uc11c\ube44\uc2a4\ub294 \ud55c \uadf8\ub8f9\ub2e8\uc704\ub85c \ub418\ub294\ub370 \uadf8 \uadf8\ub8f9\uc548\uc5d0 \ud544\uc218\ub4f1\ub85dresouce\uac00 5(shared storage,vitual ip,database,listener,network name)\uac1c\uc774\ub2e4 \uba3c\uc800 \uadf8\ub8f9\uc744 \uc0dd\uc131\ud55c\ub2e4.
      \n<\/span><\/div>\n<\/li>\n<\/ul>\n

      \uba54\ub274\uc758 group – create\uc120\ud0dd
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      \uadf8\ub8f9\uc774\ub984 \uc815\uc758
      \n<\/span><\/p>\n

      \n <\/p>\n


      \n\t\t<\/span><\/p>\n

      Failback policy\uc778\ub370 fail-over\ub418\uace0 \uc5bc\ub9c8\ub4a4\uc5d0 failback\ud560\uac83\uc778\uc9c0 \uc124\uc815\ud558\ub294\ucc3d\uc774\ub2e4
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      Failback\uc2dc \ub3cc\uc544\uc62c preferred node\ub97c \uc9c0\uc815\ud55c\ub2e4.
      \n<\/span><\/p>\n

      Preferred node\ub97c \uc9c0\uc815\ud574\uc8fc\uc9c0 \uc54a\uc73c\uba74 failback\uc740 \ub418\uc9c0\uc54a\ub294\ub2e4.
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \uc624\ucf00\ub97c \ub20c\ub7ec \uc9c4\ud589
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \uadf8\ub8f9\uc774 \uc0dd\uc131\ub418\uba74 vutual IP\ub97c \uc0dd\uc131\ud560\uac83\uc778\uc9c0 \ubb3b\ub294\ub2e4.Yes\ub85c \uc9c4\ud589
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \ud6c4\uc5d0 \ub4f1\ub85d\ud558\ub824\uba74 Resource- Add to group \uc744 \ub20c\ub7ec\uc11c \uc9c4\ud589
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      Virtual address \uc120\ud0dd
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n


      \n\t\t<\/span><\/p>\n

      Vitual ip\ub97c \ub4f1\ub85d\ud558\uba74\uc11c virtual\ub124\ud2b8\uc6cd\ub124\uc784\ub3c4 \uc124\uc815\ud574\uc8fc\uc5b4\uc57c\ud55c\ub2e4.
      \n<\/span><\/p>\n

      Hostname\uc774 virtual network name\uc774 \ub418\uace0
      \n<\/span><\/p>\n

      IP Address\uac00 virtual ip\uac00 \ub41c\ub2e4.
      \n<\/span><\/p>\n

      (\ud638\uc2a4\ud2b8 \ub124\uc784\uc744 \uc785\ub825\ud558\uba74 \uc790\ub3d9\uc73c\ub85c vip\uac00 \uc7a1\ud78c\ub2e4\ub358\ub370.
      \n<\/span><\/p>\n

      Vip\uc640 network name\ub4f1\ub85d\uacfc\uc815\uc744 MSCS\uc5d0\uc11c \uc190\uc27d\uac8c\uc791\uc5c5\uc744 \ud558\uc5ec \uc774\ubd80\ubd84\uc740 \uba85\ud655\uce58\uac00 \uc54a\uc74c.,\uc790\ub3d9\uc73c\ub85c \uc7a1\ud788\uac8c \ud558\uae30 \uc704\ud574\uc120 hosts\ud30c\uc77c\uc5d0 \ucd94\uac00\ub97c \ud574\uc8fc\uc5b4\uc57c \ub418\uc9c0 \uc54a\uc744\uae4c\uc0dd\uac01\ub41c\ub2e4)
      \n<\/span><\/p>\n

      (MSCS\uc5d0\uc11c\uc758 \uc808\ucc28\ub294 \ube44\uc2b7\ud55c \uc778\ud130\ud398\uc774\uc2a4\uc778\ub370 \uadf8\ub8f9\uc744 \uc0dd\uc131\ud558\uace0 vip resource\ub97c \uc0dd\uc131\ud558\uace0 networkname resource\ub97c \uc0dd\uc131\ud558\uc5ec \uc885\uc18d\uc131\uc73c\ub85c vip\ub97c \ucd94\uac00\ud574\uc900\ub2e4.)
      \n<\/span><\/p>\n

      Show network accessible by client\uc120\ud0dd
      \n<\/span><\/p>\n

      Network\ub294 Public\uc120\ud0dd
      \n<\/span><\/p>\n

      \n <\/p>\n

      \uc644\ub8cc\ud654\uba74
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      7.\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucd94\uac00
      \n<\/strong><\/span><\/p>\n

      \uae30\uc874 \uc0dd\uc131\ub418\uc5b4\uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c OFS\uad6c\ud604\uc744 \uc704\ud574 OFSmanager\uc5d0 \ucd94\uac00\ud574\uc900\ub2e4
      \n<\/span><\/p>\n

      Troubleshooting-Verify Standalone database \ub97c \ud074\ub9ad
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      Dialog\ubc15\uc2a4\ub97c \ucc44\uc6b4\ub2e4(Use this account\ub97c \ud074\ub9ad\ud558\uc5ec sys\/sys_password\ub97c \uc774\uc6a9\ud574\ub3c4\ubb34\ubc29)
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      DATABASE verify
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      Resource- add to group\ub97c \uc120\ud0dd\ud574\uc11c Verify\ub41c DATABASE\ub97c \ub4f1\ub85d\ud55c\ub2e4
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      Oracle database \uc120\ud0dd (group name\uc740 database\ub97c \ucd94\uac00\ud560\uadf8\ub8f9)
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

          
      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      Database \uad00\ub828 \uc815\ubcf4\ub97c \uc785\ub825\ud574\uc900\ub2e4.
      \n<\/span><\/p>\n

      Parameter File\uc740 pfile\uc758 \uacbd\ub85c\ub97c \uc9c0\uc815\ud574\uc900\ub2e4.
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \uc778\uc99d\ubaa8\ub4dc\ub97c \uc120\ud0dd\ud558\ub294 \uacfc\uc815 ( \ub3d9\uc11c\uc5d0\uc11c\ub294 Use SYS Account\ub85c \uc124\uc815\ud568)
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      Password file \uc0dd\uc131
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      Ok
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      \uc9c4\ud589\uc911 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc815\uc9c0\ub418\uc5c8\ub2e4\uac00 \uc2dc\uc791\ub428\uc744 \uc54c\ub9ac\ub294 \uba54\uc2dc\uc9c0\uac00 \ub72c\ub2e4
      \n<\/span><\/p>\n

      YES \ud074\ub9ad
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \uc9c4\ud589\ub418\ub294 \uc911\uc5d0 node1\uc5d0\uc11c \uc0dd\uc131\ud55c instace\uc815\ubcf4\ub97c node2\uc5d0 \uc790\ub3d9\uc73c\ub85c \ub118\uaca8\uc900\ub2e4.(oradim\uc744\uc774\uc6a9\ud558\uc5ec \uc218\ub3d9 \ub4f1\ub85d\ud560 \ud544\uc694 \uc5c6\uc74c), \uc774\ub54c, virtualIP\ub85c listener.ora\uac00 \uc0dd\uc131\ub418\uba70 tnsnames.ora\ub3c4 \uc0dd\uc131\uc774\ub41c\ub2e4.
      \n<\/span><\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uadf8\ub8f9\uc744 Verify\ud55c\ub2e4.
      \n<\/span><\/p>\n

      \uc774\ub54c 5\uac1c\uc758 RESOURCE\uac00 \ucd94\uac00\ub41c \uac83\uc744 \ubcfc\uc218\uc788\ub2e4
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      Ok
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      \n <\/p>\n

      Node2\ub85c group\ub97c \uc62e\uae30\uace0 \uc2f6\ub2e4\uba74 (fail-over) <\/span>\uadf8\ub8f9\uc5d0 \ub9c8\uc6b0\uc2a4\ub97c \ub300\uace0 \uc624\ub978\ucabd\uc744 \ud074\ub9ad\uc544\ud600 Move to a Different Node\ub97c \uc120\ud0dd\ud55c\ub2e4.
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      Ok
      \n<\/span><\/p>\n


      \n\t\t<\/span><\/p>\n

      database\uc678\uc5d0\ub3c4 form servers,reports servers, oracle HTTP servers\ub4e4\ub3c4 OFS\uc5d0 \ucd94\uac00\ud558\uc5ec \uc11c\ube44\uc2a4\ud560\uc218\uc788\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      node1,2\uc5d0 MSCS\uad6c\uc131,\ud074\ub7ec\uc2a4\ud130\ub9c1 node1,2\uc5d0 \uac01\uac01 \uc624\ub77c\ud074 \uc5d4\uc9c4 \uc124\uce58 node1\uc5d0\uc11c\ub9cc \uc778\uc2a4\ud134\uc2a4 \uc0dd\uc131 node1,2\uc5d0 \uac01\uac01 OFS\uc778\uc2a4\ud1a8\ud6c4 \uc7ac\ubd80\ud305 ofs maanger\ub97c \uc2e4\ud589\ud558\uc5ec MSCS\ud074\ub7ec\uc2a4\ud130 \ub4f1\ub85d \ud074\ub7ec\uc2a4\ud130\uc5d0 \uc5f0\uacb0 \ub4f1\ub85d\ud558\uae30\uc704\ud574\uc11c username,password,domain\uc744 \uc785\ub825\ud55c\ub2e4 \ud074\ub7ec\uc2a4\ud130 \ud558\ub4dc\uc6e8\uc5b4,\uc18c\ud504\ud2b8\uc6e8\uc5b4\uac00 \uc81c\ub300\ub85c \uad6c\uc131\ub418\uc5c8\ub294\uc9c0 Verify Cluster\ub97c \uc774\uc6a9\ud558\uc5ec \ud655\uc778\ud55c\ub2e4.(\ucc98\uc74c\uc811\uc18d\uc2dc \uae30\ubcf8\uc801\uc73c\ub85c \ucc3d\uc774 \ub72c\ub2e4)     Verifying \uacfc\uc815\uc744 \ubcfc\uc218\uc788\ub2e4.                               […]<\/p>\n","protected":false},"author":1,"featured_media":525,"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":[21],"tags":[275,276,71,277,278],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.227D7C445639C02F1F30F6.png?fit=498%2C494","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/524"}],"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=524"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/524\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/525"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=524"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}