Kwi-Intanethi yeWebhusayithi liqela labantu abasebenza dati kwaye uqhubeke idatha enkulu. Siyazicingela idatha inzululwazi. Sisebenza njenge-Remote Oracle database kwaye sinikezela ngokuSebenzisa database. Mna dati zioyile zewaka leminyaka elitsha, kodwa sichitha ixesha nemali kuzo mgangatho wedatha kutheni a dato engekho kumgangatho lixabiso kwinkampani nakwifayile ye- dati yexabiso kufuneka lihlawule kancinci nangaphantsi. Ekude DBA Iingcali | Ekude DBA Iinkonzo | Ukude Umlawuli weDatabase | Ekude DBA | UStefano Fantin.
Iingcali zethu zinokwenza yonke imisebenzi eyimfuneko efana ne-Oracle DBA yesiqhelo:
Ukufakwa kwe-Oracle, ukucwangciswa kunye nokugcinwa database;
Ukucwangciswa koqwalaselo kunye nolawulo lwefayile ye- sedata
-Yenza uKhuseleko loMsebenzisi kunye noLawulo lokuFikelela, sedata Uphicotho-zincwadi;
Ukucwangciswa kunye nokugcinwa koqwalaselo lokuFumaneka okuPhezulu (i-RAC, i-Standby Data Guard);
-Umzekelo wokuCwangciswa kokuSebenza, i-SQL kunye ne-PL / SQL;
- Isivusi: Ukubeka iliso kunye nolawulo lwempilo lwe sedata;
- Intlekele database: ukucwangcisa kwakhona;
-Ukubeka iliso kwiinkqubo ezicwangcisiweyo;
Ngenkxaso yeDBA ekude ufumana:
- Iindleko ezifanelekileyo kwisisombululo solawulo sedata;
-Uchwephesha we-DBA ongazange ashiye inkampani yakho eyedwa kwi-Oracle yomhlaba omkhulu;
-Inkxaso esebenzayo ye sedata Umlomo;
-Ukuqala ngokukhawuleza kwayo nayiphi na iprojekthi ngeOracle database;
-Inkonzo yokubonisana nabayili bezakhiwo zakho, abaphuhlisi kunye nabalawuli ukuze basebenzise ngokuchanekileyo amanqaku e-Oracle database uyilo lwehardware;
Ukukhutshelwa ngaphandle kuvumela:
- Iindleko ezifanelekileyo kwisisombululo solawulo sedata;
-Uchwephesha we-DBA ongazange ashiye inkampani yakho eyedwa kwi-Oracle yomhlaba omkhulu;
-Inkxaso esebenzayo ye sedata Umlomo;
-Ukuqala ngokukhawuleza kwayo nayiphi na iprojekthi ngeOracle database;
-Inkonzo yokubonisana nabayili bezakhiwo zakho, abaphuhlisi kunye nabalawuli ukuze basebenzise ngokuchanekileyo amanqaku e-Oracle database kunye nolwakhiwo lwezixhobo zekhompyutha.
Kwi-Intanethi yeWebhusayithi unezifundo zobugcisa ezinje nge-Oracle DBA:
- Ekude DBA Oracle 8i: webDB, isishwankathelo, DBMS_REPAIR, logMiner, DROP ikholamu, LMT, umsebenzi weTRIM, izahlulo ze-MERGE, HASH kunye nezahlulo zeCOSOSITE
- Ekude DBA Oracle 9i: ixesha lokuqalisa kwakhona elisekwe ngokukhawuleza, Umbuzo weFlashback, uLwabiwo lwesiNdawo esiHlaziyiweyo, uKubuyiswa kovavanyo, uLondolozo lwedatha, ukwakhiwa kwakhona kwesalathiso kwi-Intanethi, Ukuchazwa kwakhona kwetafile kwi-Intanethi, I-SPFILE, iitafile zangaphandle, i-ASSM, i-Oracle RAC, i-OMF
- Ekude DBA Oracle 10g: Idatha yokuThumela, i-AWR, i-ASH, i-ADDM, uMcebisi we-Tunquing we-SQL, ishedyuli ye-Oracle, Shrink yeCandelo, uMcebisi weCandelo, i-BFT, indawo yokubuyiselwa kweFlash
- Ekude DBA Oracle 11g: I-DNFS, ukukhatshwa kwi-Intanethi, i-ASM yokuKhangela okuKhawulezayo kweMirror, md_backup, md_restore, itemplate yesiseko se-AWR, Umlindi weFayile, i-AMM, INCREMENTAL kunye nePENDING Statistics, Ukwahlula ixesha lokuphumla
- Ekude DBA database Oracle 12c: Isikhongozeli semultitenant database, CDB, PDB, ADO, Ubushushu beMephu, Ubungakanani bePGA Limit, DBMS_QOPATCH, Ukugcina iTheyibhile enkulu ngokuZenzekelayo, kwi-In-Memory (IM) Ivenkile yeKholamu
Ukubonisana sedata Ummiselo:
Ukulungiswa kokusebenza: uphuculo lwendlela yokusebenza ye- sedata I-Oracle, ukuqina: ukunciphisa umngcipheko wokusebenza okuphantsi,
yandisa okanye ulinganisele iiprojekthi idatha enkulu nge sedata Oracle
- uhlalutyo sedata kunye noyilo sedata
Ugcino lwe-DBA
- ukhuseleko lwe sedata I-Oracle: Uhlalutyo lobungozi, ukuNgqinelwa kweNgxelo yoPhicotho
- ukubeka iliso sedata Oracle
Ukuphunyezwa kweempawu ze-Oracle:
-ASM (uLawulo loGcino oluzenzekelayo)
-RMAN (Umphathi wokubuyisela)
-I-TDE (Ukubhaliweyo okungafihliyo kweDatha)
-I-SPM (uLawulo lweSicwangciso seSql)
Ukuchazwa kwakhona kwi-Intanethi
- ulwahlulo
Ucinezelo
Umphathi wezixhobo
- Flashback
Imijelo
Ukuvavanywa kwesicelo sokwenyani
- Isango
- Ukhuseleko oluPhambili
Gcina uKhuseleko
Ekude DBA Iingcali | Ekude DBA Iinkonzo | Ukude Umlawuli weDatabase | Ekude DBA | UStefano Fantin. Mna dati zioyile zewaka leminyaka elitsha, kodwa sichitha ixesha nemali kuzo mgangatho wedatha kutheni a dato engekho kumgangatho lixabiso kwinkampani nakwifayile ye- dati yexabiso kufuneka lihlawule kancinci nangaphantsi.
Siwenza ngocoselelo umsebenzi wobugcisa umlawuli weenkcukacha.
Iingcali zethu zinokwenza yonke imisebenzi eyimfuneko efana ne-Oracle DBA yesiqhelo:
Ukufakwa kwe-Oracle, ukucwangciswa kunye nokugcinwa database;
Ukucwangciswa koqwalaselo kunye nolawulo lwefayile ye- sedata
-Yenza uKhuseleko loMsebenzisi kunye noLawulo lokuFikelela, sedata Uphicotho-zincwadi;
Ukucwangciswa kunye nokugcinwa koqwalaselo lokuFumaneka okuPhezulu (i-RAC, i-Standby Data Guard);
-Umzekelo wokuCwangciswa kokuSebenza, i-SQL kunye ne-PL / SQL;
- Isivusi: Ukubeka iliso kunye nolawulo lwempilo lwe sedata;
- Intlekele database: ukucwangcisa kwakhona;
-Ukubeka iliso kwiinkqubo ezicwangcisiweyo.
Kwi-Intanethi yeWebhusayithi unezifundo zobugcisa ezinje nge-Oracle DBA:
- Ekude DBA Oracle 8i: webDB, isishwankathelo, DBMS_REPAIR, logMiner, DROP ikholamu, LMT, umsebenzi weTRIM, izahlulo ze-MERGE, HASH kunye nezahlulo zeCOSOSITE
- Ekude DBA Oracle 9i: ixesha lokuqalisa kwakhona elisekwe ngokukhawuleza, Umbuzo weFlashback, uLwabiwo lwesiNdawo esiHlaziyiweyo, uKubuyiswa kovavanyo, uLondolozo lwedatha, ukwakhiwa kwakhona kwesalathiso kwi-Intanethi, Ukuchazwa kwakhona kwetafile kwi-Intanethi, I-SPFILE, iitafile zangaphandle, i-ASSM, i-Oracle RAC, i-OMF
- Ekude DBA Oracle 10g: Idatha yokuThumela, i-AWR, i-ASH, i-ADDM, uMcebisi we-Tunquing we-SQL, ishedyuli ye-Oracle, Shrink yeCandelo, uMcebisi weCandelo, i-BFT, indawo yokubuyiselwa kweFlash
- Ekude DBA Oracle 11g: I-DNFS, ukukhatshwa kwi-Intanethi, i-ASM yokuKhangela okuKhawulezayo kweMirror, md_backup, md_restore, itemplate yesiseko se-AWR, Umlindi weFayile, i-AMM, INCREMENTAL kunye nePENDING Statistics, Ukwahlula ixesha lokuphumla
- Ekude DBA database Oracle 12c: Isikhongozeli semultitenant database, CDB, PDB, ADO, Ubushushu beMephu, Ubungakanani bePGA Limit, DBMS_QOPATCH, Ukugcina iTheyibhile enkulu ngokuZenzekelayo, kwi-In-Memory (IM) Ivenkile yeKholamu
Ukubonisana sedata Ummiselo:
Ukulungiswa kokusebenza: uphuculo lwendlela yokusebenza ye- sedata I-Oracle, ukuqina: ukunciphisa umngcipheko wokusebenza okuphantsi,
yandisa okanye ulinganisele iiprojekthi idatha enkulu nge sedata Oracle
- uhlalutyo sedata kunye noyilo sedata
Ugcino lwe-DBA
- ukhuseleko lwe sedata I-Oracle: Uhlalutyo lobungozi, ukuNgqinelwa kweNgxelo yoPhicotho
- ukubeka iliso sedata Oracle
Ukuphunyezwa kweempawu ze-Oracle:
-ASM (uLawulo loGcino oluzenzekelayo)
-RMAN (Umphathi wokubuyisela)
-I-TDE (Ukubhaliweyo okungafihliyo kweDatha)
-I-SPM (uLawulo lweSicwangciso seSql)
Ukuchazwa kwakhona kwi-Intanethi
- ulwahlulo
Ucinezelo
Umphathi wezixhobo
- Flashback
Imijelo
Ukuvavanywa kwesicelo sokwenyani
- Isango
- Ukhuseleko oluPhambili
Gcina uKhuseleko
Fumana okungakumbi kwi-Arhente yeWebhu ye-Intanethi
Bhalisa ukuze ufumane amanqaku amva nje nge-imeyile.