ebook 158-1

Size: px

Start display at page:

Download "ebook 158-1"

贯巴
9 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

Microsoft PowerPoint - 06 - ShengYang Presentation Slides_240609

Microsoft PowerPoint - 06 - ShengYang Presentation Slides_240609 沈阳水务一体化发展的探索水允办简行各资许表要业位很源我示介的嘉荣周代热绍基宾幸, 表烈一本再女并沈的下情次士有阳祝沈况来 : 们机水贺阳到! 会务的美先下与集城丽生面各团市的, 们位对概狮 : 我交活况城向流动和大参在