ebook 158-1

Size: px

Start display at page:

Download "ebook 158-1"

贯巴
7 years ago
Views:

1 I TInformation Te c h n o l o g y / DBA (Data Base Administrator, ) O r a c l e D B A O r a c l e 8O r a c l e 8 i D B A O r a c l e 7 O r a c l e O r a c l e 7O r a c l e O r a c l e 7 O r a c l e 8 90

2 / A u t l b s t a t / u t l e s t a t 10 ( ) D B A D B A CIO ( ) i n i t. o r a U N I X D ATAI N D E X 16 6

3 C I O Wo o d r i d g e B ( ) 247 O r a c l e U N I X B 08 : : : : : : : : : : : : : : A 247 B (1) /

4 4 VA L I D ATE STRUCTURE / b u g b u g O r a c l e m a l l o c () f r e e ( O r a c l e 247 O r a c l e O r a c l e O r a c l e (2) 1-1 RAID 0 RAID / RAID 1 I / O U N R E C O V E R A B L E N O L O G G I N G U N R E C O V E R A B L E / N O L O G G I N G

5 1 5 C R E ATE INDEX U N R E C O V E R A B L E N O L O G G I N G U N R E C O V E R A B L E C H E C K P O I N T 90% % 1-1 U N R E C O V E R A B L E / N O L O G G I N G O r a c l e 8 i D M L O r a c l e 8 i UNRECOVERABLE/NOLOGGING U N R E C O V E R A B L E / N O L O G G I N G

6 6 1-3 RECOVERABLE/LOGGING 2 R E C O V E R A B L E / L O G G I N G U N R E C O V E R A B L E R E C O V E R A B L E / 7 D B A S TO R A G E 247 (3) 1-2

7 I T I T / / ( (replication) O r a c l e Advanced Replication O r a c l e Advanced Replication R r e p l i c a t i o n O r a c l e Advanced Replication )

8 / / /

9 / $5 000 $ Order Entry (Bill of Materials) ( A c c o u n t i n g ) D B A 1-3 D B A DBMS O r a c l e

10 10 OS D B M S DBMS 1-3 O r a c l e Raw Iron 247 D B A O r a c l e O r a c l e O r a c l e NT D B A O r a c l e O r a c l e O r a c l O r a c l e D B M S O r a c l e

11 1 11 D B A D B A D B A D B A We b 247 O r a c l e (swap, ) DBMS D B M S b u g D B M S O r a c l e 1.1.3

12 12 1. CIO ( ) D B A 2. / b u g b u g b u g b u g U N I XN T / D B A M T B FMean Ti m e Between Failure M T B F M T B M T B F D B A

14 S L AService Level Agreement S L A S L A S L A / S L A S L A S L A S L A S L A S L A

15 1 15 V PC E O S L A S L A S L A S L A S L A 1. S L A S L A 200 S L A 2. S L A X Y S L A XY S L A S L A B A B C D 3. S L A S L S L A S L A S L S L A S L A S L A S L A

16 16 G u e s t S L A S L A S L S L A S L 4. S L A S L A S L A S L A : : : : : : : : 0 0 D B A D B A 5. S L A S L S L A 247 S L A

17 S L A M T B F M T T R M T B F 600 M T B F6 00 M T B F M T B F M T B F M T B F M T B F M T B F M T B F M T B F M T B F M T B F A B C S u n Enterprise 4000 O r a c l e 8 EMC 3100 R A I D - S M T B F M T B F / / / 24 / 3 10 A B C M T B F 10 M T B F M T B C P U M T B F M T B F M T B M T T RMean Time to Recover M T T R O r a c l e M T T R 8

18 / M T B F M T T R S L A S L A

19 / 247 proactive maintenance (extent, ) MAXEXTENTS reached O r a c l e Optimal Flexible ArchitectureO FA D ATA 3 M B 5 M O R A Unable to allocate bytes in tablespace (DATA D C I O D ATA c a t c h

20 20 S L A 1-7 S L A Ye s Ye s N o Ye s N o / N o u t l b s t a tu t l e s t a t N o F R E E L I S T S I N I T R A N SP C T U S E DP C T F R E E i n i t. o r a Ye s N o Ye s N o N o N o Ye s / N o

21 D B A D B A D B A / 247 D B A We b We 80 G B D B A : : 00 Susan MD B A Marty GD B A Joe A Michelle P Rob F Dave S Brain G

22 22 07 : 00 ~ 15 : 00 Peter H / Sam J D B A Bill K 15 : : 00 Sam J D B A Lucas SD B A Thomas A Vladimir P Bill T Patti N Susan MD B A Rob F 19 : : 00 Sam J D B A Lucas SD B A Thomas A Vladimir P Patti N / Marty G D B A Joe A 23 : : 00 John LD B A Lisa W Lucas SD B A Vladimir P D B A D B A

23 1 23 D B A 1-8 Susan M S u s a n 247 C I O O M B o b C I OJ e ff O M J e ff C I O L i s a O M L i s a 20 C I O J e ff O M J e ff J o e D B A 0. 5 J e ff A 0. 5 Christine L 1. 0 Sheila P C I O 1. 0 Greg S V P 2. 0 Timothy S V P 2. 0 Leslie G C E O V P

24 24 C E O C E O D B A We b S L A

2 职业核心知识 ( 66 学分 ) 经营环境分析财务管理实务管理学基础统计学基础初级会计中级会计企业制度设计出纳实务审计基础与实务职业资格培训 ( 第三五学期 ) 0 7.5

2 职业核心知识 ( 66 学分 ) 经营环境分析财务管理实务管理学基础统计学基础初级会计中级会计企业制度设计出纳实务审计基础与实务职业资格培训 ( 第三五学期 ) 0 7.5 会计专业人才培养方案一人才培养目标与基本要求 ( 一 ) 人才培养目标本专业培养德智体美等方面全面发展, 拥护党的基本路线, 具有会计专业理论知识和较强的职业技能及岗位实际工作能力能够从事会计核算财务管理投资理财税务