ORACLE – DBA \ub97c \ubaa9\ud45c\ub85c \ud558\uc600\uc744 \ub54c<\/p>\n
=== \ud544\uc218 \uc9c0\uc2dd ==================================
\nSQL, PL\/SQL, DB ADMIN, BACKUP AND RECOVERY (RMAN), TUNING,
\n\uc11c\ubc84\uc6a9 OS \ub450\uac00\uc9c0.<\/p>\n
SQL, PL\/SQL :
\n\ub2e8\uc21c\ud788 \uc0ac\uc6a9\ud560 \uc904 \uc548\ub2e4\ub77c\ub294 \uc218\uc900\ubcf4\ub2e4\ub294 \uac80\ud1a0 \ubc0f, \uc5b4\ub290\uc815\ub3c4\uc758 \ud29c\ub2dd\uae4c\uc9c0\ub3c4
\n\uac00\ub2a5\ud574\uc57c \ud569\ub2c8\ub2e4. \uc5b4\ub514\uc758 \uacfc\uc815\uc744 \ub4e4\uc73c\uc2dc\uc9c0\ub294 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4\ub9cc,
\n\uc77c\ub2e8 9i-DBA \uacfc\uc815\uc758 \ub9f9\uc810\uc774 PL\/SQL\uc758 \ubd80\uc7ac\uc785\ub2c8\ub2e4. \uae30\uc874 8i\uacfc\uc815\uc5d0\ub294
\n\ub4e4\uc5b4\uc788\ub2e4\uace0 9i-DEV\ub85c \ubd84\ub9ac\uc2dc\ud0a4\uba74\uc11c DBA\uacfc\uc815\uc5d0\ub294 \uc81c\uc678\uac00 \ub418\uc5c8\ub294\ub370
\nDBA\uc5d0\uac8c\ub610\ud55c \ud544\uc218\uc801\uc778 \uc9c0\uc2dd\uc785\ub2c8\ub2e4.<\/p>\n
DB ADMIN :
\nDB ADMIN \ub300\ud574 \uad73\uc774 \uc124\uba85\ud560 \ud544\uc694\ub294 \uc5c6\ub2e4\uace0 \ubd05\ub2c8\ub2e4.
\n\ub2e4\ub9cc DB ADMIN\uc744 \ud655\uc2e4\ud788 \ud558\uc9c0 \uc54a\uc73c\uba74 BACKUP\uc774\ub098 TUNING\uc5d0\uc11c\uc758
\n\uc804\uba78\uc774 \ubcf4\uc7a5\ub41c\ub2e4\ub294 \uac83\ub9cc \ub9d0\uc500\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
BACKUP AND RECOVERY (RMAN):
\n\uc544\ubb34\ub3c4 \uc54c\uc544\uc8fc\uc9c0\ub294 \uc54a\uc9c0\ub9cc DBA\uac00 \ucd5c\uc6b0\uc120\uc801\uc73c\ub85c \uc798 \ud574\uc57c\ub9cc \ud558\ub294
\nBACKUP\uc785\ub2c8\ub2e4. \ub2e8\uc9c0 “\uc774\ub7f0 \uc0c1\ud669\uc5d0\uc11c\ub294 \ud560 \uc904 \uc548\ub2e4”\ub77c\ub294 \uc218\uc900\uc774 \uc544\ub2cc
\n“\uc5b4\ub5a0\ud55c \uc0c1\ud669\uc5d0\uc11c\ub3c4 \ub2f9\uc5f0\ud788 \ud560 \uc904 \uc548\ub2e4”\ub77c\ub294 \uc218\uc900\uc774 \ub418\uc5b4\uc57c\ub9cc \ud569\ub2c8\ub2e4.
\n\ud55c\uac00\uc9c0 \uc774\uc0c1\ud55c \uc810\uc740 \uacf5\uc778 \uad50\uc7ac\ub098 \uc2dc\uc911\uc5d0\uc11c\uc758 \uad00\ub828 \uc11c\uc801\ub4e4\uc740
\nUSER-MANAGED\uc5d0\ub9cc \uce58\uc911\uc774 \ub418\uc5b4 \uc788\ub294\ub370 \uc2e4\uc81c \ub9c8\ucf13\uc758 \ud750\ub984\uc740
\n\ubaa8\ub4e0 \uba74\uc5d0\uc11c \uc6d4\ub4f1\ud788 \uc6b0\uc218\ud55c RECOVERY MANAGER\uc785\ub2c8\ub2e4.
\n\ubd80\ub2f4\uc2a4\ub7ec\uc6b0\uc2dc\uaca0\uc9c0\ub9cc ORACLE PRESS\uc5d0\uc11c \ub098\uc628 RMAN\uad00\ub828 \uc11c\uc801
\n– \uc6d0\uc11c -\ub97c \ud544\ud788 \ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. \uc815\ub9ac\ubc0f \ub0b4\uc6a9\uc774 \uc54c\ucc28
\n\ud6d7\ub0a0 \ub808\ud37c\ub7f0\uc2a4 \uc6a9\uc73c\ub85c \uc4f0\uae30\uc5d0\ub3c4 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
TUNING:
\n\uc2e4\uc740 \uc774 TUNING\uc744 \ud544\uc218\ub85c \ub123\uc5b4\uc57c \ud558\ub098 \uc120\ud0dd\uc73c\ub85c \ub123\uc5b4\ud590 \ud558\ub098
\n\ud558\uace0 \ub9dd\uc124\uc600\uc2b5\ub2c8\ub2e4. \uc790\uaca9\uc99d \ucde8\ub4dd\uc744 \uc704\ud574\uc11c\ub294 \ud544\uc218\uc801\uc774\ub098
\nDB ADMIN\uc5d0 \ub300\ud55c \uae4a\uc774 \uc788\ub294 \uc9c0\uc2dd\uacfc \uc5b4\ub290\uc815\ub3c4\uc758 \uacbd\ub825\uc774 \uc5c6\uc73c\uba74
\n\uacf5\ubd80\ud558\uae30\uac00 \ucc38\uc73c\ub85c \ub09c\uac10\ud55c \ubd80\ubd84\uc785\ub2c8\ub2e4. \uac1c\uc778\uc801\uc73c\ub85c\ub294
\n\uc5b4\ub290\uc815\ub3c4 \uc218\uc900\uae4c\uc9c0\ub9cc \ud558\uc9c0\uace0, DB ADMIN\uc5d0\ub9cc \ub354 \uce58\uc911\uc744 \ud558\uae30\ub97c
\n\uad8c\uace0\ud569\ub2c8\ub2e4.<\/p>\n
\ud0c0 \uc11c\ubc84\uc6a9 OS:
\n(SOLARIS, HP-UX, RH LINUX, MS)
\n\uc774\uc911 \ucd5c\uc18c \ud558\ub098\ub294 \uad00\ub9ac\uc790 \uc218\uc900\uc758 \uc9c0\uc2dd\uc744 \uac00\uc838\uc57c \ud569\ub2c8\ub2e4.
\n\uadf8\ub9ac\uace0 \ub2e4\ub978 \ud558\ub098\uc758 OS\ub294 \ucd5c\uc18c \uc77c\ubc18 \uc0ac\uc6a9\uc790 \uc774\uc0c1\uc758 \uc9c0\uc2dd\uc744
\n\uc694\uad6c\ud569\ub2c8\ub2e4. \ub610\ud55c MS\ub294 \uc5b4\ub290\uc815\ub3c4 \uc774\uc0c1\uc758 \uc9c0\uc2dd\uc744 \uac00\uc9c0\uace0 \uc788\uc744
\n\uac83\uc774\ub77c \ubbf8\ub9ac \uc694\uad6c\ud569\ub2c8\ub2e4. \uadf8\ub7ed\uc800\ub7ed \ucd1d 3\uac1c\uc758 OS\uc5d0 \ub300\ud55c
\n\uc9c0\uc2dd\uc744 \ud544\uc694\ub85c \ud569\ub2c8\ub2e4.
\n(\ucd94\ucc9c\ud560 \ub9cc\ud55c OS\ub85c\ub294 SOLARIS\ud544\uc218, RH LINUX\uc120\ud0dd, MS \uc21c \uc785\ub2c8\ub2e4.<\/p>\n
\n=== \ucd94\ucc9c \uc9c0\uc2dd ==================================
\nOS SCRIPTING (PERL, SHELL), JAVA, \uc6f9 \uad00\ub828 \ud504\ub85c\uadf8\ub798\ubc0d, \uc6f9 \uc11c\ubc84 ,ERP
\nNETWORKING, SECURITY, \uae30\ud0c0 DB, \uacbd\uc601\ud559, \uacbd\uc81c\ud559 \ub4f1.<\/p>\n
\ud55c\ub9c8\ub514\ub85c \ub2e4\ub2e4\uc775\uc120\uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub2e4 \ud560\uc218\ub294 \uc5c6\ub294 \uac83\uc774\uc9c0\uc694.
\n\uc774\uc911 \ucd5c\uc18c OS SCRIPTING\uc911 \ud558\ub098\uc640 (PERL \ucd94\ucc9c), \uc5b4\ub290\uc815\ub3c4\uc758 JAVA\uc5d0
\n\ub300\ud55c \uae30\ubcf8\uc801\uc778 \uc9c0\uc2dd, \uadf8\ub9ac\uace0 NETWORKING\uc758 \uae30\ubcf8\uc801 \uc9c0\uc2dd\uc785\ub2c8\ub2e4.
\nMS-SQL\uac19\uc740 \uacbd\uc6b0\ub294 \uc624\ub77c\ud074\uc744 \uc5b4\ub290\uc815\ub3c4 \uacf5\ubd80\ud55c \ud6c4\uc5d0 \ubcf4\uc2dc\uac8c \ub418\uba74
\n\uc0c1\ub2f9\ud788 \uc27d\uac8c \uacf5\ubd80\ub97c \ud560\uc218 \uc788\uc5b4 \uac00\uae09\uc801\uc774\uba74 \ud558\uc2dc\ub77c\uace0 \ucd94\ucc9c\ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4.<\/p>\n
=== \ub85c\ub4dc\ub9f5\uc758 \uc608 ====================================
\n\ud558\ub8e8 \uc5ec\ub35f \uc2dc\uac04, \ubaa8\ub4c8 \ub2f9 2\uc8fc\ub85c \uacc4\uc0b0\uc744 \ud574\ubcf4\uc558\uc744 \ub54c\uc758 \ucd94\ucc9c \ub85c\ub4dc\ub9f5\uc785\ub2c8\ub2e4.<\/p>\n
\ud544\uc218 OS 1 -> \ud544\uc218 OS 2 -> SQL -> PL\/SQL -> DB ADMIN ->
\nBACKUP AND RECOVERY -> TUNING[-> JAVA & \uc120\ud0dd \uc9c0\uc2dd]<\/p>\n
\uc774\ubbf8 \uc544\uc2e4\ub7f0\uc9c0 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4\ub9cc VMWARE\ub97c \uc0ac\uc6a9\ud574\uc11c \ud0c0 OS\uc5d0 \uc624\ub77c\ud074\uc744
\n\uc124\uce58\ud55c \ud6c4, MS\uc5d0\uc11c \uc624\ub77c\ud074 DB\ub97c \uc561\uc138\uc2a4\ud558\ub294 \ud615\ud0dc\ub85c \uc0ac\uc6a9\ud558\uc2dc\ub294 \uac83\uc774
\n\uc624\ub77c\ud074\uc744 \uacf5\ubd80\ud558\uba74\uc11c \ub3d9\uc2dc\uc5d0 OS\uc5d0 \ub300\ud55c \uac83\ub3c4 \uc5b4\ub290\uc815\ub3c4 \ucee4\ubc84\ud560 \uc218\ub294
\n\ubc29\ubc95\uc785\ub2c8\ub2e4. \ubb3c\ub860 \uc120\ud0dd\ud558\uc2e0 OS\ub4e4\uc744 \ubcd1\uc6a9\ud574\uac00\uba74\uc11c \uc0ac\uc6a9\uc744 \ud574\uc57c \uaca0\uc9c0\uc694.<\/p>\n
\uac1c\uc778\uc801\uc73c\ub85c \uc0dd\uac01\ud558\uae30\uc5d0 \ucde8\uc5c5\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \ub9cc\ud55c \uc790\uaca9\uc99d\uc73c\ub85c\ub294
\nORACLE – DBA, SCSA (Sun Certified System Administrator) \uc815\ub3c4\uc785\ub2c8\ub2e4.
\nRHCE\ub294 \uadf9\uc545\ud55c \ub808\ubca8\ub85c SCSA\ubcf4\ub2e4 \ub530\uae30\uac00 \ub354 \uc5b4\ub835\uace0, MS\uad00\ub828 \uc790\uaca9\uc99d\uc740
\n\uc788\uc73c\uba74 \uc88b\uc9c0\ub9cc, \uadf8\ub2e5 \ub3c4\uc6c0\uc740 \uc548\ub41c\ub2e4\ub294 \uc0dd\uac01\uc785\ub2c8\ub2e4. \uadf8\uc678 SCJD\uc774\ub358\uac00?
\nSUN\uc5d0\uc11c \ub098\uc628 JAVA\uad00\ub828 \uc790\uaca9\uc99d\uacfc, CCNA, ORACLE – DEVELOPER
\n\uc815\ub3c4\uae4c\uc9c0\ub9cc \ud558\uc2e0\ub2e4\uba74 \uadf8\ub7ed\uc800\ub7ed \uc5b4\ub290\uc815\ub3c4 \uc900\ube44\uac00 \ub418\uc5c8\ub2e4…\ub77c\uace0 \uc0dd\uac01\ud569\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \uc774 \ubaa8\ub4e0 \uacfc\uc815\uc744 \ud63c\uc790\uc11c \uc9c0\ud0f1\ud558\uae30\ub780 \ubd88\uac00\ub2a5\ud55c \uac83\uc740 \uc544\ub2c8\uc9c0\ub9cc
\n\ucc38\uc73c\ub85c \ubc84\uac81\uc2b5\ub2c8\ub2e4. \ubbff\uc744 \uc218 \uc788\ub294 \uacf3\uc758 \uc7a5\uae30\uacfc\uc815\uc774\ub098, \uce74\ud398\uc5d0\uc11c
\n\uc2a4\ud130\ub514 \uadf8\ub8f9\uc744 \ucc3e\uc544 \ub3d9\ucc38\ud558\uc2dc\uae30\ub97c \ucd94\ucc9c\ud569\ub2c8\ub2e4. \ud2b9\ud788\ub098 \uc2a4\ud130\ub514 \uadf8\ub8f9\uc740
\n\uc6b4\ub9cc \uc88b\ub2e4\uba74 \ud604\uc5c5\uc790\ub098 \uacf5\uc778\uac15\uc0ac\ub4e4\uc774 \uc8fc\uccb4\uac00 \ub418\uc5b4 \uc5f4\ub9ac\uae30\ub3c4 \ud558\ub2c8
\n\ucc3e\uc544\ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. \uc7a5\uae30 \uacfc\uc815\uc744 \uc120\ud0dd\ud558\uc2e0\ub2e4\uba74 \ub2e8\uc21c\ud788 \uacfc\uc815\uc744
\n\ub530\ub77c\uac00\ub294 \uac83\ub9cc\uc744 \ubaa9\ud45c\ud558\uc2dc\uae30 \ubcf4\ub2e4\ub294 \uc9dc\ud22c\ub9ac \uc2dc\uac04\uc5d0 \ub098\ub984\ub300\ub85c
\n\ud63c\uc790 \uba87\uac00\uc9c0 \ub354 \uacf5\ubd80\ub97c \ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n
\uc88b\uc740 \uacb0\uacfc \uc5bb\uc73c\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
ORACLE – DBA \ub97c \ubaa9\ud45c\ub85c \ud558\uc600\uc744 \ub54c === \ud544\uc218 \uc9c0\uc2dd ================================== SQL, PL\/SQL, DB ADMIN, BACKUP AND RECOVERY (RMAN), TUNING, \uc11c\ubc84\uc6a9 OS \ub450\uac00\uc9c0. SQL, PL\/SQL : \ub2e8\uc21c\ud788 \uc0ac\uc6a9\ud560 \uc904 \uc548\ub2e4\ub77c\ub294 \uc218\uc900\ubcf4\ub2e4\ub294 \uac80\ud1a0 \ubc0f, \uc5b4\ub290\uc815\ub3c4\uc758 \ud29c\ub2dd\uae4c\uc9c0\ub3c4 \uac00\ub2a5\ud574\uc57c \ud569\ub2c8\ub2e4. \uc5b4\ub514\uc758 \uacfc\uc815\uc744 \ub4e4\uc73c\uc2dc\uc9c0\ub294 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4\ub9cc, \uc77c\ub2e8 9i-DBA \uacfc\uc815\uc758 \ub9f9\uc810\uc774 PL\/SQL\uc758 \ubd80\uc7ac\uc785\ub2c8\ub2e4. \uae30\uc874 8i\uacfc\uc815\uc5d0\ub294 \ub4e4\uc5b4\uc788\ub2e4\uace0 9i-DEV\ub85c \ubd84\ub9ac\uc2dc\ud0a4\uba74\uc11c DBA\uacfc\uc815\uc5d0\ub294 \uc81c\uc678\uac00 \ub418\uc5c8\ub294\ub370 … ORACLE – DBA \ub97c \ubaa9\ud45c\ub85c \ud558\uc600\uc744 \ub54c<\/span> \ub354\ubcf4\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-269","post","type-post","status-publish","format-standard","hentry","category-18"],"_links":{"self":[{"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/posts\/269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=269"}],"version-history":[{"count":0,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/posts\/269\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}